Bug 95520 - Sort column by color (Extension?)
Summary: Sort column by color (Extension?)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Sorting
  Show dependency treegraph
Reported: 2015-11-02 12:11 UTC by Daniel Mustieles
Modified: 2020-08-21 18:09 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Daniel Mustieles 2015-11-02 12:11:33 UTC
Sorting columns by font/background color is quite useful several times, and having such sort criteria implemented would be great. There are some workarounds to get this, using functions, etc, but it's not easy-to-use, specially for newbies and non-technical users.

Google Drive has already added this same feature through a Chrome's plugin, and MS Office also has it, so LibreOffice should be aligned with them ;-)

Thanks in advance!
Comment 1 Daniel Mustieles 2015-11-02 12:14:38 UTC
Just a quick view about hot it works in Chrome

Comment 2 Cor Nouws 2015-11-02 18:52:08 UTC
Hi Daniel,

Nice idea. Let me set it to New.
I head in Google it's an addon. So something you / someone can make an extension for too?
Cheers - Cor
Comment 3 Daniel Mustieles 2015-11-03 10:01:59 UTC
Hi Cor,

I'm no t a developer, so cannot collaborate with code in this task, but maybe a workaround I used might help to implement it.

I had a spreadsheet with ~1000 rows, each of them highlighetd with a colour (4 colours used in total). I sorted  them in MS Excel by color and then, I added a new column to indicate the status, based in the color. Maybe having an internal code/number for each colour could help to implement the filter.

Thanks for all and best regards
Comment 4 William Gathoye 2019-05-22 12:49:58 UTC
Here is the code pointer given to me by Michael Meeks at the last FOSDEM hackfest.

sc/source/ui/dbgui/sortdlg.cxx:    : SfxTabDialogController(pParent,
"modules/scalc/ui/sortdialog.ui", "SortDialog", pArgSet)

sc/source/ui/dbgui/tpsort.cxx -> does the sort (?)

@@ -125,6 +128,7 @@ bool ScSortParam::operator==( const ScSortParam&
rOther ) const

Compare vs. this commit:

commit b5f8b046008a27f1da58b934dbe61c0decf36612
Author: Samuel Mehrbrodt <Samuel.Mehrbrodt@cib.de>
Date:   Mon Jan 22 17:47:04 2018 +0100

    tdf#98931 Add option to sort boundary image-only columns

    A similiar option exists for comments-only columns.
    If enabled, image-only columns are considered when sorting (and
Comment 5 William Gathoye 2019-05-22 12:50:54 UTC
I intend to work on this bug for the next Paris hackfest:
Comment 6 Xisco Faulí 2019-09-26 10:26:16 UTC
Dear William Gathoye,
This bug has been in ASSIGNED status for more than 3 months without any
activity. Resetting it to NEW.
Please assigned it back to yourself if you're still working on this.