https://bugs.documentfoundation.org/show_bug.cgi?id=156305
Bug ID: 156305
Summary: Allow to invert selection in Autofilter
Product: LibreOffice
Version: 7.5.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 188388
--> https://bugs.documentfoundation.org/attachment.cgi?id=188388&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
