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.
I can confirm this behavior/missing possibility in
Version 126.96.36.199.beta2 (Build ID: 4104d660979c57e1160b5135634f732918460a0)
on Ubuntu 12.04 (x86)
Enhancement, marked as NEW, as the function is not implemented at the moment
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 ...