FilterComparisonOperator Enum

Lists comparison operators used in a custom filter.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

public enum FilterComparisonOperator

VB.NET

Public Enum FilterComparisonOperator

Members

Name	Description
LessThan	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.

Related GitHub Examples

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

wpf-spreadsheetcontrol-api-part-2-e4944/CS/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/AutoFilterActions.cs#L106

AutoFilterColumn sales = worksheet.AutoFilter.Columns[2];
sales.ApplyCustomFilter(5000, FilterComparisonOperator.GreaterThanOrEqual, 8000, FilterComparisonOperator.LessThanOrEqual, true);
#endregion #FilterByCondition

spreadsheet-document-api-examples-part-2-t217615/CS/SpreadsheetDocServerAPIPart2/CodeExamples/AutoFilterActions.cs#L66

AutoFilterColumn sales = worksheet.AutoFilter.Columns[2];
sales.ApplyCustomFilter(5000, FilterComparisonOperator.GreaterThanOrEqual, 8000, FilterComparisonOperator.LessThanOrEqual, true);
#endregion #FilterNumbersByCondition

winforms-spreadsheetcontrol-api-part-2-e4832/CS/SpreadsheetControl_API_Part02/SpreadsheetActions/AutoFilterActions.cs#L103

AutoFilterColumn sales = worksheet.AutoFilter.Columns[2];
sales.ApplyCustomFilter(5000, FilterComparisonOperator.GreaterThanOrEqual, 8000, FilterComparisonOperator.LessThanOrEqual, true);
#endregion #FilterByCondition

VB.NET

wpf-spreadsheetcontrol-api-part-2-e4944/VB/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/AutoFilterActions.vb#L99

                Dim sales As AutoFilterColumn = worksheet.AutoFilter.Columns(2)
                sales.ApplyCustomFilter(5000, FilterComparisonOperator.GreaterThanOrEqual, 8000, FilterComparisonOperator.LessThanOrEqual, True)
'                #End Region ' #FilterByCondition

spreadsheet-document-api-examples-part-2-t217615/VB/SpreadsheetDocServerAPIPart2/CodeExamples/AutoFilterActions.vb#L64

            Dim sales As AutoFilterColumn = worksheet.AutoFilter.Columns(2)
            sales.ApplyCustomFilter(5000, FilterComparisonOperator.GreaterThanOrEqual, 8000, FilterComparisonOperator.LessThanOrEqual, True)
'            #End Region ' #FilterNumbersByCondition

winforms-spreadsheetcontrol-api-part-2-e4832/VB/SpreadsheetControl_API_Part02/SpreadsheetActions/AutoFilterActions.vb#L100

                Dim sales As AutoFilterColumn = worksheet.AutoFilter.Columns(2)
                sales.ApplyCustomFilter(5000, FilterComparisonOperator.GreaterThanOrEqual, 8000, FilterComparisonOperator.LessThanOrEqual, True)
'                #End Region ' #FilterByCondition