Bug 129477 - left to right (sort columns) results in incorrect order
Summary: left to right (sort columns) results in incorrect order
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 129483 (view as bug list)
Depends on:
Blocks: Sorting
  Show dependency treegraph
 
Reported: 2019-12-18 16:03 UTC by Terrence Enger
Modified: 2021-06-20 17:53 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
sample spreadsheet (6.50 KB, application/vnd.ms-excel)
2019-12-18 16:03 UTC, Terrence Enger
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Terrence Enger 2019-12-18 16:03:14 UTC
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.
Comment 1 Terrence Enger 2019-12-18 16:53:05 UTC
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.
Comment 2 m_a_riosv 2019-12-19 10:27:35 UTC
*** Bug 129483 has been marked as a duplicate of this bug. ***
Comment 3 Xisco Faulí 2019-12-19 11:47:54 UTC
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
Comment 4 Oliver Brinzing 2019-12-19 15:40:07 UTC
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 ...
Comment 5 BogdanB 2020-09-28 06:22:43 UTC
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
Comment 6 Stéphane Guillou (stragu) 2021-06-14 14:18:18 UTC
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.
Comment 7 Terrence Enger 2021-06-20 17:53:19 UTC
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.