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 TypeMethodDescriptionintHSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, HSSFConditionalFormattingRule rule1) intHSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, HSSFConditionalFormattingRule[] cfRules) Allows to add a new Conditional Formatting set to the sheet.intHSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, HSSFConditionalFormattingRule rule1, HSSFConditionalFormattingRule rule2) voidHSSFConditionalFormatting.addRule(HSSFConditionalFormattingRule cfRule) add a Conditional Formatting rule.voidHSSFConditionalFormatting.setRule(int idx, HSSFConditionalFormattingRule cfRule) Replaces an existing Conditional Formatting rule at position idx.