XlDataValidation.Type Property

Gets or sets the type of data validation.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v23.2.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public XlDataValidationType Type { get; set; }

VB.NET

Public Property Type As XlDataValidationType

Property Value

Type	Description
XlDataValidationType	One of the XlDataValidationType enumeration values that specifies the data validation type.

Available values:

Name	Description
None	No value conforms the validation criteria.
Whole	Checks for whole numeric values conforming the given condition.
Decimal	Checks for decimal values conforming the given condition.
List	Checks the values that matches the list or certain values.
Date	Checks for date values conforming the given condition.
Time	Checks for time values conforming the given condition
TextLength	Checks text values which lengths conforms the given condition.
Custom	The data is validated by an arbitrary formula.

Remarks

Note

The maximum length of a list used to specify the XlDataValidationType.List validation type or a custom validation criteria is 255 characters. When a list or criteria exceeds this value, an InvalidOperationException is thrown.