The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

DataValidationType Enum

Lists data validation types.

Namespace: DevExpress.Spreadsheet

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

Declaration

public enum DataValidationType
Public Enum DataValidationType
public enum DataValidationType
Public Enum DataValidationType
public enum DataValidationType
Public Enum DataValidationType

Members

Name Description
AnyValue

Any value satisfies validation criteria, equivalent to no validation.

Custom

Data is validated using an arbitrary formula.

Date

Checks for date values satisfying the given condition.

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.

TextLength

Checks for text values whose length satisfies the given condition.

Time

Checks for time values satisfying the given condition.

WholeNumber

Checks for whole numeric values satisfying given conditions.

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