Skip to main content
.NET Framework 4.5.2+

AutoFilterColumn.ApplyDynamicFilter(DynamicFilterType) Method

Applies a dynamic filter that shows dates that fall within a specified time period or displays values that are above or below the average.

Namespace: DevExpress.Spreadsheet

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


void ApplyDynamicFilter(
    DynamicFilterType dynamicFilterType


Name Type Description
dynamicFilterType DynamicFilterType

A DynamicFilterType enumeration member that specifies the filter criterion.


The dynamic filter can change when the data to which the filter is applied or the current system date changes.


View Example

Worksheet worksheet = workbook.Worksheets["Regional sales"];
workbook.Worksheets.ActiveWorksheet = worksheet;

// Enable filtering for the specified cell range.
CellRange range = worksheet["B2:E23"];

// Apply a dynamic filter to the "Sales" column to display only values that are above the average.
// Apply a dynamic filter to the "Reported Date" column to display values reported this year.

The following code snippets (auto-collected from DevExpress Examples) contain references to the ApplyDynamicFilter(DynamicFilterType) method.


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.

See Also