Skip to main content
Row

DataValidation.ValidationType Property

Gets the type of data validation.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

DataValidationType ValidationType { get; }

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.

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ValidationType property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also