Bug 90296 - SORT Menu/Data/Sort: Preserving the last options or for defined range of data.
Summary: SORT Menu/Data/Sort: Preserving the last options or for defined range of data.
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: Other Windows (All)
: medium enhancement
Assignee: Not Assigned
: 119310 (view as bug list)
Depends on:
Blocks: Sorting
  Show dependency treegraph
Reported: 2015-03-28 13:21 UTC by m_a_riosv
Modified: 2021-02-13 07:53 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Sample file for test (10.21 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2015-03-28 13:21 UTC, m_a_riosv

Note You need to log in before you can comment on or make changes to this bug.
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:
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: (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?

Looks similar