[]
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. |