public class XSSFConditionalFormattingRule extends java.lang.Object implements ConditionalFormattingRule
CONDITION_TYPE_CELL_VALUE_IS, CONDITION_TYPE_FORMULApublic XSSFBorderFormatting createBorderFormatting()
createBorderFormatting in interface ConditionalFormattingRulenull.public XSSFBorderFormatting getBorderFormatting()
getBorderFormatting in interface ConditionalFormattingRulenull otherwisepublic XSSFFontFormatting createFontFormatting()
createFontFormatting in interface ConditionalFormattingRulenull.public XSSFFontFormatting getFontFormatting()
getFontFormatting in interface ConditionalFormattingRulenull otherwisepublic XSSFPatternFormatting createPatternFormatting()
createPatternFormatting in interface ConditionalFormattingRulenull.public XSSFPatternFormatting getPatternFormatting()
getPatternFormatting in interface ConditionalFormattingRulenull otherwisepublic XSSFDataBarFormatting createDataBarFormatting(XSSFColor color)
public XSSFDataBarFormatting getDataBarFormatting()
getDataBarFormatting in interface ConditionalFormattingRulenull otherwisepublic XSSFIconMultiStateFormatting createMultiStateFormatting(IconMultiStateFormatting.IconSet iconSet)
public XSSFIconMultiStateFormatting getMultiStateFormatting()
getMultiStateFormatting in interface ConditionalFormattingRulenull otherwisepublic XSSFColorScaleFormatting createColorScaleFormatting()
public XSSFColorScaleFormatting getColorScaleFormatting()
getColorScaleFormatting in interface ConditionalFormattingRulenull otherwisepublic byte getConditionType()
MUST be one of the IDs of a ConditionType
getConditionType in interface ConditionalFormattingRulepublic ConditionType getConditionTypeType()
getConditionTypeType in interface ConditionalFormattingRulepublic byte getComparisonOperation()
ConditionalFormattingRule.CONDITION_TYPE_CELL_VALUE_IS
MUST be a constant from ComparisonOperator
getComparisonOperation in interface ConditionalFormattingRulepublic java.lang.String getFormula1()
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()
ConditionalFormattingRule.CONDITION_TYPE_CELL_VALUE_IS and operator
is either ComparisonOperator.BETWEEN or ComparisonOperator.NOT_BETWEENgetFormula2 in interface ConditionalFormattingRuleCopyright 2017 The Apache Software Foundation or its licensors, as applicable.