public class XSSFDataValidationConstraint extends Object implements DataValidationConstraint
DataValidationConstraint.OperatorType, DataValidationConstraint.ValidationType
Constructor and Description |
---|
XSSFDataValidationConstraint(int validationType,
int operator,
String formula1) |
XSSFDataValidationConstraint(int validationType,
int operator,
String formula1,
String formula2)
This is the constructor called using the OOXML raw data.
|
XSSFDataValidationConstraint(int validationType,
String formula1) |
XSSFDataValidationConstraint(String[] explicitListOfValues)
list literal constructor
|
Modifier and Type | Method and Description |
---|---|
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. |
String |
getFormula1() |
String |
getFormula2() |
int |
getOperator() |
int |
getValidationType() |
String |
prettyPrint() |
void |
setExplicitListValues(String[] explicitListValues) |
void |
setFormula1(String formula1)
Sets a formula for expression 1.
|
void |
setFormula2(String formula2)
Sets a formula for expression 2.
|
void |
setOperator(int operator)
Sets the comparison operator for this constraint
|
void |
validate() |
public XSSFDataValidationConstraint(String[] explicitListOfValues)
public XSSFDataValidationConstraint(int validationType, String formula1)
public XSSFDataValidationConstraint(int validationType, int operator, String formula1)
public XSSFDataValidationConstraint(int validationType, int operator, String formula1, String formula2)
validationType
- operator
- formula1
- Overloaded: formula1 or list of explicit valuesformula2
- (formula1 is a list of explicit values, this is ignored: use null
)public 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
.getExplicitListValues
in interface DataValidationConstraint
public String getFormula1()
getFormula1
in interface DataValidationConstraint
null
public String getFormula2()
getFormula2
in interface DataValidationConstraint
null
public int getOperator()
getOperator
in interface DataValidationConstraint
DataValidationConstraint.OperatorType
public int getValidationType()
getValidationType
in interface DataValidationConstraint
DataValidationConstraint.ValidationType
public void setExplicitListValues(String[] explicitListValues)
setExplicitListValues
in interface DataValidationConstraint
public void setFormula1(String formula1)
DataValidationConstraint
setFormula1
in interface DataValidationConstraint
public void setFormula2(String formula2)
DataValidationConstraint
setFormula2
in interface DataValidationConstraint
public void setOperator(int operator)
DataValidationConstraint
setOperator
in interface DataValidationConstraint
DataValidationConstraint.OperatorType
public void validate()
public String prettyPrint()
Copyright © 2010 - 2020 Adobe. All Rights Reserved