Macros/Calc/ba027/en

Summary
This page provides a LibreOffice Basic macro procedure that removes the current sheet filter by setting an empty filter. It is an example drawn from Chapter 13 ("Calc as a Database") of the 7.0 Calc Guide.

Description
When a filter is applied to a sheet, it replaces any existing filter for that sheet. Therefore, to remove a filter in a sheet, simply create and set an empty filter for that sheet (see code below).

Code
This [[Media:Clear_all_filters_with_macro.ods|Calc spreadsheet]] contains the above LibreOffice Basic code.