|
||||||||||
PREV NEXT | FRAMES NO FRAMES |
Packages that use HSSFConditionalFormattingRule | |
---|---|
org.apache.poi.hssf.usermodel | usermodel package maps HSSF low level strutures to familiar workbook/sheet model |
Uses of HSSFConditionalFormattingRule in org.apache.poi.hssf.usermodel |
---|
Methods in org.apache.poi.hssf.usermodel that return HSSFConditionalFormattingRule | |
---|---|
HSSFConditionalFormattingRule |
HSSFSheetConditionalFormatting.createConditionalFormattingColorScaleRule()
Create a Color Scale / Color Gradient conditional formatting rule. |
HSSFConditionalFormattingRule |
HSSFSheetConditionalFormatting.createConditionalFormattingRule(byte comparisonOperation,
java.lang.String formula1)
|
HSSFConditionalFormattingRule |
HSSFSheetConditionalFormatting.createConditionalFormattingRule(byte comparisonOperation,
java.lang.String formula1,
java.lang.String formula2)
A factory method allowing to create a conditional formatting rule with a cell comparison operator |
HSSFConditionalFormattingRule |
HSSFSheetConditionalFormatting.createConditionalFormattingRule(ExtendedColor color)
|
HSSFConditionalFormattingRule |
HSSFSheetConditionalFormatting.createConditionalFormattingRule(HSSFExtendedColor color)
Create a Databar conditional formatting rule. |
HSSFConditionalFormattingRule |
HSSFSheetConditionalFormatting.createConditionalFormattingRule(IconMultiStateFormatting.IconSet iconSet)
A factory method allowing the creation of conditional formatting rules using an Icon Set / Multi-State formatting. |
HSSFConditionalFormattingRule |
HSSFSheetConditionalFormatting.createConditionalFormattingRule(java.lang.String formula)
A factory method allowing to create a conditional formatting rule with a formula. The formatting rules are applied by Excel when the value of the formula not equal to 0. |
HSSFConditionalFormattingRule |
HSSFConditionalFormatting.getRule(int idx)
|
Methods in org.apache.poi.hssf.usermodel with parameters of type HSSFConditionalFormattingRule | |
---|---|
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
HSSFConditionalFormattingRule rule1)
|
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
HSSFConditionalFormattingRule[] cfRules)
Allows to add a new Conditional Formatting set to the sheet. |
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
HSSFConditionalFormattingRule rule1,
HSSFConditionalFormattingRule rule2)
|
void |
HSSFConditionalFormatting.addRule(HSSFConditionalFormattingRule cfRule)
add a Conditional Formatting rule. |
void |
HSSFConditionalFormatting.setRule(int idx,
HSSFConditionalFormattingRule cfRule)
Replaces an existing Conditional Formatting rule at position idx. |
|
||||||||||
PREV NEXT | FRAMES NO FRAMES |