public final class HSSFConditionalFormattingRule extends java.lang.Object implements ConditionalFormattingRule
Modifier and Type | Method and Description |
---|---|
HSSFBorderFormatting |
createBorderFormatting()
create a new border formatting structure if it does not exist, otherwise just return existing object.
(如果不存在则创建一个新的边框格式结构,否则只返回现有对象。)
|
HSSFColorScaleFormatting |
createColorScaleFormatting()
create a new color scale / gradient formatting object if it does not exist, otherwise just return the existing object.
(如果不存在则创建一个新的色阶/渐变格式对象,否则只返回现有对象。)
|
HSSFDataBarFormatting |
createDataBarFormatting()
create a new databar / data-bar formatting object if it does not exist, otherwise just return the existing object.
(如果它不存在,则创建一个新的数据栏/数据栏格式化对象,否则只返回现有对象。)
|
HSSFFontFormatting |
createFontFormatting()
create a new font formatting structure if it does not exist, otherwise just return existing object.
(如果不存在则创建一个新的字体格式结构,否则只返回现有对象。)
|
HSSFIconMultiStateFormatting |
createMultiStateFormatting()
create a new icon / multi-state formatting object if it does not exist, otherwise just return the existing object.
(如果不存在则创建一个新的图标/多状态格式化对象,否则只返回现有对象。)
|
HSSFPatternFormatting |
createPatternFormatting()
create a new pattern formatting structure if it does not exist, otherwise just return existing object.
(如果不存在则创建一个新的模式格式化结构,否则只返回现有对象。)
|
HSSFBorderFormatting |
getBorderFormatting() |
HSSFColorScaleFormatting |
getColorScaleFormatting() |
byte |
getComparisonOperation()
The comparison function used when the type of conditional formatting is set to
ConditionType.CELL_VALUE_IS
(条件格式类型设置为ConditionType.CELL_VALUE_IS时使用的比较函数)
|
ConditionFilterType |
getConditionFilterType()
always null (not a filter condition) or
ConditionFilterType.FILTER if it is.
(始终为空(不是过滤条件)或 ConditionFilterType.FILTER(如果是)。)
|
ConditionType |
getConditionType()
Type of conditional formatting rule.
(条件格式规则的类型。)
|
HSSFDataBarFormatting |
getDataBarFormatting() |
ConditionFilterData |
getFilterConfiguration()
This is null if
(这是 null 如果)
|
HSSFFontFormatting |
getFontFormatting() |
java.lang.String |
getFormula1()
The formula used to evaluate the first operand for the conditional formatting rule.
(用于计算条件格式规则的第一个操作数的公式。)
|
java.lang.String |
getFormula2()
The formula used to evaluate the second operand of the comparison when comparison type is
ConditionType.CELL_VALUE_IS and operator is either
ComparisonOperator.BETWEEN or
ComparisonOperator.NOT_BETWEEN
(当比较类型为 ConditionType.CELL_VALUE_IS 且运算符为 ComparisonOperator.BETWEEN 或 ComparisonOperator.NOT_BETWEEN 时,用于计算比较的第二个操作数的公式)
|
HSSFIconMultiStateFormatting |
getMultiStateFormatting() |
ExcelNumberFormat |
getNumberFormat()
Always null for HSSF records, until someone figures out where to find it
(HSSF 记录始终为空,直到有人弄清楚在哪里可以找到它)
|
HSSFPatternFormatting |
getPatternFormatting() |
int |
getPriority()
Only newer style formatting rules have priorities.
(只有较新的样式格式规则具有优先级。)
|
boolean |
getStopIfTrue()
Always true for HSSF files, per Microsoft Excel documentation
(根据 Microsoft Excel 文档,对于 HSSF 文件始终如此)
|
int |
getStripeSize()
Conditional format rules don't define stripes, so always 0
(条件格式规则不定义条纹,所以总是 0)
|
java.lang.String |
getText()
XSSF rules store textual condition values as an attribute and also as a formula that needs shifting.
(XSSF 规则将文本条件值存储为属性以及需要转换的公式。)
|
public int getPriority()
getPriority
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getPriority)
ConditionalFormattingRule.getPriority()
public boolean getStopIfTrue()
getStopIfTrue
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getStopIfTrue)
ConditionalFormattingRule.getStopIfTrue()
public ExcelNumberFormat getNumberFormat()
getNumberFormat
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getNumberFormat)
getNumberFormat
in interface
DifferentialStyleProvider
(接口 DifferentialStyleProvider 中的 getNumberFormat)
ConditionalFormattingRule.getNumberFormat()
public HSSFFontFormatting getFontFormatting()
getFontFormatting
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getFontFormatting)
getFontFormatting
in interface
DifferentialStyleProvider
(接口DifferentialStyleProvider中的getFontFormatting)
null
otherwise
(- 如果已定义字体格式化对象,则为 null)
public HSSFFontFormatting createFontFormatting()
createFontFormatting
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 createFontFormatting)
null
.
(- 字体格式化对象,从不返回 null。)
public HSSFBorderFormatting getBorderFormatting()
getBorderFormatting
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getBorderFormatting)
getBorderFormatting
in interface
DifferentialStyleProvider
(接口DifferentialStyleProvider中的getBorderFormatting)
null
otherwise
(- 如果定义了边框格式化对象,则返回 null)
public HSSFBorderFormatting createBorderFormatting()
createBorderFormatting
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 createBorderFormatting)
null
.
(- 边框格式化对象,从不返回 null。)
public HSSFPatternFormatting getPatternFormatting()
getPatternFormatting
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getPatternFormatting)
getPatternFormatting
in interface
DifferentialStyleProvider
(接口DifferentialStyleProvider中的getPatternFormatting)
null
otherwise
(- 如果定义了模式格式化对象,则为 null)
public HSSFPatternFormatting createPatternFormatting()
createPatternFormatting
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 createPatternFormatting)
null
.
(- 模式格式化对象,从不返回 null。)
public HSSFDataBarFormatting getDataBarFormatting()
getDataBarFormatting
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getDataBarFormatting)
null
otherwise
(databar / data-bar 格式化对象(如果已定义),否则为 null)
public HSSFDataBarFormatting createDataBarFormatting()
public HSSFIconMultiStateFormatting getMultiStateFormatting()
getMultiStateFormatting
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getMultiStateFormatting)
null
otherwise
(图标/多状态格式化对象(如果已定义),否则为 null)
public HSSFIconMultiStateFormatting createMultiStateFormatting()
public HSSFColorScaleFormatting getColorScaleFormatting()
getColorScaleFormatting
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getColorScaleFormatting)
null
otherwise
(如果定义了颜色比例/渐变格式对象,则为 null)
public HSSFColorScaleFormatting createColorScaleFormatting()
public ConditionType getConditionType()
ConditionalFormattingRule
getConditionType
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getConditionType)
public ConditionFilterType getConditionFilterType()
ConditionFilterType.FILTER
if it is.
(始终为空(不是过滤条件)或 ConditionFilterType.FILTER(如果是)。)
getConditionFilterType
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getConditionFilterType)
ConditionalFormattingRule.getConditionFilterType()
public ConditionFilterData getFilterConfiguration()
ConditionalFormattingRule
ConditionalFormattingRule.getConditionFilterType()
== null
This means it is always null for HSSF, which does not define the extended condition types.
This object contains the additional configuration information for XSSF filter conditions.
(如果 ConditionalFormattingRule.getConditionFilterType() == null 则为 null 这意味着对于未定义扩展条件类型的 HSSF,它始终为 null。此对象包含 XSSF 过滤条件的附加配置信息。)getFilterConfiguration
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getFilterConfiguration)
public byte getComparisonOperation()
ConditionalFormattingRule
ConditionType.CELL_VALUE_IS
MUST be a constant from ComparisonOperator
getComparisonOperation
in interface
ConditionalFormattingRule
(接口ConditionalFormattingRule中的getComparisonOperation)
public java.lang.String getFormula1()
ConditionalFormattingRule
If the condition type is ConditionType.CELL_VALUE_IS
, this field is the first operand of the comparison. If type is ConditionType.FORMULA
, this formula is used to determine if the conditional formatting is applied.
If comparison type is ConditionType.FORMULA
the formula MUST be a Boolean function
getFormula1
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getFormula1)
public java.lang.String getFormula2()
ConditionalFormattingRule
ConditionType.CELL_VALUE_IS
and operator is either
ComparisonOperator.BETWEEN
or
ComparisonOperator.NOT_BETWEEN
(当比较类型为 ConditionType.CELL_VALUE_IS 且运算符为 ComparisonOperator.BETWEEN 或 ComparisonOperator.NOT_BETWEEN 时,用于计算比较的第二个操作数的公式)
getFormula2
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getFormula2)
public java.lang.String getText()
ConditionalFormattingRule
getText
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getText)
public int getStripeSize()
getStripeSize
in interface
DifferentialStyleProvider
(接口 DifferentialStyleProvider 中的 getStripeSize)
DifferentialStyleProvider.getStripeSize()
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.