Sorting by colour

Discuss the spreadsheet application

Sorting by colour

Postby Martin S » Fri Jul 13, 2018 5:28 pm

My spreadsheet has date columns, some with a colour (representing a specific day of the week). The columns contain scores as numbers.

The rows are individual players.

I want to sort the scores into descending order but I want it to also sort the colour so that i can see what day the score was made.

Is there a way to do this or a suggestion as to another (simple) way I can achieve the same result??


Open Office 4.1.3 Windows 10
Martin S
Posts: 1
Joined: Fri Jul 13, 2018 5:17 pm

Re: Sorting by colour

Postby Zizi64 » Fri Jul 13, 2018 6:24 pm

The sort function works with real data only. The formatting properties are not real data in the cells.

Use a helper column for marking the "color values" (and use the Conditional Format feature for automatic coloring the cells based on the value of the helper cells). Than you will able sort the data based on the values of the helper cells, and the formatting properties will "move" together with the sorted helper values.

You need use the Cell styles for the Conditional Formatting feature - instead of the manual (direct) formatting properties.
Tibor Kovacs, Hungary; LO4.4.7, LO5.4.7 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.0.5 and AOO4.1.5
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
Posts: 6886
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Sorting by colour

Postby Villeroy » Fri Jul 13, 2018 6:47 pm

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Posts: 25451
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Return to Calc

Who is online

Users browsing this forum: Villeroy and 43 guests