DataValidationType Enum
Lists data validation types.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v21.2.Core.dll
Declaration
Members
| 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
Use the DataValidationCollection.Add method to create a data validation of the required type. The DataValidation.ValidationType property obtains the type of the data validation. This property is read-only, because the data validation type is specified when the data validation entry is created, and cannot be changed.
workbook.LoadDocument("Documents\\DataValidation.xlsx");
Worksheet worksheet = workbook.Worksheets[0];
// Restrict data entry to a number within limits.
DataValidation validation = worksheet.DataValidations.Add(worksheet["F4:F11"], DataValidationType.Decimal, DataValidationOperator.Between, 10, 40);
// Change the validation operator and criteria.
// Range F4:F11 should contain numbers greater than or equal 20.
validation.Operator = DataValidationOperator.GreaterThanOrEqual;
validation.Criteria = 20;
validation.Criteria2 = ValueObject.Empty;
// Highlight data validation ranges.
int[] MyColorScheme = new int[] { 0xFFC4C4, 0xFFD9D9, 0xFFF6F6, 0xFFECEC, 0xE9D3D3 };
for (int i = 0; i < worksheet.DataValidations.Count; i++)
{
worksheet.DataValidations[i].Range.FillColor = Color.FromArgb(MyColorScheme[i]);
}
Related GitHub Examples
The following code snippets (auto-collected from DevExpress Examples) contain references to the DataValidationType enum.
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.