[]
Specifies the type of data validation used to validate user input.
public enum DataValidationType : byte
Public Enum DataValidationType As Byte
| Name | Description |
|---|---|
| Custom | Data validation which uses a custom formula to check the cell value. |
| Date | Data validation which checks for date values satisfying the given condition. |
| Decimal | Data validation which checks for decimal values satisfying the given condition. |
| InputOnly | Only validate when user changes the value. |
| List | Data validation which checks for a value matching one of list of values. The maximum length of a list is 255 characters. |
| TextLength | Data validation which checks for text values, whose length satisfies the given condition. |
| Time | Data validation which checks for time values satisfying the given condition. |
| WholeNumber | Data validation which checks for whole number values satisfying the given condition. |