Created attachment 156650 [details] sample spreadsheet STR (1) Download and open attached ex03.xls. (2) Select from A1 to E11. (3) Menu options Data > Sort (4) Click tab Options. (5) Click radio button "Left to right (sort columns)". (6) Click <OK>. (7) Observe row 11: observed : was A was B was C was E was D expected : was B was A was C was E was D I observed this in a local build of commit 491e8f6f, built and running on debian-buster. ex03.xls is a minor extension of example.xls attached to bug 129127.
I observe that bibisect-linus-64-releases version oldest returns wrong order: was A was C was D was E was B I am setting version Inherited From OOo.
*** Bug 129483 has been marked as a duplicate of this bug. ***
in Version: 6.5.0.0.alpha0+ Build ID: 02b24d77476f93887691dde564351d6f8b770b8f CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US Calc: threaded I get this order: was A was C was D was E was B
with: Version: 6.5.0.0.alpha0+ (x64) Build ID: 4b7b6993134a48c850608c758f7b7283bed27fec CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win; Locale: de-DE (de_DE); UI-Language: en-US Calc: threaded i get: was A was B was C was E was D and version LO 6.4 and before *crashes* LO ...
was A was B was C was E was D Wrong result in version: 7.1.0.0.alpha0+ Build ID: 4a899a5f8a72ea29a6919316afe3627de9f33e95 CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
WORKSFORME in: Version: 7.2.0.0.alpha1+ / LibreOffice Community Build ID: bb54d6d8241a06a6772052b77b67d6a4f686426c CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-06-11_20:14:38 Calc: threaded Version: 7.1.3.2 / LibreOffice Community Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1 CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Version: 7.0.6.2 Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Are you sure you have turned off the option "Range contains row labels"? Otherwise, the first column won't move given that it's considered to be row labels.
I see no problem in either a local build of commit d95e400b (2021-06-18) built and running on debian-buster or bibisect-linux-64-releases version oldest *when I turn off row labels*. Thank you for catching that, stragu. I apologize for the nuisance. I am setting status RESOLVED INVALID.