Bug 144992

Summary: CALC Sort doesn't present "options" dialogue when it automatically selects surrounding data
Product: LibreOffice Reporter: Colin <that.man.colin>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal CC: raal
Priority: medium    
Version: 7.2.1.2 release   
Hardware: All   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Screen Dump and micro sheet

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