Created attachment 188388 [details] Proposed position for the "Invert" button In Calc I often face the following problem: Suppose I have a large table in a sheet and it has AutoFilter enabled. Now consider a column in this table that has many unique values (hundreds or thousands of them). Imagine now that from these hundreds/thousands of values, I selected 20 of them to filter the table. The problem now is when I simply want to invert the selection, to see the lines that weren't previously visible. Currently I have to clear the filter and uncheck the 20 values one by one, which is tedious and prone to error. A better approach would be to add a "Invert" button to the Autofilter (see attached image) that would simply invert the selection status of all items.
Depends on how often users invert a selection; not sure it's a frequent use case. OTOH, the additional button doesn't clutter the UI much.
(In reply to Heiko Tietze from comment #1) > Depends on how often users invert a selection; not sure it's a frequent use > case. OTOH, the additional button doesn't clutter the UI much. The current 2 buttons allow such inversion to _one_ item regarding the rest. Perhaps there is a way to mix/compress the request into the current 2 buttons? Or to merge the current 2 buttons (action depends on item checked or unchecked) and add the request? Or to merge them all? Split button or similar? A different use-case (that already has an alternative): instead of (un)selecting _most_ items, a user would (un)select the minority of them and then revert the selection. The current method is to click on "All" first and then (un)select the lesser amount of items, but might not be practical for a long list of items to (un)select. This would be a "nice to have", not a "must-have".
We discussed the topic in the design meeting and decided to follow the suggestion.