.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

DataValidationType Enum

Lists data validation types.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v20.1.Core.dll

Declaration

public enum DataValidationType
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.

NOTE

A complete sample project is available at https://github.com/DevExpress-Examples/spreadsheet-document-api-part-3

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