|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||
java.lang.Objectorg.apache.poi.hssf.usermodel.DVConstraint
public class DVConstraint
| Nested Class Summary | |
|---|---|
static class |
DVConstraint.OperatorType
Condition operator enum |
static class |
DVConstraint.ValidationType
ValidationType enum |
| Method Summary | |
|---|---|
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()
|
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. |
void |
setFormula2(java.lang.String formula2)
Sets a formula for expression 2. |
void |
setOperator(int operator)
Sets the comparison operator for this constraint |
void |
setValue1(double value1)
Sets a numeric value for expression 1. |
void |
setValue2(double value2)
Sets a numeric value for expression 2. |
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Method Detail |
|---|
public static DVConstraint createNumericConstraint(int validationType,
int comparisonOperator,
java.lang.String expr1,
java.lang.String expr2)
validationType - one of DVConstraint.ValidationType.ANY, DVConstraint.ValidationType.DECIMAL,
DVConstraint.ValidationType.INTEGER, DVConstraint.ValidationType.TEXT_LENGTHcomparisonOperator - any constant from DVConstraint.OperatorType enumexpr1 - date formula (when first char is '=') or formatted number valueexpr2 - date formula (when first char is '=') or formatted number valuepublic 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 DVConstraint.OperatorType enumexpr1 - date formula (when first char is '=') or formatted time valueexpr2 - date formula (when first char is '=') or formatted time value
public static DVConstraint createDateConstraint(int comparisonOperator,
java.lang.String expr1,
java.lang.String expr2,
java.lang.String dateFormat)
comparisonOperator - constant from DVConstraint.OperatorType enumexpr1 - date formula (when first char is '=') or formatted date valueexpr2 - date formula (when first char is '=') or formatted date valuedateFormat - ignored if both expr1 and expr2 are formulas. Default value is "YYYY/MM/DD"
otherwise any other valid argument for SimpleDateFormat can be usedpublic static DVConstraint createCustomFormulaConstraint(java.lang.String formula)
public int getValidationType()
DVConstraint.ValidationTypepublic boolean isListValidationType()
true if this constraint is a 'list' validationpublic boolean isExplicitList()
true if this constraint is a 'list' validation with explicit valuespublic int getOperator()
DVConstraint.OperatorTypepublic void setOperator(int operator)
DVConstraint.OperatorTypepublic java.lang.String[] getExplicitListValues()
public void setExplicitListValues(java.lang.String[] explicitListValues)
public java.lang.String getFormula1()
nullpublic void setFormula1(java.lang.String formula1)
public java.lang.String getFormula2()
nullpublic void setFormula2(java.lang.String formula2)
public java.lang.Double getValue1()
nullpublic void setValue1(double value1)
public java.lang.Double getValue2()
nullpublic void setValue2(double value2)
|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||