Bug 76258 - [Filter][Enchancement] Filter by colors in LibO Calc
Summary: [Filter][Enchancement] Filter by colors in LibO Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
: 43926 87308 89582 89812 108046 125190 (view as bug list)
Depends on:
Blocks: Data-Filter
  Show dependency treegraph
Reported: 2014-03-17 11:04 UTC by Gergely Rácz
Modified: 2019-06-07 03:37 UTC (History)
22 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. ***