Libreoffice calc 4.2.7-0ubuntu1 not updating references after sort
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
LibreOffice |
Fix Released
|
Critical
|
|||
libreoffice (Ubuntu) |
Fix Released
|
High
|
Björn Michaelsen | ||
Trusty |
Fix Released
|
High
|
Unassigned |
Bug Description
Update to LibreOffice 4.2.7 is causing incorrect sort behaviour in Calc.
As initially reported here:
http://
Attached is sample Calc document. To reproduce, highlight B6 to E14, select Sort and sort by Column D, see that column E didn't get sorted.
ProblemType: Bug
DistroRelease: Ubuntu 14.10
Package: libreoffice (not installed)
ProcVersionSign
Uname: Linux 3.16.0-24-generic x86_64
ApportVersion: 2.14.7-0ubuntu8
Architecture: amd64
CurrentDesktop: Unity
Date: Wed Nov 5 15:49:03 2014
InstallationDate: Installed on 2013-11-26 (344 days ago)
InstallationMedia: Ubuntu 13.10 "Saucy Salamander" - Release amd64 (20131016.1)
SourcePackage: libreoffice
UpgradeStatus: Upgraded to utopic on 2014-10-08 (27 days ago)
Changed in libreoffice (Ubuntu): | |
assignee: | nobody → Björn Michaelsen (bjoern-michaelsen) |
importance: | Undecided → High |
tags: | added: regresion-update |
Changed in libreoffice (Ubuntu): | |
status: | Confirmed → Triaged |
tags: |
added: trusty removed: utopic |
tags: | removed: regresion-update |
summary: |
- Libreoffice calc 4.2.7 not sorting right + Libreoffice calc 4.2.7 not updating references after sort |
summary: |
- Libreoffice calc 4.2.7 not updating references after sort + Libreoffice calc 4.2.7-0ubuntu1 not updating references after sort |
Changed in libreoffice (Ubuntu Trusty): | |
status: | New → Fix Committed |
tags: | added: verification-needed |
tags: |
added: verification-done removed: verification-needed |
Changed in libreoffice (Ubuntu Trusty): | |
status: | Fix Committed → Fix Released |
Changed in libreoffice (Ubuntu): | |
status: | Triaged → Fix Released |
Changed in df-libreoffice: | |
importance: | Unknown → Critical |
status: | Unknown → Fix Released |
Changed in libreoffice (Ubuntu Trusty): | |
importance: | Undecided → High |
Currently the configuration option in master (I guess it is menu Tools > Options > LibreOffice Calc > Update reference when sorting range of cells) does not solve the problem.
If you try to sort the test file (attachment 104016) whatever the choice you do (check or uncheck this option) the result is false:
1/ option checked: result false in column D and correct in column E
2/ option uncheck: error 523 (Calculation does not converge) in row 3 to 6 in both columns D and E.
NB1: a quick way to verify if the sort is correct is to check the last value in columns D and C; it must be 784.79 whatever is the order of the rows.
NB2: to sort the data I do that: click in A2 then select rows 2 to 14 (maintain Shift key and click on the row headers 2 and 14).
Best regards. JBF