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

Packages that use ConditionalFormattingRule

Package	Description
org.apache.poi.hssf.usermodel	usermodel package maps HSSF low level strutures to familiar workbook/sheet model
org.apache.poi.ss.formula	This package contains common internal POI code for manipulating formulas.
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

Modifier and Type	Class and Description
class	HSSFConditionalFormattingRule High level representation of Conditional Formatting Rule.

Methods in org.apache.poi.hssf.usermodel with parameters of type ConditionalFormattingRule

Modifier and Type	Method and Description
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.formula

Methods in org.apache.poi.ss.formula that return ConditionalFormattingRule

Modifier and Type	Method and Description
ConditionalFormattingRule	EvaluationConditionalFormatRule.getRule()

Constructors in org.apache.poi.ss.formula with parameters of type ConditionalFormattingRule

Constructor and Description
EvaluationConditionalFormatRule(WorkbookEvaluator workbookEvaluator, Sheet sheet, ConditionalFormatting formatting, int formattingIndex, ConditionalFormattingRule rule, int ruleIndex, CellRangeAddress[] regions)

Uses of ConditionalFormattingRule in org.apache.poi.ss.usermodel

Methods in org.apache.poi.ss.usermodel that return ConditionalFormattingRule

Modifier and Type	Method and Description
ConditionalFormattingRule	SheetConditionalFormatting.createConditionalFormattingColorScaleRule() Create a Color Scale / Color Gradient conditional formatting rule.
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(ExtendedColor color) Create a Databar conditional formatting rule.
ConditionalFormattingRule	SheetConditionalFormatting.createConditionalFormattingRule(IconMultiStateFormatting.IconSet iconSet) Create an Icon Set / Multi-State conditional formatting rule.
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

Modifier and Type	Method and Description
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

Modifier and Type	Class and Description
class	XSSFConditionalFormattingRule XSSF support for Conditional Formatting rules

Methods in org.apache.poi.xssf.usermodel with parameters of type ConditionalFormattingRule

Modifier and Type	Method and Description
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.