|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface ConditionalFormattingRule
Represents a description of a conditional formatting rule
Method Summary | |
---|---|
BorderFormatting |
createBorderFormatting()
Create a new border formatting structure if it does not exist, otherwise just return existing object. |
FontFormatting |
createFontFormatting()
Create a new font formatting structure if it does not exist, otherwise just return existing object. |
PatternFormatting |
createPatternFormatting()
Create a new pattern formatting structure if it does not exist, otherwise just return existing object. |
BorderFormatting |
getBorderFormatting()
|
ColorScaleFormatting |
getColorScaleFormatting()
|
byte |
getComparisonOperation()
The comparison function used when the type of conditional formatting is set to ConditionType.CELL_VALUE_IS |
ConditionType |
getConditionType()
Type of conditional formatting rule. |
DataBarFormatting |
getDataBarFormatting()
|
FontFormatting |
getFontFormatting()
|
java.lang.String |
getFormula1()
The formula used to evaluate the first operand for the conditional formatting rule. |
java.lang.String |
getFormula2()
The formula used to evaluate the second operand of the comparison when comparison type is ConditionType.CELL_VALUE_IS and operator
is either ComparisonOperator.BETWEEN or ComparisonOperator.NOT_BETWEEN |
IconMultiStateFormatting |
getMultiStateFormatting()
|
PatternFormatting |
getPatternFormatting()
|
Method Detail |
---|
BorderFormatting createBorderFormatting()
null
.BorderFormatting getBorderFormatting()
null
otherwiseFontFormatting createFontFormatting()
null
.FontFormatting getFontFormatting()
null
otherwisePatternFormatting createPatternFormatting()
null
.PatternFormatting getPatternFormatting()
null
otherwiseDataBarFormatting getDataBarFormatting()
null
otherwiseIconMultiStateFormatting getMultiStateFormatting()
null
otherwiseColorScaleFormatting getColorScaleFormatting()
null
otherwiseConditionType getConditionType()
byte getComparisonOperation()
ConditionType.CELL_VALUE_IS
MUST be a constant from ComparisonOperator
java.lang.String getFormula1()
If the condition type is ConditionType.CELL_VALUE_IS
,
this field is the first operand of the comparison.
If type is ConditionType.FORMULA
, this formula is used
to determine if the conditional formatting is applied.
If comparison type is ConditionType.FORMULA
the formula MUST be a Boolean function
java.lang.String getFormula2()
ConditionType.CELL_VALUE_IS
and operator
is either ComparisonOperator.BETWEEN
or ComparisonOperator.NOT_BETWEEN
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |