CustomFilter Interface

Contains the settings of a custom filter.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public interface CustomFilter

VB.NET

Public Interface CustomFilter

Related API Members

The following members return CustomFilter objects:

• AutoFilterColumn.CustomFilter

Remarks

Use the CustomFilter properties to obtain the criteria, values and operator used in a custom filter.

An end-user can apply a custom filter using the Custom AutoFilter dialog invoked by selecting Custom Filter in the menu that appears by clicking the arrow in the column header. The dialog is shown below.

The custom filter applied by this dialog will have the

• CustomFilter.FirstCriteria = 3000
• CustomFilter.FirstCriteriaOperator = FilterComparisonOperator.GreaterThan
• CustomFilter.SecondCriteria = 5000
• CustomFilter.SecondCriteriaOperator = FilterComparisonOperator.LessThanOrEqual
• CustomFilter.CriterionAnd = true

Note

Do not modify a custom filter programmatically. Apply a new filter using the AutoFilterColumn.ApplyCustomFilter method instead.