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!
Just a quick view about hot it works in Chrome
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
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
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:
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
I intend to work on this bug for the next Paris hackfest:
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.