Uses of Interface
org.apache.poi.ss.usermodel.ConditionalFormattingRule
-
Packages that use ConditionalFormattingRule Package Description org.apache.poi.hssf.usermodel The usermodel package maps HSSF low level structures to familiar workbook/sheet modelorg.apache.poi.ss.formula This package contains common internal POI code for manipulating formulas.org.apache.poi.ss.usermodel -
-
Uses of ConditionalFormattingRule in org.apache.poi.hssf.usermodel
Classes in org.apache.poi.hssf.usermodel that implement ConditionalFormattingRule Modifier and Type Class Description classHSSFConditionalFormattingRuleHigh level representation of Conditional Formatting Rule.Methods in org.apache.poi.hssf.usermodel with parameters of type ConditionalFormattingRule Modifier and Type Method Description intHSSFSheetConditionalFormatting. 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 ConditionalFormattingRule Modifier and Type Method Description ConditionalFormattingRuleEvaluationConditionalFormatRule. getRule()Constructors in org.apache.poi.ss.formula with parameters of type ConditionalFormattingRule Constructor Description EvaluationConditionalFormatRule(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 ConditionalFormattingRule Modifier and Type Method Description ConditionalFormattingRuleSheetConditionalFormatting. createConditionalFormattingColorScaleRule()Create a Color Scale / Color Gradient conditional formatting rule.ConditionalFormattingRuleSheetConditionalFormatting. createConditionalFormattingRule(byte comparisonOperation, String formula)Create a conditional formatting rule that compares a cell value to a formula calculated result, using an operator *ConditionalFormattingRuleSheetConditionalFormatting. createConditionalFormattingRule(byte comparisonOperation, String formula1, String formula2)A factory method allowing to create a conditional formatting rule with a cell comparison operatorConditionalFormattingRuleSheetConditionalFormatting. createConditionalFormattingRule(String formula)Create a conditional formatting rule based on a Boolean formula.ConditionalFormattingRuleSheetConditionalFormatting. createConditionalFormattingRule(ExtendedColor color)Create a Databar conditional formatting rule.ConditionalFormattingRuleSheetConditionalFormatting. createConditionalFormattingRule(IconMultiStateFormatting.IconSet iconSet)Create an Icon Set / Multi-State conditional formatting rule.ConditionalFormattingRuleConditionalFormatting. getRule(int idx)Methods in org.apache.poi.ss.usermodel with parameters of type ConditionalFormattingRule Modifier and Type Method Description intSheetConditionalFormatting. 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.
-