[Libreoffice-ux-advise] [Bug 146018] Group similar autofilter submenu items to save the vertical space

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #25 from Kevin Suo <suokunlong at 126.com> ---
(In reply to Caolán McNamara from comment #21)
I like your proposal. It looks good.
And I also like the Standard Filter to go to the Filter By Condition submenu.
The key to the autofilter popup is "clear" and "quick" - the rows in the first
level popup menu, the better. Standard Filter should be a submenu because it is
by nature a more complex filter. People using autofilter normally set the
conditions one column by column. If he/she want to use the standard filter
directly, then he will simply use the Data > More Filers menu, or the Standard
Filter in the (proposed) autofilter submenu.

Below is a simple use case showing how spreadsheet experts uses autofilter
(take attachment 176404 for example):

1. I want to verify that the MaterialNumbers are valid. So, I click on filter
in column S, find that there are blanks. I filter those blanks, thinking while
they are blank. Then I find that they are blank may be because the QTYs (column
P) are zero.

2. Then I click the filter in column P, to verify that my guess was correct.
Then I find that not all QTYs in column P are zeros. So in addition to the
filter condition already set, I set filter the zeros in column P, and then
filter the non-zeros, trying to find a clue. Nothing special found.

3. Then I clear the filter condition in column P, but keep the filter condition
in column S, and then continue my research. Then I noticed that the empty
MaterialNumbers may be due to the "GL_Account". So I filter column A, notice
that there are only two General Ledger Accounts which have blank material
numbers. I got it!

4. Then I want to know more about my data, so I clear all the autofilter
conditions, and continue researching.

As shown in the above workflow, people working with autofilter are doing there
research on a "experimental" basis. They do not know what they want exactly at
the first time. After they know what they want and they have done enough
evaluation of their data, then they may use the Standard Filter (or simply
setting autofilter conditions one column by one column) to set more complex
conditions to get what they need.

-- 
You are receiving this mail because:
You are on the CC list for the bug.