corelibraries-devexpress-dot-export-dot-xl-dot-xldatavalidation-7d10f50f.md
Gets or sets the type of data validation.
Namespace : DevExpress.Export.Xl
Assembly : DevExpress.Printing.v25.2.Core.dll
NuGet Package : DevExpress.Printing.Core
public XlDataValidationType Type { get; set; }
Public Property Type As XlDataValidationType
| 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.
|
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.
See Also