https://bugs.documentfoundation.org/show_bug.cgi?id=158733
Bug ID: 158733
Summary: Add UI Configuration Option To Disable Showing Hidden
Filter Elements As Inactive In Autofilter
Product: LibreOffice
Version: 7.6.4.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 191457
--> https://bugs.documentfoundation.org/attachment.cgi?id=191457&action=edit
test ods file
The "showing hidden filter elements as inactive" feature is added in commit
2d1df9f3dccc10f13b8585ad18afce1542ebc4d1 (with follow-up commits
2085e90fe8ac129bc4dbac4612d1ea7544335dae and
7321db3cadc8c0e4437ca04e5dcb652734ea9c26). While we welcome new features, this
feature really annoys me in my daily workflow. I request to add a UI
configuration option to enable/disable this feature by the user *and* it
defaults to be disabled.
Steps to Reproduce:
1. Open the attached test ods file.
This file has two columns. the first column contains some unique IDs. The
second column contains some random integer numbers. The third column contains
some numbers representing the category of each ID.
2. Select "0" only in the autofilter dropdown in column 2, then click the
autofilter dropdown in column 1, then try to locate the last "active" ID (i.e.
0001385).
Current Behaviour:
In LibreOffice 7.6 (where this feature is enabled), in step 2 there are 2385
IDs shown in the dropdown while there are only 22 relevant. Who cares about
those inactive ones? Those inactive ones are very annoying because it does not
allow me to quickly locate the last ID. I need to scroll and scroll and be very
careful in order to observe where the last active ID is shown.
Expected Behaviour:
In step 2, with LibreOffice 7.4, when I click the dropdown in column 1, I can
quickly sroll to the last ID, select it and then observe its category number. I
can also quickly observe that there are roughly 20 items related to this filter
condition (one very important purpose of using autofilter is to quickly
understand your data!)
It's quick and convenient because the item list is always sorted so the last
one will always be at the end of the scroll bar.
As an experienced spreadsheet user, I really can not think of a use case when
the inactive items should be shown. It should be configurable and defaults to
be turned off.
--
You are receiving this mail because:
You are the assignee for the bug.
