public class XSSFDataValidationConstraint extends java.lang.Object implements DataValidationConstraint
DataValidationConstraint.OperatorType, DataValidationConstraint.ValidationType
Constructor and Description |
---|
XSSFDataValidationConstraint(int validationType, int operator, java.lang.String formula1) |
XSSFDataValidationConstraint(int validationType, int operator, java.lang.String formula1, java.lang.String formula2)
This is the constructor called using the OOXML raw data.
|
XSSFDataValidationConstraint(int validationType, java.lang.String formula1) |
XSSFDataValidationConstraint(java.lang.String[] explicitListOfValues)
list literal constructor
|
Modifier and Type | Method and Description |
---|---|
java.lang.String[] |
getExplicitListValues()
If validation type is
DataValidationConstraint.ValidationType.LIST and
formula1 was comma-separated literal values rather than a range or named range, returns list of literal values.
(如果验证类型是 DataValidationConstraint.ValidationType.LIST 并且 formula1 是逗号分隔的文字值而不是范围或命名范围,则返回文字值列表。)
|
java.lang.String |
getFormula1() |
java.lang.String |
getFormula2() |
int |
getOperator() |
int |
getValidationType() |
protected static boolean |
isFormulaEmpty(java.lang.String formula1) |
java.lang.String |
prettyPrint() |
protected static java.lang.String |
removeLeadingEquals(java.lang.String formula1) |
void |
setExplicitListValues(java.lang.String[] explicitListValues) |
void |
setFormula1(java.lang.String formula1)
Sets a formula for expression 1.
(设置表达式 1 的公式。)
|
void |
setFormula2(java.lang.String formula2)
Sets a formula for expression 2.
(设置表达式 2 的公式。)
|
void |
setOperator(int operator)
Sets the comparison operator for this constraint
(设置此约束的比较运算符)
|
void |
validate() |
public XSSFDataValidationConstraint(java.lang.String[] explicitListOfValues)
public XSSFDataValidationConstraint(int validationType, java.lang.String formula1)
public XSSFDataValidationConstraint(int validationType, int operator, java.lang.String formula1)
public XSSFDataValidationConstraint(int validationType, int operator, java.lang.String formula1, java.lang.String formula2)
validationType
-
(验证类型 -)
operator
-
(操作员 -)
formula1
- Overloaded: formula1 or list of explicit values
(公式 1 - 重载:公式 1 或显式值列表)
formula2
- (formula1 is a list of explicit values, this is ignored: use
null
)
(公式 2 -(公式 1 是显式值的列表,这被忽略:使用 null))
public java.lang.String[] getExplicitListValues()
DataValidationConstraint
DataValidationConstraint.ValidationType.LIST
and
formula1
was comma-separated literal values rather than a range or named range, returns list of literal values. Otherwise returns
null
.
(如果验证类型是 DataValidationConstraint.ValidationType.LIST 并且 formula1 是逗号分隔的文字值而不是范围或命名范围,则返回文字值列表。否则返回 null。)
getExplicitListValues
in interface
DataValidationConstraint
(接口 DataValidationConstraint 中的 getExplicitListValues)
public java.lang.String getFormula1()
getFormula1
in interface
DataValidationConstraint
(接口 DataValidationConstraint 中的 getFormula1)
null
(表达式 1 的公式。可能为空)
public java.lang.String getFormula2()
getFormula2
in interface
DataValidationConstraint
(接口 DataValidationConstraint 中的 getFormula2)
null
(表达式 2 的公式。可能为空)
public int getOperator()
getOperator
in interface
DataValidationConstraint
(接口 DataValidationConstraint 中的 getOperator)
DataValidationConstraint.OperatorType
public int getValidationType()
getValidationType
in interface
DataValidationConstraint
(接口 DataValidationConstraint 中的 getValidationType)
DataValidationConstraint.ValidationType
public void setExplicitListValues(java.lang.String[] explicitListValues)
setExplicitListValues
in interface
DataValidationConstraint
(接口 DataValidationConstraint 中的 setExplicitListValues)
public void setFormula1(java.lang.String formula1)
DataValidationConstraint
setFormula1
in interface
DataValidationConstraint
(接口 DataValidationConstraint 中的 setFormula1)
protected static java.lang.String removeLeadingEquals(java.lang.String formula1)
protected static boolean isFormulaEmpty(java.lang.String formula1)
public void setFormula2(java.lang.String formula2)
DataValidationConstraint
setFormula2
in interface
DataValidationConstraint
(接口 DataValidationConstraint 中的 setFormula2)
public void setOperator(int operator)
DataValidationConstraint
setOperator
in interface
DataValidationConstraint
(接口 DataValidationConstraint 中的 setOperator)
DataValidationConstraint.OperatorType
public void validate()
public java.lang.String prettyPrint()
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.