Package org.apache.poi.ss.usermodel
Interface DataValidationConstraint
- All Known Implementing Classes:
DVConstraint
,XSSFDataValidationConstraint
public interface DataValidationConstraint
-
Nested Class Summary
Nested ClassesModifier and TypeInterfaceDescriptionstatic final class
Condition operator enumstatic final class
ValidationType enum -
Method Summary
Modifier and TypeMethodDescriptionString[]
If validation type isDataValidationConstraint.ValidationType.LIST
andformula1
was comma-separated literal values rather than a range or named range, returns list of literal values.int
int
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
-
Method Details
-
getValidationType
int getValidationType()- Returns:
- data validation type of this constraint
- See Also:
-
getOperator
int getOperator()- Returns:
- the operator used for this constraint
- See Also:
-
setOperator
void setOperator(int operator) Sets the comparison operator for this constraint- See Also:
-
getExplicitListValues
String[] getExplicitListValues()If validation type isDataValidationConstraint.ValidationType.LIST
andformula1
was comma-separated literal values rather than a range or named range, returns list of literal values. Otherwise returnsnull
. -
setExplicitListValues
-
getFormula1
String getFormula1()- Returns:
- the formula for expression 1. May be
null
-
setFormula1
Sets a formula for expression 1. -
getFormula2
String getFormula2()- Returns:
- the formula for expression 2. May be
null
-
setFormula2
Sets a formula for expression 2.
-