https://bugs.documentfoundation.org/show_bug.cgi?id=171530
Bug ID: 171530
Summary: add 'live filter' option to columns
Product: LibreOffice
Version: 26.2.1.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Feature Request: add an option to show a 'live filter' for each column
Steps to Reproduce:
1. Imagine you have a table of persons. Columns are Name, Surname, ID,
Position, etc. The list is not ordered in any sensible way
2. Now you want to search for someone very quickly, but you only remember the
name of the person (and the name is very common, there are dozens of people
with that name) and their position at the company (but the position is also not
unique).
3. Then another task arrives, now you have to search for another list of
persons as quickly as possible. Which means you will waste quite some time
doing that.
Actual Results:
Normally, you would either search using "Find" and cycling "find next" until
you actually find your person. Or you can use the autofilter and edit the
columns "Name" and "Position" until you find the person.
Expected Results:
It would be great if you could have a 'live filter' on top of each column,
where you can just start typing, and only the rows that match the filter are
visible, and update as you type.
In the example above, you would type "ste" on the 'live filter' at the "NAME"
column, and automatically the rows with "stephan", "stephany", "steve", etc.
would be visible. Then on the 'live filter' of "POSITION" you type "dev" and
find that there is only on "Stephany" who is "main developer"
Reproducible: Always
User Profile Reset: No
Additional Info:
This is a great way of searching for something, incredibly fast compared to
opening each autofilter, editing, applying, etc.
This is just one silly case I illustrate. But in data exploration, data
wrangling, data analysis, etc., this would be a huge improvement. Also, as far
as I know, not even Excel has this functionality!
Options to think:
- case sensitive: should the filter treat 'Ste' equal to 'ste'?
- position: should the filter find "dev" only in positions that start with
"dev" (eg "developer") or also those which contain "dev" (eg "main developer")
--
You are receiving this mail because:
You are the assignee for the bug.
