ValidationTypeenum
The type of data validation applied to cells in a column.
- WholeNumber
Only whole numbers are allowed. Once the whole number option is selected, other options become available to further limit input.
- Decimal
Only decimal numbers are allowed. Once the decimal number option is selected, other options become available to further limit input.
- Date
Only dates are allowed.
- Time
Only times are allowed.
- TextLength
Validates input based on number of characters or digits.
- List
Only values from a predefined list are allowed. The values are presented to the user as a dropdown menu control.