How to: Reapply a Filter
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.
Note
A complete sample project is available at https://github.com/DevExpress-Examples/wpf-spreadsheetcontrol-api-part-2-e4944.
' Enable filtering for the specified cell range.
Dim range As 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()