Uses of Class
org.zkoss.poi.hssf.usermodel.HSSFConditionalFormattingRule

Packages that use HSSFConditionalFormattingRule

Package	Description
org.zkoss.poi.hssf.usermodel	usermodel package maps HSSF low level strutures to familiar workbook/sheet model

Uses of HSSFConditionalFormattingRule in org.zkoss.poi.hssf.usermodel

Methods in org.zkoss.poi.hssf.usermodel that return HSSFConditionalFormattingRule

Modifier and Type	Method and Description
HSSFConditionalFormattingRule	HSSFSheetConditionalFormatting.createConditionalFormattingRule(byte comparisonOperation, String formula1)
HSSFConditionalFormattingRule	HSSFSheetConditionalFormatting.createConditionalFormattingRule(byte comparisonOperation, String formula1, 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(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.zkoss.poi.hssf.usermodel with parameters of type HSSFConditionalFormattingRule

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