ContextQMD
Back to Devexpress

How to: Reapply a Filter

windowsforms-18041-controls-and-libraries-spreadsheet-examples-filter-data-how-to-reapply-a-filter.md

latest1.4 KB
Original Source

How to: Reapply a Filter

  • Dec 12, 2022

The example below demonstrates how to use the AutoFilterBase.ReApply method of the SheetAutoFilter object to reapply a filter after the data in the filtered range has been changed.

View Example

csharp
// Enable filtering for the specified cell range.
CellRange range = worksheet["B2:E23"];
worksheet.AutoFilter.Apply(range);

// Filter values in the "Sales" column that are greater than 5000$.
worksheet.AutoFilter.Columns[2].ApplyCustomFilter(5000, FilterComparisonOperator.GreaterThan);

// Change the data and reapply the filter.
worksheet["D3"].Value = 5000;
worksheet.AutoFilter.ReApply();
vb
' Enable filtering for the specified cell range.
Dim range As CellRange = worksheet("B2:E23")
worksheet.AutoFilter.Apply(range)

' Filter values in the "Sales" column that are greater than 5000$.
worksheet.AutoFilter.Columns(2).ApplyCustomFilter(5000, FilterComparisonOperator.GreaterThan)

' Change the data and reapply the filter.
worksheet("D3").Value = 5000
worksheet.AutoFilter.ReApply()