Lists comparison operators used in a custom filter.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v19.2.Core.dll
| 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. |
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.