[]
Specifies the type of validation test to be performed in conjunction with values.
public enum ValidationType
Public Enum ValidationType
| Name | Description |
|---|---|
| Custom | Specifies that the data validation uses a custom formula to check the cell value. |
| Date | Specifies that the data validation checks for and allows date values that meet the given condition. |
| Decimal | Specifies that the data validation checks for and allows decimal values that meet the given condition. |
| List | Specifies that the data validation checks for and allows a value that matches one in a list of values. |
| None | Specifies that the data validation allows any type of value and does not check for a type or range of values. |
| TextLength | Specifies that the data validation checks for and allows text values whose length meet the given condition. |
| Time | Specifies that the data validation checks for and allows time values that meet the given condition. |
| Whole | Specifies that the data validation checks for and allows whole number values that meet the given condition. |