[Libreoffice-ux-advise] [Bug 76258] Filter by colors in Calc

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #32 from Kevin Suo <suokunlong at 126.com> ---
> If we allow searching for colors we need another checkbox- and this clutters the dialog further.

Well, let's be clever. Currently, if column A contains the following records:
'''
a
1
2
3

4
'''

Then If I set an autofilter, I get the following in the dropdown:
'''
Sort Ascending
Sort Descending
Top 10
Empty
Not Empty
Standard Filter...
(Search items...)
All
1
2
3
4
(Empty)
'''

Well,
1. the "(Empty)" is automatically added to the list of there are empty items in
the record, and there will be no "(Empty)" in the autofilter if there is no
empty records. As a result, the "Empty" and "Not Empty" autofilter items are
not needed at all in my opinion.
2. Sort Ascending and Sort Descending: why not just group them into "Sort", and
provide two sub-items instead?
3. A group named "Filter By:" can be added, in which the following should be
put into this group: "Cell Color Is", "Top 10", and even "Empty" and "Not
Empty" in case you do want to keep them.

Anyway, filter by color is a very useful feature, no matter whether is is a
good way to do things in spreadsheet or not. Think of the situation that
someone send me a spreadsheet in which he has marked some cells in question
with color and I need to locate these cells quickly. He did this simply because
Excel (or even WPS) provided this feature and he is used to do things this
way...

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