Uses of Class
org.apache.poi.hssf.usermodel.HSSFConditionalFormattingRule
Packages that use HSSFConditionalFormattingRule
Package
Description
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 HSSFConditionalFormattingRuleModifier and TypeMethodDescriptionHSSFSheetConditionalFormatting.createConditionalFormattingColorScaleRule()
Create a Color Scale / Color Gradient conditional formatting rule.HSSFSheetConditionalFormatting.createConditionalFormattingRule
(byte comparisonOperation, String formula1) HSSFSheetConditionalFormatting.createConditionalFormattingRule
(byte comparisonOperation, String formula1, String formula2) A factory method allowing to create a conditional formatting rule with a cell comparison operatorHSSFSheetConditionalFormatting.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.HSSFSheetConditionalFormatting.createConditionalFormattingRule
(HSSFExtendedColor color) Create a Databar conditional formatting rule.HSSFSheetConditionalFormatting.createConditionalFormattingRule
(ExtendedColor color) HSSFSheetConditionalFormatting.createConditionalFormattingRule
(IconMultiStateFormatting.IconSet iconSet) A factory method allowing the creation of conditional formatting rules using an Icon Set / Multi-State formatting.HSSFConditionalFormatting.getRule
(int idx) Methods in org.apache.poi.hssf.usermodel with parameters of type HSSFConditionalFormattingRuleModifier and TypeMethodDescriptionint
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.