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.
seems to be interesting to filter by colors
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).
*** Bug 87308 has been marked as a duplicate of this bug. ***
*** Bug 43926 has been marked as a duplicate of this bug. ***
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.
*** Bug 89582 has been marked as a duplicate of this bug. ***
*** Bug 89812 has been marked as a duplicate of this bug. ***
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.
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.
*** Bug 108046 has been marked as a duplicate of this bug. ***
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.
*** Bug 125190 has been marked as a duplicate of this bug. ***