public class DVConstraint extends java.lang.Object implements DataValidationConstraint
DataValidationConstraint.OperatorType, DataValidationConstraint.ValidationType
Modifier and Type | Method and Description |
---|---|
static DVConstraint |
createCustomFormulaConstraint(java.lang.String formula) |
static DVConstraint |
createDateConstraint(int comparisonOperator, java.lang.String expr1, java.lang.String expr2, java.lang.String dateFormat)
Creates a date based data validation constraint.
(创建基于日期的数据验证约束。)
|
static DVConstraint |
createExplicitListConstraint(java.lang.String[] explicitListValues) |
static DVConstraint |
createFormulaListConstraint(java.lang.String listFormula) |
static DVConstraint |
createNumericConstraint(int validationType, int comparisonOperator, java.lang.String expr1, java.lang.String expr2)
Creates a number based data validation constraint.
(创建基于数字的数据验证约束。)
|
static DVConstraint |
createTimeConstraint(int comparisonOperator, java.lang.String expr1, java.lang.String expr2)
Creates a time based data validation constraint.
(创建基于时间的数据验证约束。)
|
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() |
java.lang.Double |
getValue1() |
java.lang.Double |
getValue2() |
boolean |
isExplicitList()
Convenience method
(方便的方法)
|
boolean |
isListValidationType()
Convenience method
(方便的方法)
|
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 |
setValue1(double value1)
Sets a numeric value for expression 1.
(为表达式 1 设置数值。)
|
void |
setValue2(double value2)
Sets a numeric value for expression 2.
(为表达式 2 设置一个数值。)
|
public static DVConstraint createNumericConstraint(int validationType, int comparisonOperator, java.lang.String expr1, java.lang.String expr2)
validationType
- one of
DataValidationConstraint.ValidationType.ANY
,
DataValidationConstraint.ValidationType.DECIMAL
,
DataValidationConstraint.ValidationType.INTEGER
,
DataValidationConstraint.ValidationType.TEXT_LENGTH
(validationType - DataValidationConstraint.ValidationType.ANY、DataValidationConstraint.ValidationType.DECIMAL、DataValidationConstraint.ValidationType.INTEGER、DataValidationConstraint.ValidationType.TEXT_LENGTH 之一)
comparisonOperator
- any constant from
DataValidationConstraint.OperatorType
enum
(compareOperator - 来自 DataValidationConstraint.OperatorType 枚举的任何常量)
expr1
- date formula (when first char is '=') or formatted number value
(expr1 - 日期公式(当第一个字符为 '=' 时)或格式化数字值)
expr2
- date formula (when first char is '=') or formatted number value
(expr2 - 日期公式(当第一个字符为 '=' 时)或格式化的数值)
public static DVConstraint createFormulaListConstraint(java.lang.String listFormula)
public static DVConstraint createExplicitListConstraint(java.lang.String[] explicitListValues)
public static DVConstraint createTimeConstraint(int comparisonOperator, java.lang.String expr1, java.lang.String expr2)
comparisonOperator
- constant from
DataValidationConstraint.OperatorType
enum
(compareOperator - 来自 DataValidationConstraint.OperatorType 枚举的常量)
expr1
- date formula (when first char is '=') or formatted time value
(expr1 - 日期公式(当第一个字符为 '=' 时)或格式化的时间值)
expr2
- date formula (when first char is '=') or formatted time value
(expr2 - 日期公式(当第一个字符为 '=' 时)或格式化的时间值)
public static DVConstraint createDateConstraint(int comparisonOperator, java.lang.String expr1, java.lang.String expr2, java.lang.String dateFormat)
comparisonOperator
- constant from
DataValidationConstraint.OperatorType
enum
(compareOperator - 来自 DataValidationConstraint.OperatorType 枚举的常量)
expr1
- date formula (when first char is '=') or formatted date value
(expr1 - 日期公式(当第一个字符为 '=' 时)或格式化的日期值)
expr2
- date formula (when first char is '=') or formatted date value
(expr2 - 日期公式(当第一个字符为 '=' 时)或格式化的日期值)
dateFormat
- ignored if both expr1 and expr2 are formulas. Default value is "YYYY/MM/DD" otherwise any other valid argument for
SimpleDateFormat can be used
(dateFormat - 如果 expr1 和 expr2 都是公式,则忽略。默认值为“YYYY/MM/DD”,否则可以使用 SimpleDateFormat 的任何其他有效参数)
public static DVConstraint createCustomFormulaConstraint(java.lang.String formula)
public int getValidationType()
getValidationType
in interface
DataValidationConstraint
(接口 DataValidationConstraint 中的 getValidationType)
DataValidationConstraint.ValidationType
public boolean isListValidationType()
true
if this constraint is a 'list' validation
(如果此约束是“列表”验证,则为 true)
public boolean isExplicitList()
true
if this constraint is a 'list' validation with explicit values
(如果此约束是具有显式值的“列表”验证,则为 true)
public int getOperator()
getOperator
in interface
DataValidationConstraint
(接口 DataValidationConstraint 中的 getOperator)
DataValidationConstraint.OperatorType
public void setOperator(int operator)
DataValidationConstraint
setOperator
in interface
DataValidationConstraint
(接口 DataValidationConstraint 中的 setOperator)
DataValidationConstraint.OperatorType
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 void setExplicitListValues(java.lang.String[] explicitListValues)
setExplicitListValues
in interface
DataValidationConstraint
(接口 DataValidationConstraint 中的 setExplicitListValues)
public java.lang.String getFormula1()
getFormula1
in interface
DataValidationConstraint
(接口 DataValidationConstraint 中的 getFormula1)
null
(表达式 1 的公式。可能为空)
public void setFormula1(java.lang.String formula1)
DataValidationConstraint
setFormula1
in interface
DataValidationConstraint
(接口 DataValidationConstraint 中的 setFormula1)
public java.lang.String getFormula2()
getFormula2
in interface
DataValidationConstraint
(接口 DataValidationConstraint 中的 getFormula2)
null
(表达式 2 的公式。可能为空)
public void setFormula2(java.lang.String formula2)
DataValidationConstraint
setFormula2
in interface
DataValidationConstraint
(接口 DataValidationConstraint 中的 setFormula2)
public java.lang.Double getValue1()
null
(表达式 1 的数值。可能为 null)
public void setValue1(double value1)
public java.lang.Double getValue2()
null
(表达式 2 的数值。可能为 null)
public void setValue2(double value2)
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.