|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.apache.poi.xssf.usermodel.XSSFConditionalFormattingRule
public class XSSFConditionalFormattingRule
Field Summary |
---|
Fields inherited from interface org.apache.poi.ss.usermodel.ConditionalFormattingRule |
---|
CONDITION_TYPE_CELL_VALUE_IS, CONDITION_TYPE_FORMULA |
Method Summary | |
---|---|
org.apache.poi.ss.usermodel.BorderFormatting |
createBorderFormatting()
Create a new border formatting structure if it does not exist, otherwise just return existing object. |
org.apache.poi.ss.usermodel.FontFormatting |
createFontFormatting()
Create a new font formatting structure if it does not exist, otherwise just return existing object. |
org.apache.poi.ss.usermodel.PatternFormatting |
createPatternFormatting()
Create a new pattern formatting structure if it does not exist, otherwise just return existing object. |
org.apache.poi.ss.usermodel.BorderFormatting |
getBorderFormatting()
|
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. |
org.apache.poi.ss.usermodel.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 ConditionalFormattingRule.CONDITION_TYPE_CELL_VALUE_IS and operator
is either ComparisonOperator.BETWEEN or ComparisonOperator.NOT_BETWEEN |
org.apache.poi.ss.usermodel.PatternFormatting |
getPatternFormatting()
|
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Method Detail |
---|
public org.apache.poi.ss.usermodel.BorderFormatting createBorderFormatting()
createBorderFormatting
in interface org.apache.poi.ss.usermodel.ConditionalFormattingRule
null
.public org.apache.poi.ss.usermodel.BorderFormatting getBorderFormatting()
getBorderFormatting
in interface org.apache.poi.ss.usermodel.ConditionalFormattingRule
null
otherwisepublic org.apache.poi.ss.usermodel.FontFormatting createFontFormatting()
createFontFormatting
in interface org.apache.poi.ss.usermodel.ConditionalFormattingRule
null
.public org.apache.poi.ss.usermodel.FontFormatting getFontFormatting()
getFontFormatting
in interface org.apache.poi.ss.usermodel.ConditionalFormattingRule
null
otherwisepublic org.apache.poi.ss.usermodel.PatternFormatting createPatternFormatting()
createPatternFormatting
in interface org.apache.poi.ss.usermodel.ConditionalFormattingRule
null
.public org.apache.poi.ss.usermodel.PatternFormatting getPatternFormatting()
getPatternFormatting
in interface org.apache.poi.ss.usermodel.ConditionalFormattingRule
null
otherwisepublic byte getConditionType()
MUST be either ConditionalFormattingRule.CONDITION_TYPE_CELL_VALUE_IS
or ConditionalFormattingRule.CONDITION_TYPE_FORMULA
getConditionType
in interface org.apache.poi.ss.usermodel.ConditionalFormattingRule
public byte getComparisonOperation()
ConditionalFormattingRule.CONDITION_TYPE_CELL_VALUE_IS
MUST be a constant from ComparisonOperator
getComparisonOperation
in interface org.apache.poi.ss.usermodel.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 org.apache.poi.ss.usermodel.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 org.apache.poi.ss.usermodel.ConditionalFormattingRule
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |