Skip to main content
.NET Framework 4.5.2+
Row

DataValidationType Enum

Lists data validation types.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v21.2.Core.dll

Declaration

public enum DataValidationType

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]);
}

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.

See Also