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/spreadsheet-document-server-api-part-2-t217615
Worksheet worksheet = workbook.Worksheets["Regional sales"];
workbook.Worksheets.ActiveWorksheet = worksheet;
// Enable filtering for the specified cell range.
Range 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();