FormatCondition

Overview

FormatCondition is a class in Aspose.Cells FOSS for Java.

Represents a conditional formatting rule.

Properties

Name	Type	Access	Description
`type`	`FormatConditionType`	Read	Returns the type.
`operator`	`OperatorType`	Read	Returns the operator.
`formula1`	`String`	Read	Returns the formula 1.
`formula2`	`String`	Read	Returns the formula 2.
`formula`	`String`	Read	Returns the formula.
`timePeriod`	`String`	Read	Returns the time period.
`duplicate`	`boolean`	Read	Returns the duplicate.
`top`	`boolean`	Read	Returns the top.
`percent`	`boolean`	Read	Returns the percent.
`rank`	`int`	Read	Returns the rank.
`above`	`boolean`	Read	Returns the above.
`standardDeviation`	`int`	Read	Returns the standard deviation.
`colorScaleCount`	`int`	Read	Returns the color scale count.
`minColor`	`Color`	Read	Returns the min color.
`midColor`	`Color`	Read	Returns the mid color.
`maxColor`	`Color`	Read	Returns the max color.
`barColor`	`Color`	Read	Returns the bar color.
`negativeBarColor`	`Color`	Read	Returns the negative bar color.
`showBorder`	`boolean`	Read	Returns the show border.
`direction`	`String`	Read	Returns the direction.
`barLength`	`String`	Read	Returns the bar length.
`iconSetType`	`String`	Read	Returns the icon set type.
`reverseIcons`	`boolean`	Read	Returns the reverse icons.
`showIconOnly`	`boolean`	Read	Returns the show icon only.
`priority`	`int`	Read	Returns the priority.
`stopIfTrue`	`boolean`	Read	Returns the stop if true.
`style`	`Style`	Read	Returns the style.

Methods

Signature	Description
`getType()` → `FormatConditionType`	Returns the type.
`setType(type: FormatConditionType)`	Sets the type.
`getOperator()` → `OperatorType`	Returns the operator.
`setOperator(operator: OperatorType)`	Sets the operator.
`getFormula1()` → `String`	Returns the formula 1.
`setFormula1(value: String)`	Sets the formula 1.
`getFormula2()` → `String`	Returns the formula 2.
`setFormula2(value: String)`	Sets the formula 2.
`getFormula()` → `String`	Returns the formula.
`setFormula(value: String)`	Sets the formula.
`getTimePeriod()` → `String`	Returns the time period.
`setTimePeriod(value: String)`	Sets the time period.
`getDuplicate()` → `boolean`	Returns the duplicate.
`setDuplicate(duplicate: boolean)`	Sets the duplicate.
`getTop()` → `boolean`	Returns the top.
`setTop(top: boolean)`	Sets the top.
`getPercent()` → `boolean`	Returns the percent.
`setPercent(percent: boolean)`	Sets the percent.
`getRank()` → `int`	Returns the rank.
`setRank(rank: int)`	Sets the rank.
`getAbove()` → `boolean`	Returns the above.
`setAbove(above: boolean)`	Sets the above.
`getStandardDeviation()` → `int`	Returns the standard deviation.
`setStandardDeviation(standardDeviation: int)`	Sets the standard deviation.
`getColorScaleCount()` → `int`	Returns the color scale count.
`setColorScaleCount(colorScaleCount: int)`	Sets the color scale count.
`getMinColor()` → `Color`	Returns the min color.
`setMinColor(value: Color)`	Sets the min color.
`getMidColor()` → `Color`	Returns the mid color.
`setMidColor(value: Color)`	Sets the mid color.
`getMaxColor()` → `Color`	Returns the max color.
`setMaxColor(value: Color)`	Sets the max color.
`getBarColor()` → `Color`	Returns the bar color.
`setBarColor(value: Color)`	Sets the bar color.
`getNegativeBarColor()` → `Color`	Returns the negative bar color.
`setNegativeBarColor(value: Color)`	Sets the negative bar color.
`getShowBorder()` → `boolean`	Returns the show border.
`setShowBorder(showBorder: boolean)`	Sets the show border.
`getDirection()` → `String`	Returns the direction.
`setDirection(value: String)`	Sets the direction.
`getBarLength()` → `String`	Returns the bar length.
`setBarLength(value: String)`	Sets the bar length.
`getIconSetType()` → `String`	Returns the icon set type.
`setIconSetType(value: String)`	Sets the icon set type.
`getReverseIcons()` → `boolean`	Returns the reverse icons.
`setReverseIcons(reverseIcons: boolean)`	Sets the reverse icons.
`getShowIconOnly()` → `boolean`	Returns the show icon only.
`setShowIconOnly(showIconOnly: boolean)`	Sets the show icon only.
`getPriority()` → `int`	Returns the priority.
`setPriority(priority: int)`	Sets the priority.
`getStopIfTrue()` → `boolean`	Returns the stop if true.
`setStopIfTrue(stopIfTrue: boolean)`	Sets the stop if true.
`getStyle()` → `Style`	Returns the style.
`setStyle(value: Style)`	Sets the style.
`remove()`	Removes the requested content.