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.
