Description: I often use quite complex sorts (I'll add a screenshot) for Calc tables with lots of fields. It would be really nice to have an option to save/load complex sort configurations; I understand that it is probably doable with macros, but a straightforward save/load would be a nice addition. Steps to Reproduce: 1.Have a very complex table 2.sort with 4 or more criteria (say, Column 1 ascending then column 3 descending then ... etcetera) 3.Modify the data 4.If you want to repeat the last complex sort, you have to do it all again. Actual Results: The "sort" dialog has no memory --- you have to start it all again Expected Results: Having a save/restore button/field in the sort dialog (the ideal thing would be to have the possibility to have several naming sort schemes) would be a big plus in handling. Reproducible: Always User Profile Reset: Yes Additional Info: Version: 24.8.0.3 (X86_64) / LibreOffice Community Build ID: 480(Build:3) CPU threads: 24; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-GB Ubuntu package version: 4:24.8.0~rc3-0ubuntu0.24.04.1~lo2 Calc: threaded
Created attachment 196284 [details] Example of a (mildly) complex sort dialog.
If you define a range for the table with Menu/Data/Define Range, the options for sort or filter are saved with the file.
Thank you! Yes, that's a good thing to know. But what about if I have 3 or 4 different complex filters? My proposal is to have a kind of menu to save them and rapidly re-load them. For example, my table is a course table with teachers assigned and semesters and degrees. I often switch from a semester - course - degree - professor order to a professor - semester - course order, for example. I'd like to have the possibility to save *several* different sort strategies for the same table.