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 classCondition operator enumstatic final classValidationType enum -
Method Summary
Modifier and TypeMethodDescriptionString[]If validation type isDataValidationConstraint.ValidationType.LISTandformula1was comma-separated literal values rather than a range or named range, returns list of literal values.intintvoidsetExplicitListValues(String[] explicitListValues) voidsetFormula1(String formula1) Sets a formula for expression 1.voidsetFormula2(String formula2) Sets a formula for expression 2.voidsetOperator(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.LISTandformula1was 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.
-