Summary: | Add UI Configuration Option To Disable Showing Hidden Filter Elements As Inactive In Autofilter | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Kevin Suo <suokunlong> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | UNCONFIRMED --- | ||
Severity: | enhancement | CC: | balazs.varga991, miguelangelrv, rafael.palma.lima |
Priority: | medium | ||
Version: | 7.6.4.1 release | ||
Hardware: | All | ||
OS: | All | ||
See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=117276 https://bugs.documentfoundation.org/show_bug.cgi?id=158314 |
||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 103512 | ||
Attachments: | test ods file |
Description
Kevin Suo
2023-12-16 14:54:04 UTC
Adding Balazs Varga to cc because he has worked on that feature. They are shown in gray for me at the end of the selectable items, not in the middle. I don't think they can bother in this way. In "production" usage, spreadsheets can have millions of records. We do autofiltering to narrow down the results. For me, it makes no sense to show everything in the dropdown (while maybe some few others may like this feature). Anyway, this should be configurable. And that is a TODO as shown in the commit message in commit 2d1df9f3dccc10f13b8585ad18afce1542ebc4d1: "TODO: maybe we can add a global option where the user can switch on/off this feature." I too do not like this feature. I often open sheets with 50 thousand rows or more and this is a bit annoying. Even if you have very few visible rows (f.i. 3 rows), thousands of options will be visible in the auto filter. (In reply to Kevin Suo from comment #3) > "TODO: maybe we can add a global option where the user can switch on/off > this feature." I'm not sure this should be a global option, because when the user needs to toggle this option, this needs to be done quickly. Maybe we could have a quick checkbox to show/hide inactive elements in the autofilter dialog itself (by default the "hide" option should be checked). |