DataValidation.ValidationType Property

Gets the type of data validation.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.2.Core.dll

Declaration

C#

DataValidationType ValidationType { get; }

VB.NET

ReadOnly Property ValidationType As DataValidationType

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.