Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

## Uses of Interface
org.apache.poi.ss.usermodel.ConditionalFormattingRule

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 |

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 that return ConditionalFormattingRule
`ConditionalFormattingRule` | `HSSFSheetConditionalFormatting.createConditionalFormattingRule(byte comparisonOperation, java.lang.String formula1)`
`ConditionalFormattingRule` | `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
`ConditionalFormattingRule` | `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
`ConditionalFormattingRule` | `HSSFConditionalFormatting.getRule(int idx)`

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.

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES