public interface ConditionalFormattingRule
Modifier and Type | Field and Description |
---|---|
static byte |
CONDITION_TYPE_CELL_VALUE_IS
This conditional formatting rule compares a cell value
to a formula calculated result, using an operator
|
static byte |
CONDITION_TYPE_FORMULA
This conditional formatting rule contains a formula to evaluate.
|
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() |
byte |
getComparisonOperation()
The comparison function used when the type of conditional formatting is set to
CONDITION_TYPE_CELL_VALUE_IS
MUST be a constant from ComparisonOperator
|
byte |
getConditionType()
Type of conditional formatting rule.
|
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 |
PatternFormatting |
getPatternFormatting() |
static final byte CONDITION_TYPE_CELL_VALUE_IS
static final byte CONDITION_TYPE_FORMULA
BorderFormatting createBorderFormatting()
null
.BorderFormatting getBorderFormatting()
null
otherwiseFontFormatting createFontFormatting()
null
.FontFormatting getFontFormatting()
null
otherwisePatternFormatting createPatternFormatting()
null
.PatternFormatting getPatternFormatting()
null
otherwisebyte getConditionType()
MUST be either CONDITION_TYPE_CELL_VALUE_IS
or CONDITION_TYPE_FORMULA
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_BETWEEN
Copyright © 2005-2010 Potix Corporation. All Rights Reserved.