public interface ConditionalFormattingRule
| Modifier and Type | Field and Description |
|---|---|
static byte |
CONDITION_TYPE_CELL_VALUE_IS
Deprecated.
|
static byte |
CONDITION_TYPE_FORMULA
Deprecated.
|
| Modifier and Type | Method and Description |
|---|---|
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
CONDITION_TYPE_CELL_VALUE_IS |
byte |
getConditionType()
Deprecated.
|
ConditionType |
getConditionTypeType()
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
CONDITION_TYPE_CELL_VALUE_IS and operator
is either ComparisonOperator.BETWEEN or ComparisonOperator.NOT_BETWEEN |
IconMultiStateFormatting |
getMultiStateFormatting() |
PatternFormatting |
getPatternFormatting() |
static final byte CONDITION_TYPE_CELL_VALUE_IS
ConditionType.CELL_VALUE_ISstatic final byte CONDITION_TYPE_FORMULA
ConditionType.FORMULABorderFormatting 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 otherwisebyte getConditionType()
getConditionTypeType()
MUST be one of the IDs of a ConditionType
ConditionType getConditionTypeType()
byte getComparisonOperation()
CONDITION_TYPE_CELL_VALUE_IS
MUST be a constant from ComparisonOperator
java.lang.String getFormula1()
If the condition type is CONDITION_TYPE_CELL_VALUE_IS,
this field is the first operand of the comparison.
If type is CONDITION_TYPE_FORMULA, this formula is used
to determine if the conditional formatting is applied.
If comparison type is CONDITION_TYPE_FORMULA the formula MUST be a Boolean function
java.lang.String getFormula2()
CONDITION_TYPE_CELL_VALUE_IS and operator
is either ComparisonOperator.BETWEEN or ComparisonOperator.NOT_BETWEENCopyright 2017 The Apache Software Foundation or its licensors, as applicable.