|
||||||||||
PREV NEXT | FRAMES NO FRAMES |
Packages that use ConditionalFormattingRule | |
---|---|
org.apache.poi.hssf.usermodel | usermodel package maps HSSF low level strutures to familiar workbook/sheet model |
org.apache.poi.ss.usermodel | |
org.apache.poi.xssf.usermodel |
Uses of ConditionalFormattingRule in org.apache.poi.hssf.usermodel |
---|
Classes in org.apache.poi.hssf.usermodel that implement ConditionalFormattingRule | |
---|---|
class |
HSSFConditionalFormattingRule
High level representation of Conditional Formatting Rule. |
Methods in org.apache.poi.hssf.usermodel with parameters of type ConditionalFormattingRule | |
---|---|
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule1)
|
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule[] cfRules)
|
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule1,
ConditionalFormattingRule rule2)
|
void |
HSSFConditionalFormatting.addRule(ConditionalFormattingRule cfRule)
|
void |
HSSFConditionalFormatting.setRule(int idx,
ConditionalFormattingRule cfRule)
|
Uses of ConditionalFormattingRule in org.apache.poi.ss.usermodel |
---|
Methods in org.apache.poi.ss.usermodel that return ConditionalFormattingRule | |
---|---|
ConditionalFormattingRule |
SheetConditionalFormatting.createConditionalFormattingRule(byte comparisonOperation,
java.lang.String formula)
Create a conditional formatting rule that compares a cell value to a formula calculated result, using an operator * |
ConditionalFormattingRule |
SheetConditionalFormatting.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 |
ConditionalFormattingRule |
SheetConditionalFormatting.createConditionalFormattingRule(java.lang.String formula)
Create a conditional formatting rule based on a Boolean formula. |
ConditionalFormattingRule |
ConditionalFormatting.getRule(int idx)
|
Methods in org.apache.poi.ss.usermodel with parameters of type ConditionalFormattingRule | |
---|---|
int |
SheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule)
Add a new Conditional Formatting to the sheet. |
int |
SheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule[] cfRules)
Add a new Conditional Formatting set to the sheet. |
int |
SheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule1,
ConditionalFormattingRule rule2)
Add a new Conditional Formatting consisting of two rules. |
void |
ConditionalFormatting.addRule(ConditionalFormattingRule cfRule)
Add a Conditional Formatting rule. |
void |
ConditionalFormatting.setRule(int idx,
ConditionalFormattingRule cfRule)
Replaces an existing Conditional Formatting rule at position idx. |
Uses of ConditionalFormattingRule in org.apache.poi.xssf.usermodel |
---|
Classes in org.apache.poi.xssf.usermodel that implement ConditionalFormattingRule | |
---|---|
class |
XSSFConditionalFormattingRule
|
Methods in org.apache.poi.xssf.usermodel with parameters of type ConditionalFormattingRule | |
---|---|
int |
XSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule1)
|
int |
XSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule[] cfRules)
|
int |
XSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule1,
ConditionalFormattingRule rule2)
|
void |
XSSFConditionalFormatting.addRule(ConditionalFormattingRule cfRule)
Add a Conditional Formatting rule. |
void |
XSSFConditionalFormatting.setRule(int idx,
ConditionalFormattingRule cfRule)
Replaces an existing Conditional Formatting rule at position idx. |
|
||||||||||
PREV NEXT | FRAMES NO FRAMES |