Package org.apache.poi.xssf.usermodel
Class XSSFConditionalFormattingThreshold
java.lang.Object
org.apache.poi.xssf.usermodel.XSSFConditionalFormattingThreshold
- All Implemented Interfaces:
ConditionalFormattingThreshold
public class XSSFConditionalFormattingThreshold
extends Object
implements ConditionalFormattingThreshold
High level representation for Icon / Multi-State / Databar /
Colour Scale change thresholds
-
Nested Class Summary
Nested classes/interfaces inherited from interface org.apache.poi.ss.usermodel.ConditionalFormattingThreshold
ConditionalFormattingThreshold.RangeType -
Constructor Summary
ConstructorsModifierConstructorDescriptionprotectedXSSFConditionalFormattingThreshold(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfvo cfvo) -
Method Summary
Modifier and TypeMethodDescriptionprotected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfvoFormula to use to calculate the threshold, ornullif no formulaGet the Range Type usedgetValue()Gets the value used for the threshold, ornullif there isn't one.voidsetFormula(String formula) Sets the formula used to calculate the threshold, or unsets it ifnullis given.voidChanges the Range Type usedvoidSets the value used for the threshold.
-
Constructor Details
-
XSSFConditionalFormattingThreshold
protected XSSFConditionalFormattingThreshold(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfvo cfvo)
-
-
Method Details
-
getCTCfvo
protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfvo getCTCfvo() -
getRangeType
Description copied from interface:ConditionalFormattingThresholdGet the Range Type used- Specified by:
getRangeTypein interfaceConditionalFormattingThreshold
-
setRangeType
Description copied from interface:ConditionalFormattingThresholdChanges the Range Type usedIf you change the range type, you need to ensure that the Formula and Value parameters are compatible with it before saving
- Specified by:
setRangeTypein interfaceConditionalFormattingThreshold
-
getFormula
Description copied from interface:ConditionalFormattingThresholdFormula to use to calculate the threshold, ornullif no formula- Specified by:
getFormulain interfaceConditionalFormattingThreshold
-
setFormula
Description copied from interface:ConditionalFormattingThresholdSets the formula used to calculate the threshold, or unsets it ifnullis given.- Specified by:
setFormulain interfaceConditionalFormattingThreshold
-
getValue
Description copied from interface:ConditionalFormattingThresholdGets the value used for the threshold, ornullif there isn't one.- Specified by:
getValuein interfaceConditionalFormattingThreshold
-
setValue
Description copied from interface:ConditionalFormattingThresholdSets the value used for the threshold.If the type is
ConditionalFormattingThreshold.RangeType.PERCENTorConditionalFormattingThreshold.RangeType.PERCENTILEit must be between 0 and 100.If the type is
ConditionalFormattingThreshold.RangeType.MINorConditionalFormattingThreshold.RangeType.MAXorConditionalFormattingThreshold.RangeType.FORMULAit shouldn't be set.Use
nullto unset- Specified by:
setValuein interfaceConditionalFormattingThreshold
-