officefileapi-devexpress-dot-spreadsheet-dot-autofilterbase-21473c4f.md
Removes all the filters specified in a worksheet and displays all hidden rows.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
void Clear()
Sub Clear
To clear a filter for a specified column, use the AutoFilterColumn.Clear method.
Worksheet worksheet = workbook.Worksheets["Regional sales"];
workbook.Worksheets.ActiveWorksheet = worksheet;
// 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);
// Clear the filter.
worksheet.AutoFilter.Clear();
Dim worksheet As Worksheet = workbook.Worksheets("Regional sales")
workbook.Worksheets.ActiveWorksheet = worksheet
' 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)
' Clear the filter.
worksheet.AutoFilter.Clear()
The following code snippets (auto-collected from DevExpress Examples) contain references to the Clear() method.
Note
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.
winforms-spreadsheet-use-custom-cell-editors/CS/DevAVInvoicing/Form1.cs#L143
Table storesTable = customerStores.Tables[0];
storesTable.AutoFilter.Clear();
storesTable.AutoFilter.Columns[1].ApplyFilterCriteria(customerId);
// Clear the filter.
worksheet.AutoFilter.Clear();
#endregion #ClearFilter
// Clear the filter.
worksheet.AutoFilter.Clear();
#endregion #ClearFilter
// Clear the filter.
worksheet.AutoFilter.Clear();
#endregion #ClearFilter
winforms-spreadsheet-use-custom-cell-editors/VB/DevAVInvoicing/Form1.vb#L131
Dim storesTable As Table = customerStores.Tables(0)
storesTable.AutoFilter.Clear()
storesTable.AutoFilter.Columns(1).ApplyFilterCriteria(customerId)
' Clear the filter.
worksheet.AutoFilter.Clear()
' #End Region ' #ClearFilter
' Clear the filter.
worksheet.AutoFilter.Clear()
' #End Region ' #ClearFilter
' Clear the filter.
worksheet.AutoFilter.Clear()
' #End Region ' #ClearFilter
See Also