https://bugs.documentfoundation.org/show_bug.cgi?id=117276
--- Comment #17 from Mike Kaganski <mikekagan...@hotmail.com> --- (In reply to Heiko Tietze from comment #16) > There are two options: > > a) Show only those entries that are currently listed plus what has been > filtered-out in the actual column; without Opel you neither have 7000 in the > sheet not the filter; with 7000 unchecked you have Opel except from 2007. > Checking something that matches other filters reverts them. > > b) The autofilter always lists all entries; checking Opel does not bring it > back to the sheet until 7000 and 9000 are checked as well > > We do a) likewise Excel. Changing it might be unexpected. The question is not specifically "what to show", but rather - in case #1 - if the shown list must be considered as "complete" list. The problem is: (In reply to Samuel Mehrbrodt (allotropia) from comment #15) > So technically this is correct: The highlight on column B is reset after > step 5, because all items in column B (which are not hidden by other > filters) are visible. Selecting all items *shown* in the list in a given autofilter resets the autofilter - even if some unselected items are hidden from it. Which is wrong. -- You are receiving this mail because: You are on the CC list for the bug.