https://bugs.documentfoundation.org/show_bug.cgi?id=156305

--- Comment #8 from imcon <[email protected]> ---
Following up on my comment 4, I am attaching a new UI mockup as an alternative
to attachment 188388. It proposes an explicit “Invert Selection” menu entry in
the AutoFilter dropdown, labelled “Inverze” in the Czech mockup.

Regarding the UI alternatives discussed in comment 2, a labelled menu entry
would make the action discoverable without requiring users to infer a
combination of existing icon buttons. It would also allow the existing controls
to retain their current functions.

Regarding the regular-expression suggestion in comment 6: a manually selected
set of values may have no common textual pattern. Inverting that existing
selection would work independently of the contents of the values and would not
require users to construct or maintain a matching expression.

There is also an opportunity for Calc to offer a usability advantage over
Excel. Microsoft's current AutoFilter documentation for Excel for Microsoft 365
and Excel 2024 describes manual checkbox selection and searching, but does not
document a direct “Invert Selection” command:
https://support.microsoft.com/en-au/excel/use-autofilter-to-filter-your-data

Based on that documentation, this enhancement could give Calc a useful
capability beyond Excel's documented AutoFilter interface. Improving
compatibility and providing additional workflow improvements are both valuable
goals.

The underlying use case and the drawbacks of rebuilding the selection are
already covered in the original description, and the design team's support is
recorded in comment 3.

Could this alternative placement be considered when implementing the agreed
enhancement?

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to