Bug 144992 - CALC Sort doesn't present "options" dialogue when it automatically selects surrounding data
Summary: CALC Sort doesn't present "options" dialogue when it automatically selects su...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.1.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-10-08 07:42 UTC by Colin
Modified: 2022-02-23 19:47 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Screen Dump and micro sheet (111.88 KB, application/x-zip-compressed)
2021-10-08 07:43 UTC, Colin 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Colin 2021-10-08 07:42:48 UTC 
Description:
If data in the middle column of three columns is selected and the "sort" button on the toolbar is activated then it automatically extends the selection to the surrounding columns. However, if the "current selection" button is chosen in the "sort range" popup it automatically assumes ascending is required and executes an ascending sort. There is no further interaction permitting the selection of a custom sort list or simply descending sort order.

Steps to Reproduce:
See attached image and .ods
Select the "full on" toolbar sort button NOT A-Z or Z-A
Define the "current selection"
Now try to tell it descending or custom sort list
If I wanted to go to heaven (or the other place), there are two perfectly functional specific sort buttons

Actual Results:
Ascending order sort on the chosen column

Expected Results:
Ability to define a sort order or custom sort list


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Version: 7.2.1.2 (x64) / LibreOffice Community
Build ID: 87b77fad49947c1441b67c559c339af8f3517e22
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded
Comment 1 Colin 2021-10-08 07:43:35 UTC 
Created attachment 175590 [details]
Screen Dump and micro sheet
Comment 2 Colin 2021-10-08 07:47:42 UTC 
For the avoidance of doubt, the inference is that I don't want to impact the surrounding data by the sort of the selected data column
Comment 3 raal 2022-02-23 17:10:51 UTC 
No repro with Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: 0723b41bed9bb4ad50d2993744a60177966d1a21
CPU threads: 4; OS: Linux 5.13; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded Jumbo

and Version: 7.2.5.2 / LibreOffice Community
Build ID: 20(Build:2)
CPU threads: 4; OS: Linux 5.13; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: cs-CZ
Ubuntu package version: 1:7.2.5-0ubuntu0.21.10.1
Calc: threaded

Please can you retest with newer version?
Comment 4 Colin 2022-02-23 19:47:00 UTC 
(In reply to raal from comment #3)

> 
> Please can you retest with newer version?

I confirm now functioning correctly on

Version: 7.2.5.2 (x64) / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded