| 
||||||||||
| 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 | |||||||||