public class XSSFConditionalFormattingRule extends java.lang.Object implements ConditionalFormattingRule
Modifier and Type | Method and Description |
---|---|
XSSFBorderFormatting |
createBorderFormatting()
Create a new border formatting structure if it does not exist, otherwise just return existing object.
(如果不存在则创建一个新的边框格式结构,否则只返回现有对象。)
|
XSSFColorScaleFormatting |
createColorScaleFormatting() |
XSSFDataBarFormatting |
createDataBarFormatting(XSSFColor color) |
XSSFFontFormatting |
createFontFormatting()
Create a new font formatting structure if it does not exist, otherwise just return existing object.
(如果不存在则创建一个新的字体格式结构,否则只返回现有对象。)
|
XSSFIconMultiStateFormatting |
createMultiStateFormatting(IconMultiStateFormatting.IconSet iconSet) |
XSSFPatternFormatting |
createPatternFormatting()
Create a new pattern formatting structure if it does not exist, otherwise just return existing object.
(如果不存在则创建一个新的模式格式化结构,否则只返回现有对象。)
|
XSSFBorderFormatting |
getBorderFormatting() |
XSSFColorScaleFormatting |
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()
Will return null if
getConditionType() !=
ConditionType.FILTER
(如果 getConditionType() != ConditionType.FILTER 将返回 null)
|
ConditionType |
getConditionType()
Type of conditional formatting rule.
(条件格式规则的类型。)
|
XSSFDataBarFormatting |
getDataBarFormatting() |
ConditionFilterData |
getFilterConfiguration()
This is null if
(这是 null 如果)
|
XSSFFontFormatting |
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 时,用于计算比较的第二个操作数的公式)
|
XSSFIconMultiStateFormatting |
getMultiStateFormatting() |
ExcelNumberFormat |
getNumberFormat()
Return the number format from the dxf style record if present, null if not
(如果存在则从 dxf 样式记录中返回数字格式,如果不存在则返回 null)
|
XSSFPatternFormatting |
getPatternFormatting() |
int |
getPriority()
The priority of the rule, if defined, otherwise 0.
(规则的优先级,如果已定义,否则为 0。)
|
boolean |
getStopIfTrue()
Always true for HSSF rules, optional flag for XSSF rules.
(HSSF 规则始终为真,XSSF 规则为可选标志。)
|
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()
ConditionalFormattingRule
If priority is 0, just use definition order, as that's how older HSSF rules are evaluated.
For XSSF, this should always be set. For HSSF, only newer style rules have this set, older ones will return 0.
If a rule is created but not yet added to a sheet, this value may not be valid.
(规则的优先级(如果已定义),否则为 0。如果优先级为 0,则只需使用定义顺序,因为这是评估旧 HSSF 规则的方式。对于 XSSF,应始终设置此项。对于 HSSF,只有较新的样式规则具有此设置,较旧的样式规则将返回 0。如果已创建规则但尚未添加到工作表,则此值可能无效。)getPriority
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getPriority)
public boolean getStopIfTrue()
ConditionalFormattingRule
getStopIfTrue
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getStopIfTrue)
public XSSFBorderFormatting createBorderFormatting()
createBorderFormatting
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 createBorderFormatting)
null
.
(- 边框格式化对象,从不返回 null。)
public XSSFBorderFormatting getBorderFormatting()
getBorderFormatting
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getBorderFormatting)
getBorderFormatting
in interface
DifferentialStyleProvider
(接口DifferentialStyleProvider中的getBorderFormatting)
null
otherwise
(- 如果定义了边框格式化对象,则返回 null)
public XSSFFontFormatting createFontFormatting()
createFontFormatting
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 createFontFormatting)
null
.
(- 字体格式化对象,从不返回 null。)
public XSSFFontFormatting getFontFormatting()
getFontFormatting
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getFontFormatting)
getFontFormatting
in interface
DifferentialStyleProvider
(接口DifferentialStyleProvider中的getFontFormatting)
null
otherwise
(- 如果已定义字体格式化对象,则为 null)
public XSSFPatternFormatting createPatternFormatting()
createPatternFormatting
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 createPatternFormatting)
null
.
(- 模式格式化对象,从不返回 null。)
public XSSFPatternFormatting getPatternFormatting()
getPatternFormatting
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getPatternFormatting)
getPatternFormatting
in interface
DifferentialStyleProvider
(接口DifferentialStyleProvider中的getPatternFormatting)
null
otherwise
(- 如果定义了模式格式化对象,则为 null)
public XSSFDataBarFormatting createDataBarFormatting(XSSFColor color)
color
-
(颜色 -)
public XSSFDataBarFormatting getDataBarFormatting()
getDataBarFormatting
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getDataBarFormatting)
null
otherwise
(- 如果定义了数据栏/数据栏格式化对象,则为 null)
public XSSFIconMultiStateFormatting createMultiStateFormatting(IconMultiStateFormatting.IconSet iconSet)
public XSSFIconMultiStateFormatting getMultiStateFormatting()
getMultiStateFormatting
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getMultiStateFormatting)
null
otherwise
(- 如果定义了图标/多状态格式化对象,则为 null)
public XSSFColorScaleFormatting createColorScaleFormatting()
public XSSFColorScaleFormatting getColorScaleFormatting()
getColorScaleFormatting
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getColorScaleFormatting)
null
otherwise
(色标/色栅格式化对象(如果已定义),否则为 null)
public ExcelNumberFormat getNumberFormat()
getNumberFormat
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getNumberFormat)
getNumberFormat
in interface
DifferentialStyleProvider
(接口 DifferentialStyleProvider 中的 getNumberFormat)
ConditionalFormattingRule.getNumberFormat()
public ConditionType getConditionType()
getConditionType
in interface
ConditionalFormattingRule
(接口 ConditionalFormattingRule 中的 getConditionType)
public ConditionFilterType getConditionFilterType()
getConditionType()
!=
ConditionType.FILTER
(如果 getConditionType() != ConditionType.FILTER 将返回 null)
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()
ConditionType.CELL_VALUE_IS
MUST be a constant from ComparisonOperator
getComparisonOperation
in interface
ConditionalFormattingRule
(接口ConditionalFormattingRule中的getComparisonOperation)
public java.lang.String getFormula1()
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()
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.