Bug 55398 - FILTER: Enable on/off toggling for complex filtering under autofilter
Summary: FILTER: Enable on/off toggling for complex filtering under autofilter
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.5 Daily
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: AutoFilter
  Show dependency treegraph
Reported: 2012-09-28 01:54 UTC by Tom Colley
Modified: 2021-06-15 15:19 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Tom Colley 2012-09-28 01:54:51 UTC
I imagine many users who use the autofilter functionality of Calc would like to be able to toggle the filter on and off, without losing the specification of the filter. Currently, if the "Standard Filter" option is used to specify two or more filter conditions, such toggling is not possible. The specification is lost once the user returns to viewing the unfiltered dataset.

This enhancement would allow users to quickly see filtered results in and out of their context with the unfiltered dataset. Most useful for investigative analyses.
Comment 1 Sören 2012-12-30 12:53:20 UTC
I can confirm this behavior/missing possibility in
Version (Build ID: 4104d660979c57e1160b5135634f732918460a0)
on Ubuntu 12.04 (x86)

Enhancement, marked as NEW, as the function is not implemented at the moment
Comment 2 b. 2020-09-02 22:07:39 UTC
would be a very nice enhancement ... 

tried to build similar with a macro, blocked by '.field'-values messed up by calc with wrong 'table:orientation' attributes and reliable coding not possible :-(  

i'm curious about the use / functionality of 'Hide Autofilter' in [data - more filters], couldn't find a hint on that, just one comment that another user would like to know that as well ...
Comment 3 stragu 2021-06-15 15:19:20 UTC
Still not possible in:

Version: / LibreOffice Community
Build ID: de7356c2e0cb099fac396808b5a86a0393b48e5f
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-06-14_22:38:17
Calc: threaded

Steps to reproduce:

1. Activate autofilter on a table
2. Use "Standard Filter..." in one column's autofilter dropdown to setup some rules
3. Click "Clear filter" on that column
4. Go back to "Standard Filter..."

Results: the previously defined rules cannot be restored. They must be defined from scratch.