Bug 90296

Summary: SORT Menu/Data/Sort: Preserving the last options or for defined range of data.
Product: LibreOffice Reporter: m_a_riosv <miguelangelrv>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: adrienne.strandberg, andreas.heinisch, buzea.bogdan, raal
Priority: medium    
Version: Inherited From OOo   
Hardware: Other   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108386    
Attachments: Sample file for test

Description m_a_riosv 2015-03-28 13:21:22 UTC
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.
Comment 1 raal 2015-03-28 20:50:13 UTC
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
Comment 2 Roman Kuznetsov 2018-08-19 12:19:37 UTC
*** Bug 119310 has been marked as a duplicate of this bug. ***
Comment 3 BogdanB 2018-09-14 16:35:14 UTC
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).
Comment 4 AdrienneS 2019-01-23 19:28:26 UTC
Yes, increasing saved sort criteria to 6 would be very helpful, thanks. Version: 6.1.4.2 (x64) on Windows still only saving 3...
Comment 5 Andreas Heinisch 2021-02-12 21:40:46 UTC
Number of sorting options were fixed in bug 105301.
Comment 6 BogdanB 2021-02-13 07:53:21 UTC
Andreas, can you test if this bug was also solved by this commit?
https://bugs.documentfoundation.org/show_bug.cgi?id=135242

Looks similar