FilterComparisonOperator Enum

Lists comparison operators used in a custom filter.

Namespace : DevExpress.Spreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

• C#
• VB.NET

public enum FilterComparisonOperator

Public Enum FilterComparisonOperator

Members

Filters values that are less than a specified criterion value.

| | Equal |

Filters values that are equal to a specified criterion value.

| | LessThanOrEqual |

Filters values that are less than or equal to a specified criterion value.

| | GreaterThan |

Filters values that are greater than a specified criterion value.

| | NotEqual |

Filters values that are not equal to a specified criterion value.

| | GreaterThanOrEqual |

Filters values that are greater than or equal to a specified criterion value.

|

Related API Members

The following properties accept/return FilterComparisonOperator values:

• CustomFilter.FirstCriteriaOperator
• CustomFilter.SecondCriteriaOperator

Remarks

The AutoFilterColumn.ApplyCustomFilter method uses the FilterComparisonOperator enumeration to specify criteria operators when applying a custom filter.

When a custom filter is applied, you can use the CustomFilter.FirstCriteriaOperator and CustomFilter.SecondCriteriaOperator properties to get information about criteria comparison operators.

See Also

DevExpress.Spreadsheet Namespace