Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Auto-filters: when reset, why do the filters remember the critiera?

LibreOffice Calc version 6.0.5.2 running on Linux Mint Xfce 18.3

When an auto-filter is set, it works fine. When a series of auto-filters are set, likewise.

But Data > More Filters > Reset Filters only seems to do half the job.

It restores the unfiltered view, which is part of the correct outcome, but the auto-filter controls remain flagged with criteria (they are blue). Opening the filter reveals that the filter has remembered the criteria.

So if another filter is applied - as if to create a fresh filter - then the third filter is limited by the union of the previous filters, as if the filter reset never happened.

Is this by design?

If it is by design, it's not useful. The user has to manually go to each filter and manually unset them one-by-one. Defeats the objective of resetting the filers. Can we then have a feature request to make auto-filters and their resets work the same as Excel?

The workbooks on which this were tested were imported by Calc as XLSX and saved as ODS, closed and re-opened as ODS.