Issue 128278

Summary: sorting a calc table by a custom sort rule
Product: Calc Reporter: Gabi <zalfa>
Component: programmingAssignee: AOO issues mailing list <issues>
Status: REOPENED --- QA Contact:
Severity: Normal    
Priority: P5 (lowest) CC: joesch04, oooforum, petko
Version: 4.1.7Keywords: performance
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
example and mockup for the sort process none

Description Gabi 2020-02-05 17:03:30 UTC
Created attachment 86819 [details]

I wish with the assortment of a table a user-defined method, e.g., assortment after written colours, very simply like in office Excel MS.
Comment 1 Gabi 2020-02-05 17:23:14 UTC
Created attachment 86820 [details]
Comment 2 Gabi 2020-02-05 17:29:35 UTC
Created attachment 86821 [details]
Comment 3 oooforum (fr) 2020-02-06 09:28:10 UTC
Remember that we don't have MS-Excel and a screenshot is not enough to reproduce.

You are in wrong place here. This is not a help-desk tool.
If you have some difficulties to use OpenOffice, you must jump our forum or
mailing list dedicated for end-users:
Comment 4 Peter 2020-02-06 15:16:37 UTC
Actually she wants to have a way for custom sorting.

In a config she declares a Row, a Property (example color), sets up the order for existing colors, and the Table gets sorted in this criteria.

Related Forum discussion:

I did not find a similar Bug, so I reopening.
Maybe this is better solved as extension. (I am not sure maybe there has been done something in the forum. I mean at least base work)
Comment 5 oooforum (fr) 2020-02-06 16:19:09 UTC
I don't speak german but I don't see any XLS or XLSX document to understand this feature. 
The OP could provide an example?
Comment 6 Peter 2020-02-06 16:43:22 UTC
Created attachment 86822 [details]
example and mockup for the sort process

I am not sure if we get an answer.

From my understanding gained from the german discussion I have created a document that has an example for 
1) original order on the first sheet
2) expected result after the "sort tool" has been used
3) and a mockup on the dialog that I mimicked from the screenshots.
Comment 7 oooforum (fr) 2020-02-07 09:03:43 UTC
Well, I ask a document because I don't know how can make this list in MS-Excel.
Comment 8 Peter 2020-02-07 12:51:19 UTC
Well we should not depend on external description for requirement. That is why I have uploaded the doc. Please if you need more info then ask away. I can check the Forum thread too if needed for clues.
We can also enhance based on the input.
Comment 9 joesch 2020-02-09 08:57:22 UTC
Sorting by color is a normal function in Excel and I also find it useful to refer to Excel because there you can see the function ready.

For example here is a video:

> description for requirement

in AOO it is possible to sort (and filter) by values and text. In some cases sorting lists can be used.

Now a function is desired with which it is possible to sort (and filter) in Calc by colors.
Because colors have no fixed order it will be necessary to use (temporary) sort lists when implementing such a function.

(By a temporary sort list I do not understand anything else than a GUI where the user can specify the desired order for the colors which are used for sorting).

the issue does _not_ ask for the Filter by color function, but this is a function very similar to the Sort by color function, which is why I mentioned it.