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