public final class HSSFConditionalFormattingRule extends java.lang.Object implements ConditionalFormattingRule
CONDITION_TYPE_CELL_VALUE_IS, CONDITION_TYPE_FORMULA| Modifier and Type | Method and Description |
|---|---|
HSSFBorderFormatting |
createBorderFormatting()
create a new border formatting structure if it does not exist,
otherwise just return existing object.
|
HSSFColorScaleFormatting |
createColorScaleFormatting()
create a new color scale / gradient formatting object if it does not exist,
otherwise just return the existing object.
|
HSSFDataBarFormatting |
createDataBarFormatting()
create a new databar / data-bar formatting object if it does not exist,
otherwise just return the existing object.
|
HSSFFontFormatting |
createFontFormatting()
create a new font formatting structure if it does not exist,
otherwise just return existing object.
|
HSSFIconMultiStateFormatting |
createMultiStateFormatting()
create a new icon / multi-state formatting object if it does not exist,
otherwise just return the existing object.
|
HSSFPatternFormatting |
createPatternFormatting()
create a new pattern formatting structure if it does not exist,
otherwise just return existing object.
|
HSSFBorderFormatting |
getBorderFormatting() |
HSSFColorScaleFormatting |
getColorScaleFormatting() |
byte |
getComparisonOperation()
The comparison function used when the type of conditional formatting is set to
ConditionalFormattingRule.CONDITION_TYPE_CELL_VALUE_IS |
byte |
getConditionType()
Type of conditional formatting rule.
|
ConditionType |
getConditionTypeType()
Type of conditional formatting rule.
|
HSSFDataBarFormatting |
getDataBarFormatting() |
HSSFFontFormatting |
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
ConditionalFormattingRule.CONDITION_TYPE_CELL_VALUE_IS and operator
is either ComparisonOperator.BETWEEN or ComparisonOperator.NOT_BETWEEN |
HSSFIconMultiStateFormatting |
getMultiStateFormatting() |
HSSFPatternFormatting |
getPatternFormatting() |
protected java.lang.String |
toFormulaString(Ptg[] parsedExpression) |
protected static java.lang.String |
toFormulaString(Ptg[] parsedExpression,
HSSFWorkbook workbook) |
public HSSFFontFormatting getFontFormatting()
getFontFormatting in interface ConditionalFormattingRulenull otherwisepublic HSSFFontFormatting createFontFormatting()
createFontFormatting in interface ConditionalFormattingRulenull.public HSSFBorderFormatting getBorderFormatting()
getBorderFormatting in interface ConditionalFormattingRulenull otherwisepublic HSSFBorderFormatting createBorderFormatting()
createBorderFormatting in interface ConditionalFormattingRulenull.public HSSFPatternFormatting getPatternFormatting()
getPatternFormatting in interface ConditionalFormattingRulenull otherwisepublic HSSFPatternFormatting createPatternFormatting()
createPatternFormatting in interface ConditionalFormattingRulenull.public HSSFDataBarFormatting getDataBarFormatting()
getDataBarFormatting in interface ConditionalFormattingRulenull otherwisepublic HSSFDataBarFormatting createDataBarFormatting()
public HSSFIconMultiStateFormatting getMultiStateFormatting()
getMultiStateFormatting in interface ConditionalFormattingRulenull otherwisepublic HSSFIconMultiStateFormatting createMultiStateFormatting()
public HSSFColorScaleFormatting getColorScaleFormatting()
getColorScaleFormatting in interface ConditionalFormattingRulenull otherwisepublic HSSFColorScaleFormatting createColorScaleFormatting()
public byte getConditionType()
ConditionalFormattingRule
MUST be one of the IDs of a ConditionType
getConditionType in interface ConditionalFormattingRulepublic ConditionType getConditionTypeType()
ConditionalFormattingRulegetConditionTypeType in interface ConditionalFormattingRulepublic byte getComparisonOperation()
ConditionalFormattingRuleConditionalFormattingRule.CONDITION_TYPE_CELL_VALUE_IS
MUST be a constant from ComparisonOperator
getComparisonOperation in interface ConditionalFormattingRulepublic java.lang.String getFormula1()
ConditionalFormattingRule
If the condition type is ConditionalFormattingRule.CONDITION_TYPE_CELL_VALUE_IS,
this field is the first operand of the comparison.
If type is ConditionalFormattingRule.CONDITION_TYPE_FORMULA, this formula is used
to determine if the conditional formatting is applied.
If comparison type is ConditionalFormattingRule.CONDITION_TYPE_FORMULA the formula MUST be a Boolean function
getFormula1 in interface ConditionalFormattingRulepublic java.lang.String getFormula2()
ConditionalFormattingRuleConditionalFormattingRule.CONDITION_TYPE_CELL_VALUE_IS and operator
is either ComparisonOperator.BETWEEN or ComparisonOperator.NOT_BETWEENgetFormula2 in interface ConditionalFormattingRuleprotected java.lang.String toFormulaString(Ptg[] parsedExpression)
protected static java.lang.String toFormulaString(Ptg[] parsedExpression, HSSFWorkbook workbook)
Copyright 2017 The Apache Software Foundation or its licensors, as applicable.