FormatConditionModel

Overview

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

Represents a format condition model used in Excel conditional formatting.

This class provides 52 methods for working with FormatConditionModel objects in Java programs. Available methods include: getAbove, getBarColor, getBarLength, getColorScaleCount, getDirection, getDuplicate, getFormula1, getFormula2, getIconSetType, getMaxColor, getMidColor, getMinColor, and 40 additional methods. All exported members are accessible to any Java application after installing the Aspose.Cells FOSS for Java package. Properties: above, barColor, barLength, colorScaleCount, direction, duplicate, and 20 more.

Description

FormatConditionModel is a class in the Aspose.Cells FOSS library for Java that exposes 52 methods and 26 properties for programmatic use.

Core capabilities include: formatconditiontype; operatortype; string. These operations enable developers to integrate formatconditionmodel functionality directly into Java applications.

The class also provides the type property (returns the type), the operator property (returns the operator), the formula1 property (returns the formula 1).

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.
`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`	`ColorValue`	Read	Returns the min color.
`midColor`	`ColorValue`	Read	Returns the mid color.
`maxColor`	`ColorValue`	Read	Returns the max color.
`barColor`	`ColorValue`	Read	Returns the bar color.
`negativeBarColor`	`ColorValue`	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`	`StyleValue`	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(formula1: String)`	Sets the formula 1.
`getFormula2()` → `String`	Returns the formula 2.
`setFormula2(formula2: String)`	Sets the formula 2.
`getTimePeriod()` → `String`	Returns the time period.
`setTimePeriod(timePeriod: 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()` → `ColorValue`	Returns the min color.
`setMinColor(minColor: ColorValue)`	Sets the min color.
`getMidColor()` → `ColorValue`	Returns the mid color.
`setMidColor(midColor: ColorValue)`	Sets the mid color.
`getMaxColor()` → `ColorValue`	Returns the max color.
`setMaxColor(maxColor: ColorValue)`	Sets the max color.
`getBarColor()` → `ColorValue`	Returns the bar color.
`setBarColor(barColor: ColorValue)`	Sets the bar color.
`getNegativeBarColor()` → `ColorValue`	Returns the negative bar color.
`setNegativeBarColor(negativeBarColor: ColorValue)`	Sets the negative bar color.
`getShowBorder()` → `boolean`	Returns the show border.
`setShowBorder(showBorder: boolean)`	Sets the show border.
`getDirection()` → `String`	Returns the direction.
`setDirection(direction: String)`	Sets the direction.
`getBarLength()` → `String`	Returns the bar length.
`setBarLength(barLength: String)`	Sets the bar length.
`getIconSetType()` → `String`	Returns the icon set type.
`setIconSetType(iconSetType: 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()` → `StyleValue`	Returns the style.
`setStyle(style: StyleValue)`	Sets the style.

FormatConditionModel

Overview

Description

Properties

Methods

See Also