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 classHigh level representation of Conditional Formatting Rule.Methods in org.apache.poi.hssf.usermodel with parameters of type ConditionalFormattingRuleModifier and TypeMethodDescriptionintHSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule1) intHSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule[] cfRules) intHSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule1, ConditionalFormattingRule rule2) voidHSSFConditionalFormatting.addRule(ConditionalFormattingRule cfRule) voidHSSFConditionalFormatting.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 TypeMethodDescriptionintSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule) Add a new Conditional Formatting to the sheet.intSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule[] cfRules) Add a new Conditional Formatting set to the sheet.intSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule1, ConditionalFormattingRule rule2) Add a new Conditional Formatting consisting of two rules.voidConditionalFormatting.addRule(ConditionalFormattingRule cfRule) Add a Conditional Formatting rule.voidConditionalFormatting.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 TypeClassDescriptionclassXSSF support for Conditional Formatting rulesMethods in org.apache.poi.xssf.usermodel with parameters of type ConditionalFormattingRuleModifier and TypeMethodDescriptionintXSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule1) intXSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule[] cfRules) intXSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule1, ConditionalFormattingRule rule2) voidXSSFConditionalFormatting.addRule(ConditionalFormattingRule cfRule) Add a Conditional Formatting rule.voidXSSFConditionalFormatting.setRule(int idx, ConditionalFormattingRule cfRule) Replaces an existing Conditional Formatting rule at position idx.