Description: Sorting function doesn't remember a) that first row contains description for columns and b) doesn't remember the previously used sorting priority --> Therefore one unneccessarily has to reselect the check box and sorting priority repeatedly. Steps to Reproduce: 1. Create a table 2. Enter column headers into first row 3. Enter data into followin cells 4. Select whole table / area to be sorted 5. Check box "header row, area contains column description" 6. Define sorting priority by selecting the respective column(s) 7. Click "OK" to sort 8. repeat step 4. 9. Instead of just clicking "OK" to sort by the same parameters one has to repeat steps 5 to 7 every time :-( Actual Results: see attached screenshot Expected Results: Should work like in Excel and remember that there's a descriptive row above the data to be sorted - ideally even after closing and reopening the file. Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: de Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no Version: 7.6.4.1 (X86_64) / LibreOffice Community Build ID: e19e193f88cd6c0525a17fb7a176ed8e6a3e2aa1 CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: CL threaded
Created attachment 192183 [details] screenshot that CALC 'forgets' the last sorting settings
Please attach a sample document, as this makes it easier for us to verify the bug. Please note that the attachment will be public; remove any sensitive information before attaching it. See <https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F>
You need to create a range Menu/Data/Define range, to keep the options for that range. https://help.libreoffice.org/latest/en-US/text/scalc/guide/database_define.html?&DbPAR=CALC&System=WIN *** This bug has been marked as a duplicate of bug 108424 ***