Created attachment 114417 [details] Sample file for test For Defined Data Ranges, options for Filter are preserved, but not some Sort options. Preserved Option Yes Case sensitive. No Range contains row labels. Yes Include formats. No Enable natural sort. Yes Copy sort results to. No Custom sort order. Yes Language. Yes Top to bottom/Left to right. Doing directly a manual sort with the buttons for Sort inside a defined range, CLEAR the options. Selecting data range again doesn't restore the options. I'm not sure if it's really a bug, but it's really annoying. What test: Go e.g. to A2 change any option with 'No' for preserved for an option listed above, save and reopen the file, option is restored to default value.
I can confirm with Version: 4.5.0.0.alpha0+ Build ID: 28c61871e876e6a2cac47439f768504b1a4c94a0 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-03-27_06:30:21
*** Bug 119310 has been marked as a duplicate of this bug. ***
Actually, when you define a range, and then reuse that range to sort, only 3 criteria are saved for sorting, not all. Maybe an increase to 6 instead of 3 would be enough for many. See bug https://bugs.documentfoundation.org/show_bug.cgi?id=119310 for details. (it is mentioned above as a duplicate of this bug).
Yes, increasing saved sort criteria to 6 would be very helpful, thanks. Version: 6.1.4.2 (x64) on Windows still only saving 3...
Number of sorting options were fixed in bug 105301.
Andreas, can you test if this bug was also solved by this commit? https://bugs.documentfoundation.org/show_bug.cgi?id=135242 Looks similar
When I take to document from duplicate bug 119310 and add Sort Key 4 and Sort Key 5, then all five sort keys are stored in the file and on reopening all five Sort Key items are correctly set in the dialog. Tested with Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: d60ff8c8bd4e3ebf8f84f53448ead3c838332ea9 CPU threads: 32; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: de-DE (de_DE); UI: en-US Calc: threaded
(In reply to Regina Henschel from comment #7) > When I take to document from duplicate bug 119310 and add Sort Key 4 and > Sort Key 5, then all five sort keys are stored in the file and on reopening > all five Sort Key items are correctly set in the dialog. > > Tested with Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community > Build ID: d60ff8c8bd4e3ebf8f84f53448ead3c838332ea9 > CPU threads: 32; OS: Windows 11 X86_64 (build 26100); UI render: > Skia/Vulkan; VCL: win > Locale: de-DE (de_DE); UI: en-US > Calc: threaded Thanks, Regina, I tested now, it is working well.