Bug 159388 - Sorting function doesn't remember that a) first row contains description for columns and b) the previously used sorting priority
Summary: Sorting function doesn't remember that a) first row contains description for ...
Status: RESOLVED DUPLICATE of bug 108424
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.4.1 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-01-26 15:06 UTC by Mike
Modified: 2024-01-26 23:09 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
screenshot that CALC 'forgets' the last sorting settings (44.01 KB, image/jpeg)
2024-01-26 15:07 UTC, Mike
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Mike 2024-01-26 15:06:53 UTC
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
Comment 1 Mike 2024-01-26 15:07:56 UTC
Created attachment 192183 [details]
screenshot that CALC 'forgets' the last sorting settings
Comment 2 ady 2024-01-26 17:42:35 UTC
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>
Comment 3 m_a_riosv 2024-01-26 23:09:12 UTC
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 ***