XlDataValidation.Type Property
Gets or sets the type of data validation.
Namespace: DevExpress.Export.Xl
Assembly: DevExpress.Printing.v20.1.Core.dll
NuGet Packages: DevExpress.Printing.Core, DevExpress.WindowsDesktop.Printing.Core
Declaration
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.