XlFilterOperator Enum

Lists comparison operators used in a custom filter.

Namespace: DevExpress.Export.Xl

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

Declaration

C#

public enum XlFilterOperator

VB.NET

Public Enum XlFilterOperator

Members

Name	Description
Equal	Filters values that are equal to a specified criterion value.
GreaterThan	Filters values that are greater than a specified criterion value.
GreaterThanOrEqual	Filters values that are greater than or equal to a specified criterion value.
LessThan	Filters values that are less than a specified criterion value.
LessThanOrEqual	Filters values that are less than or equal to a specified criterion value.
NotEqual	Filters values that are not equal to a specified criterion value.

Related API Members

The following properties accept/return XlFilterOperator values:

• XlCustomFilterCriteria.FilterOperator

Remarks

The XlFilterOperator enumeration member is used to construct filter criteria for a custom filter (XlCustomFilterCriteria). Subsequently, it is the value of the XlCustomFilterCriteria.FilterOperator property.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the XlFilterOperator 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#

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

// Create a custom filter to display values in the "Sales" column that are greater than $4500.
XlCustomFilters filter = new XlCustomFilters(new XlCustomFilterCriteria(XlFilterOperator.GreaterThanOrEqual, 4500));
sheet.AutoFilterColumns.Add(new XlFilterColumn(2, filter));

VB.NET

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

' Create a custom filter to display values in the "Sales" column that are greater than $4500.
Dim filter As New XlCustomFilters(New XlCustomFilterCriteria(XlFilterOperator.GreaterThanOrEqual, 4500))
sheet.AutoFilterColumns.Add(New XlFilterColumn(2, filter))