|
||||||||||
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.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 TODO - formulas containing cell references are currently not parsed properly |
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. TODO - formulas containing cell references are currently not parsed properly |
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)
|
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(Region[] regions,
HSSFConditionalFormattingRule[] cfRules)
Deprecated. use CellRangeAddress instead of Region |
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 |