XlDataValidationOperator Enum

Lists the types of operators that can be used in certain data validation types.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v18.1.Core.dll

Declaration

C#

public enum XlDataValidationOperator

VB.NET

Public Enum XlDataValidationOperator

Members

Name	Description
Between	Checks whether the cell value falls within a specified range of values.
NotBetween	Checks whether the cell value does not fall with a specified range of values.
Equal	Checks whether the cell value equals a specified value.
NotEqual	Checks whether the cell value is not equal to a specified value.
LessThan	Checks whether the cell value is less than a specified value.
LessThanOrEqual	Checks whether the cell values is less than or equal to a specified value.
GreaterThan	Checks whether the cell value is greater than a specified value.
GreaterThanOrEqual	Checks whether the cell value is greater than or equal to a specified value.

Related API Members

The following properties accept/return XlDataValidationOperator values:

• XlDataValidation.Operator

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the XlDataValidationOperator 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.

C#

how-to-use-the-excel-export-api-to-generate-a-list-of-employees-t251723/CS/XLExportExample/Form1.cs#L318

validation.Type = XlDataValidationType.Whole;
validation.Operator = XlDataValidationOperator.Between;
validation.Criteria1 = 600;

excel-export-api-examples-t253492/CS/XLExportExamples/SpreadsheetActions/DataActions.cs#L934

validation.Type = XlDataValidationType.Whole;
validation.Operator = XlDataValidationOperator.Between;
validation.Criteria1 = 600;

VB.NET

how-to-use-the-excel-export-api-to-generate-a-list-of-employees-t251723/VB/XLExportExample/Form1.vb#L334

validation.Type = XlDataValidationType.Whole
validation.Operator = XlDataValidationOperator.Between
validation.Criteria1 = 600

excel-export-api-examples-t253492/VB/XLExportExamples/SpreadsheetActions/DataActions.vb#L834

validation.Type = XlDataValidationType.Whole
validation.Operator = XlDataValidationOperator.Between
validation.Criteria1 = 600