Bug 76258 - Filter by Colours in LibreOffice Calc - Enchancement
Summary: Filter by Colours in LibreOffice Calc - Enchancement
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: high enhancement
Assignee: Not Assigned
: 43926 54246 87308 89582 89812 108046 125190 128935 (view as bug list)
Depends on:
Blocks: Data-Filter
  Show dependency treegraph
Reported: 2014-03-17 11:04 UTC by Gergely Rácz
Modified: 2020-09-04 16:58 UTC (History)
34 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Gergely Rácz 2014-03-17 11:04:41 UTC
Using colors as a definition of filtering makes more easier and usable the filter function in LibreOffice Calc. There are some workarounds but all of them are not user friendly.
Comment 1 A (Andy) 2014-03-22 09:42:29 UTC
seems to be interesting to filter by colors
Comment 2 Zeki Bildirici 2014-04-24 10:47:32 UTC

Filter by color function(in Excel)used by many users in our company. It is a very easy way to categorize various data and browse through.

Having this functionality will be very nice, also it is noted in Bruce Byfield's cons pros list: http://www.datamation.com/applications/how-microsoft-office-tops-libreoffice-11-features-2.html (Item 9).

Best regards,
Comment 3 raal 2014-12-14 21:22:33 UTC
*** Bug 87308 has been marked as a duplicate of this bug. ***
Comment 4 Zeki Bildirici 2015-01-01 13:36:14 UTC
*** Bug 43926 has been marked as a duplicate of this bug. ***
Comment 5 Zeki Bildirici 2015-01-01 13:42:54 UTC

I care about getting this fixed, so I'm offering USD 20.00 via FreedomSponsors to the the person who'll fix it.

Offer link: https://freedomsponsors.org/issue/607/filterenchancement-filter-by-colors-in-libo-calc 

You can also join me and throw in a few bucks there.

If you fix this issue please use that site to request your payment.

Best regards,
Comment 6 raal 2015-02-23 08:49:44 UTC
*** Bug 89582 has been marked as a duplicate of this bug. ***
Comment 7 raal 2015-03-04 11:25:58 UTC
*** Bug 89812 has been marked as a duplicate of this bug. ***
Comment 8 Walter Miller 2015-10-09 21:25:54 UTC
This is an important feature.

Now I know what you're thinking. You're a developer, sorting data by formatting just seems absurd.

But the answer to "Train has overturned, people are trapped" is not "Train is designed to be operated in an upright fashion".

Highlighting names by background color is a natural way for people to work. They frequently do it.  They will keep doing it until proper data filtering is taught in elementary school.
Comment 9 Anton Kumir 2016-07-10 16:15:27 UTC
This is the first obvious missing feature that i noticed when comparing with the MS Excel features.
I hope it will be implemented in the near future.
Plays nice with contional formatting.
Comment 10 Xisco Faulí 2017-05-24 08:33:23 UTC
*** Bug 108046 has been marked as a duplicate of this bug. ***
Comment 11 Ari Latvala 2017-09-13 06:27:35 UTC
Fortunately I had also MS Office available, just received Excel sheet, where conditional formatting was used heavily and without Excel's "Filter by color" feature finding those relevant cells would have been a real pain. So pls. add this neat feature also to LO Calc asap.
Comment 12 raal 2019-05-11 16:26:44 UTC
*** Bug 125190 has been marked as a duplicate of this bug. ***
Comment 13 Cor Nouws 2019-07-08 15:37:14 UTC
*** Bug 54246 has been marked as a duplicate of this bug. ***
Comment 14 Oliver Brinzing 2019-11-21 19:15:52 UTC
*** Bug 128935 has been marked as a duplicate of this bug. ***
Comment 15 Xisco Faulí 2019-12-02 12:54:59 UTC
Changing enhancement priority to 'high' since the number of people in CC is higher than 20
Comment 16 Jorge Astiazaran 2020-01-09 20:42:45 UTC Comment hidden (me-too)
Comment 17 prempa 2020-01-09 21:40:59 UTC Comment hidden (me-too)
Comment 18 swapnil.agrawal06 2020-01-20 12:33:16 UTC
Use Case -
Highlighting duplicates using "Conditionals" and giving a background colour.
Now, want to sort/filter the column according to colour.
Comment 19 Mauricio 2020-04-13 14:51:17 UTC
Se ocupa mucho con regularidad!
Comment 20 m.a.riosv 2020-04-13 16:44:06 UTC
Hi MAU, please English. You can.
Comment 21 Casey C 2020-04-18 03:53:27 UTC
Agreeing with that which others have posted, this is an important missing feature. The ability to sort and filter by color is a feature many casual users take advantage of in similar software, especially in conjunction with conditional formatting. This may be deemed absurd by advanced users and data scientists, but to a casual user it can help to visually organize the data and helps them manipulate data with greater ease. Is it so incredulous to cater to a novice user without bemoaning about how they're "doing it wrong"? In my opinion, the absurd thing is to lecture casual users about the follies of format-based filtering and sorting, as I've frequently seen users do in AskLibO. A user is not a developer. It isn't a bad thing to make software easier for them to use.
Comment 22 ThomasMore 2020-05-04 07:02:25 UTC Comment hidden (spam)
Comment 23 johnks 2020-06-28 14:39:35 UTC
i have a need for this feature in my work because the clients "think" in these terms. Besides, i don't see why anyone would say this is an unnecessary feature because clearly a lot of people are waiting to have LO implement this for over 6 years.
Comment 24 Eric 2020-07-29 18:01:59 UTC
I have a use case for sorting/filtering by text color. 
My large stock spreadsheet has text in a column formatted by color based on the result of  "last_price - cost_per_share"  where -
<0  is red text for a loss 
==0 black text for break even
>0  green text for a profit
As you can imagine, with a large number of rows filtering/sorting by text color (not background color) would be very useful and allows me to see at a glance those stocks which have been profitable.
Comment 25 b. 2020-09-04 16:58:43 UTC
there is an attempt to do calculations depending on cell colors by using macro / user code in: 


perhaps some of that is useful here?