ig.excel.ValueConstraintDataValidationRule
Dependencies
-
validationCriteria
- .validationCriteria( );
Gets the criteria to use when validating the cell value against the constraint(s).
Exceptions
Exception Description ig.excel.InvalidEnumArgumentException Occurs when the value is not a member of the DataValidationCriteria enumeration. Remarks
Depending on the value specified, either then cell value or the length of its text equivalent will be compared against the constraint(s). In addition, certain ValidationCriteria values may disallow a cell value even if it is valid when compared to the constraint. For example, the ValidationCriteria.WholeNumber value will not allow any number with a fractional portion.
-
validationCriteria
- .validationCriteria( value:ig.excel.DataValidationCriteria );
Sets the criteria to use when validating the cell value against the constraint(s).
- value
- Type:ig.excel.DataValidationCriteria
Exceptions
Exception Description ig.excel.InvalidEnumArgumentException Occurs when the value is not a member of the DataValidationCriteria enumeration. Remarks
Depending on the value specified, either then cell value or the length of its text equivalent will be compared against the constraint(s). In addition, certain ValidationCriteria values may disallow a cell value even if it is valid when compared to the constraint. For example, the ValidationCriteria.WholeNumber value will not allow any number with a fractional portion.