Apache OpenOffice (AOO) Bugzilla – Issue 128278
sorting a calc table by a custom sort rule
Last modified: 2020-02-09 08:57:22 UTC
Created attachment 86819 [details] Sortierung Hallo, 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. Greetings Gabi
Created attachment 86820 [details] Sortieren_calc
Created attachment 86821 [details] Sortierung
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: http://www.openoffice.org/support/index.html
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: https://de.openoffice.info/viewtopic.php?f=2&t=74276 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)
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?
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.
Well, I ask a document because I don't know how can make this list in MS-Excel.
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.
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: https://www.youtube.com/watch?v=_IgPAHe0mN8 > 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). Note: 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.