Description: Data list of over 15,000 rows, 3 columns, each with labels; Title, Artist, Folder. In alphabetic tabs. I often add data and when I wish to sort it, the options aren't saved. Example: I put a tick on Range contains column labels, but it doesn't stay ticked when I go back to it, neither do my sort keys get saved. It's a real hassle to have to re-enter it every time. Actual Results: Select range, click Data, sort. sort key 1 always defaults to Column A despite changes made prior. Expected Results: Have to re-enter my keys, but must re-tick the box in options first. Reproducible: Always User Profile Reset: No Additional Info: Save my options until I change them.
Which file format do you save to (ODF format .ods or something else)? Please provide also info from Help -> About LibreOffice
I use ODF format. *.ods. I tried saving it as Ms Excel *.xls, but it made no difference. (Didn't think it would) Version: 7.1.4.2 (x64) / LibreOffice Community Build ID: a529a4fab45b75fefc5b6226684193eb000654f6 CPU threads: 6; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: en-CA (en_CA); UI: en-US Calc: CL
To have it preserved, you need to have defined a Menu/Data/Define range.
Thanks, that worked. It took me a while to define all the ranges but now, all I need to do is click Sort. No issues anymore.