|
||||||||||
| 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.ConditionalFormattingRulenull.public org.apache.poi.ss.usermodel.BorderFormatting getBorderFormatting()
getBorderFormatting in interface org.apache.poi.ss.usermodel.ConditionalFormattingRulenull otherwisepublic org.apache.poi.ss.usermodel.FontFormatting createFontFormatting()
createFontFormatting in interface org.apache.poi.ss.usermodel.ConditionalFormattingRulenull.public org.apache.poi.ss.usermodel.FontFormatting getFontFormatting()
getFontFormatting in interface org.apache.poi.ss.usermodel.ConditionalFormattingRulenull otherwisepublic org.apache.poi.ss.usermodel.PatternFormatting createPatternFormatting()
createPatternFormatting in interface org.apache.poi.ss.usermodel.ConditionalFormattingRulenull.public org.apache.poi.ss.usermodel.PatternFormatting getPatternFormatting()
getPatternFormatting in interface org.apache.poi.ss.usermodel.ConditionalFormattingRulenull 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.ConditionalFormattingRulepublic byte getComparisonOperation()
ConditionalFormattingRule.CONDITION_TYPE_CELL_VALUE_IS
MUST be a constant from ComparisonOperator
getComparisonOperation in interface org.apache.poi.ss.usermodel.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 org.apache.poi.ss.usermodel.ConditionalFormattingRulepublic 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 | |||||||||