Uses of Interface
org.apache.poi.ss.usermodel.ConditionalFormattingRule
Packages that use ConditionalFormattingRule
Package
Description
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
This package contains common internal POI code for manipulating formulas.
-
Uses of ConditionalFormattingRule in org.apache.poi.hssf.usermodel
Classes in org.apache.poi.hssf.usermodel that implement ConditionalFormattingRuleModifier and TypeClassDescriptionfinal class
High level representation of Conditional Formatting Rule.Methods in org.apache.poi.hssf.usermodel with parameters of type ConditionalFormattingRuleModifier and TypeMethodDescriptionint
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 ConditionalFormattingRuleConstructors in org.apache.poi.ss.formula with parameters of type ConditionalFormattingRuleModifierConstructorDescriptionEvaluationConditionalFormatRule
(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 ConditionalFormattingRuleModifier and TypeMethodDescriptionSheetConditionalFormatting.createConditionalFormattingColorScaleRule()
Create a Color Scale / Color Gradient conditional formatting rule.SheetConditionalFormatting.createConditionalFormattingRule
(byte comparisonOperation, String formula) Create a conditional formatting rule that compares a cell value to a formula calculated result, using an operator *SheetConditionalFormatting.createConditionalFormattingRule
(byte comparisonOperation, String formula1, String formula2) A factory method allowing to create a conditional formatting rule with a cell comparison operatorSheetConditionalFormatting.createConditionalFormattingRule
(String formula) Create a conditional formatting rule based on a Boolean formula.SheetConditionalFormatting.createConditionalFormattingRule
(ExtendedColor color) Create a Databar conditional formatting rule.SheetConditionalFormatting.createConditionalFormattingRule
(IconMultiStateFormatting.IconSet iconSet) Create an Icon Set / Multi-State conditional formatting rule.ConditionalFormatting.getRule
(int idx) Methods in org.apache.poi.ss.usermodel with parameters of type ConditionalFormattingRuleModifier and TypeMethodDescriptionint
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 ConditionalFormattingRuleModifier and TypeClassDescriptionclass
XSSF support for Conditional Formatting rulesMethods in org.apache.poi.xssf.usermodel with parameters of type ConditionalFormattingRuleModifier and TypeMethodDescriptionint
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.