[Upstream] Calc mis-sorts left to right (sort columns)
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
LibreOffice |
Fix Released
|
Medium
|
|||
libreoffice (Ubuntu) |
Fix Released
|
Medium
|
Unassigned |
Bug Description
1) lsb_release -rd
Description: Ubuntu 12.10
Release: 12.10
2) apt-cache policy libreoffice-calc
libreoffice-calc:
Installed: 1:3.6.2~
Candidate: 1:3.6.2~
Version table:
*** 1:3.6.2~
900 http://
100 /var/lib/
1:
500 http://
3) What is expected to happen in Calc via a terminal:
cd ~/Desktop && wget https:/
highlight columns B through G -> Data -> Sort... -> Options tab under Direction click radio button Let to right (sort columns) -> uncheck checkbox Range contains row labels -> tab Sort Criteria -> drop down Sort key 1 click Row 1 -> radio buton Ascending -> button OK and the order is sorted as noted in the file Expected.
4) What happens instead is it sorts as noted in the file Result.
+ Same problem reproducible in:
Microsoft Windows Vista Business x86
6.0.6002 Service Pack 2 Build 6002
Version 3.6.3.2 (Build ID: 58f22d5)
but issue has WORKAROUND if you run sort twice consecutively.
WORKAROUND: Use Gnumeric.
apt-cache policy gnumeric
gnumeric:
Installed: 1.10.17-1.1ubuntu1
Candidate: 1.10.17-1.1ubuntu1
Version table:
*** 1.10.17-1.1ubuntu1 0
500 http://
100 /var/lib/
WORKAROUND: Use Excel via WINE.
Microsoft Office Professional Plus 2010 Excel Version 14.0.6023.1000 (32-bit)
apt-cache policy wine1.5
wine1.5:
Installed: 1.5.17-0ubuntu4
Candidate: 1.5.17-0ubuntu4
Version table:
*** 1.5.17-0ubuntu4 0
500 http://
100 /var/lib/
ProblemType: Bug
DistroRelease: Ubuntu 12.10
Package: libreoffice-calc 1:3.6.2~
ProcVersionSign
Uname: Linux 3.5.0-19-generic x86_64
NonfreeKernelMo
ApportVersion: 2.6.1-0ubuntu6
Architecture: amd64
Date: Fri Nov 23 17:47:55 2012
InstallationDate: Installed on 2011-10-16 (404 days ago)
InstallationMedia: Ubuntu 11.10 "Oneiric Ocelot" - Release amd64+mac (20111012)
MarkForUpload: True
SourcePackage: libreoffice
UpgradeStatus: Upgraded to quantal on 2012-10-19 (34 days ago)
tags: | added: i386 |
description: | updated |
description: | updated |
description: | updated |
summary: |
- Error sorting columns in calc + Calc mis-sorts left to right (sort columns) |
tags: | added: regression-release |
Changed in df-libreoffice: | |
importance: | Unknown → Medium |
status: | Unknown → Confirmed |
Changed in df-libreoffice: | |
status: | Confirmed → Fix Released |
Sorry, the report lost its formating but the testfile includes all expected and real results.