public final class HSSFConditionalFormattingThreshold extends java.lang.Object implements ConditionalFormattingThreshold
ConditionalFormattingThreshold.RangeType
Modifier | Constructor and Description |
---|---|
protected |
HSSFConditionalFormattingThreshold(Threshold threshold, HSSFSheet sheet) |
Modifier and Type | Method and Description |
---|---|
java.lang.String |
getFormula()
Formula to use to calculate the threshold, or
null if no formula
(用于计算阈值的公式,如果没有公式,则为 null)
|
ConditionalFormattingThreshold.RangeType |
getRangeType()
Get the Range Type used
(获取使用的范围类型)
|
protected Threshold |
getThreshold() |
java.lang.Double |
getValue()
Gets the value used for the threshold, or
null if there isn't one.
(获取用于阈值的值,如果没有,则为 null。)
|
void |
setFormula(java.lang.String formula)
Sets the formula used to calculate the threshold, or unsets it if
null is given.
(设置用于计算阈值的公式,如果给出 null,则取消设置。)
|
void |
setRangeType(ConditionalFormattingThreshold.RangeType type)
Changes the Range Type used
(更改使用的范围类型)
|
void |
setValue(java.lang.Double value)
Sets the value used for the threshold.
(设置用于阈值的值。)
|
protected Threshold getThreshold()
public ConditionalFormattingThreshold.RangeType getRangeType()
ConditionalFormattingThreshold
getRangeType
in interface
ConditionalFormattingThreshold
(接口 ConditionalFormattingThreshold 中的 getRangeType)
public void setRangeType(ConditionalFormattingThreshold.RangeType type)
ConditionalFormattingThreshold
If you change the range type, you need to ensure that the Formula and Value parameters are compatible with it before saving
(更改使用的范围类型如果更改范围类型,则需要确保公式和值参数与其兼容,然后再保存)setRangeType
in interface
ConditionalFormattingThreshold
(接口 ConditionalFormattingThreshold 中的 setRangeType)
public java.lang.String getFormula()
ConditionalFormattingThreshold
null
if no formula
(用于计算阈值的公式,如果没有公式,则为 null)
getFormula
in interface
ConditionalFormattingThreshold
(接口 ConditionalFormattingThreshold 中的 getFormula)
public void setFormula(java.lang.String formula)
ConditionalFormattingThreshold
null
is given.
(设置用于计算阈值的公式,如果给出 null,则取消设置。)
setFormula
in interface
ConditionalFormattingThreshold
(接口 ConditionalFormattingThreshold 中的 setFormula)
public java.lang.Double getValue()
ConditionalFormattingThreshold
null
if there isn't one.
(获取用于阈值的值,如果没有,则为 null。)
getValue
in interface
ConditionalFormattingThreshold
(接口 ConditionalFormattingThreshold 中的 getValue)
public void setValue(java.lang.Double value)
ConditionalFormattingThreshold
If the type is ConditionalFormattingThreshold.RangeType.PERCENT
or ConditionalFormattingThreshold.RangeType.PERCENTILE
it must be between 0 and 100.
If the type is ConditionalFormattingThreshold.RangeType.MIN
or ConditionalFormattingThreshold.RangeType.MAX
or ConditionalFormattingThreshold.RangeType.FORMULA
it shouldn't be set.
Use null
to unset
setValue
in interface
ConditionalFormattingThreshold
(接口 ConditionalFormattingThreshold 中的 setValue)
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.