ig.excel.DataValidationCriteria
Dependencies
-
date
- Type:
- ig.excel.DataValidationCriteria
- Default:
- 4
Dates with or without time portions are allowed as well as numbers equivalent to valid dates. When comparing against constraints, the cell value is used.
-
decimal
- Type:
- ig.excel.DataValidationCriteria
- Default:
- 2
Only numbers are allowed. When comparing against constraints, the cell value is used.
-
textLength
- Type:
- ig.excel.DataValidationCriteria
- Default:
- 6
Non-error values are allowed. When comparing against constraints, the length of the cell value's text equivalent is used.
-
time
- Type:
- ig.excel.DataValidationCriteria
- Default:
- 5
Times are allowed are well as numbers equivalent to valid times without a date portion. When comparing against constraints, the cell value is used.
-
wholeNumber
- Type:
- ig.excel.DataValidationCriteria
- Default:
- 1
Only numbers are allowed and they cannot have a fractional part. When comparing against constraints, the cell value is used.