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. ***
*** Bug 54246 has been marked as a duplicate of this bug. ***
*** Bug 128935 has been marked as a duplicate of this bug. ***
Changing enhancement priority to 'high' since the number of people in CC is higher than 20
I'm also interested to see this feature added to Libre Office Calc.
I am very interested too.
Use Case -
Highlighting duplicates using "Conditionals" and giving a background colour.
Now, want to sort/filter the column according to colour.
Se ocupa mucho con regularidad!
Hi MAU, please English. You can.
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.
Your paper is basically the finish of all that you've learned while you're at college. You've had a very long time to begin pondering your subject, and miracle about the holes that have shown up as you've examined. This is your opportunity to do some genuine research out in the field, and distribute a genuine, scholarly bit of work.
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.
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.
there is an attempt to do calculations depending on cell colors by using macro / user code in:
perhaps some of that is useful here?