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

Packages that use HSSFConditionalFormattingRule

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

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

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

Modifier and Type	Method and Description
HSSFConditionalFormattingRule	HSSFSheetConditionalFormatting.createConditionalFormattingColorScaleRule() Create a Color Scale / Color Gradient conditional formatting rule.
HSSFConditionalFormattingRule	HSSFSheetConditionalFormatting.createConditionalFormattingRule(byte comparisonOperation, java.lang.String formula1)
HSSFConditionalFormattingRule	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
HSSFConditionalFormattingRule	HSSFSheetConditionalFormatting.createConditionalFormattingRule(ExtendedColor color)
HSSFConditionalFormattingRule	HSSFSheetConditionalFormatting.createConditionalFormattingRule(HSSFExtendedColor color) Create a Databar conditional formatting rule.
HSSFConditionalFormattingRule	HSSFSheetConditionalFormatting.createConditionalFormattingRule(IconMultiStateFormatting.IconSet iconSet) A factory method allowing the creation of conditional formatting rules using an Icon Set / Multi-State formatting.
HSSFConditionalFormattingRule	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.
HSSFConditionalFormattingRule	HSSFConditionalFormatting.getRule(int idx)

Methods in org.apache.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)
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.