DataValidation.ValidationType Property
Gets the type of data validation.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v18.2.Core.dll
Declaration
Property Value
Type | Description |
---|---|
DataValidationType | A DataValidationType enumeration member that specifies the type of data validation used to validate user input. |
Available values:
Name | Description |
---|---|
AnyValue | Any value satisfies validation criteria, equivalent to no validation. |
WholeNumber | Checks for whole numeric values satisfying given conditions. |
Decimal | Checks for decimal values satisfying the given condition. |
List | Checks whether a value matches a specified list of values. The maximum length of a list is 255 characters. |
Date | Checks for date values satisfying the given condition. |
Time | Checks for time values satisfying the given condition. |
TextLength | Checks for text values whose length satisfies the given condition. |
Custom | Data is validated using an arbitrary formula. |
Remarks
To create a data validation entry of the required type, use the DataValidationCollection.Add method. To change the type of data validation, add new data validation for the required worksheet range. The former data validation will no longer be applied.