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
[Solved] Filter Data By color
[Solved] Filter Data By color
Last edited by PencilGal on Mon Mar 23, 2020 11:22 pm, edited 1 time in total.
Open Office 4.1.6 Windows 10
Re: Filter Data By color
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; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
Re: Filter Data By color
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?
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Filter Data By color
Makes sense. Going forward, that's just what I will do. Thanks.
Open Office 4.1.6 Windows 10
Re: [solved] Filter Data By color
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
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 378 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice