[Solved] Filter Data By color

Discuss the spreadsheet application

[Solved] Filter Data By color

Postby PencilGal » Mon Mar 23, 2020 10:07 pm

Can anyone tell me if I can / how to filter by color?

I am using a .ods file which is an inventory. I have highlighted them as they sold. Now I would like to create a new file with only the unsold ones.
It seems easiest to do a search for the highlighted ones and delete them.

Thoughts?

Joyce
Last edited by PencilGal on Mon Mar 23, 2020 11:22 pm, edited 1 time in total.
Open Office 4.1.6 Windows 10
PencilGal
 
Posts: 19
Joined: Sun Jan 20, 2019 11:51 pm

Re: Filter Data By color

Postby Zizi64 » Mon Mar 23, 2020 10:14 pm

Do not use the graphical properties of the cells as some DATA. Those properties are not DATA. Use textual or numeric flags in an additional column/row.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9431
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Filter Data By color

Postby FJCC » Mon Mar 23, 2020 10:19 pm

I don't think there is any way to search for manually applied formatting. If you applied the color using a cell style, you could search for the style. The easiest approach is probably to use an adjacent column, inserting one if necessary, and mark rows with either the sold or unsold items, whichever is easier, with an x. You can then use the menu Data -> Filter to pick the the rows you want. Does that make sense?
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7680
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Filter Data By color

Postby PencilGal » Mon Mar 23, 2020 11:21 pm

Makes sense. Going forward, that's just what I will do. Thanks.
Open Office 4.1.6 Windows 10
PencilGal
 
Posts: 19
Joined: Sun Jan 20, 2019 11:51 pm

Re: [solved] Filter Data By color

Postby Villeroy » Tue Mar 24, 2020 10:23 am

You can filter by DATA and you can apply conditional formatting by DATA.
For instance, you can add an additional column where you enter some DATA. Conditional formatting is applied automatically according to the entered data and you can use the same data for filtering, sorting, calculations of all kinds.

See attachment
Attachments
CF_t101438.ods
(27.53 KiB) Downloaded 19 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28431
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 9 guests