As part of regular FDO cleanup we are checking the version of regressions to see if it's the oldest version that displays the incorrect behavior.
In this case I have been able to verify the bug existence in Version 3.6.0.0.beta1 (Build ID: 1f1cdd) Changing version to reflect this -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1082449 Title: [Upstream] Calc mis-sorts left to right (sort columns) Status in LibreOffice Productivity Suite: Fix Released Status in “libreoffice” package in Ubuntu: Fix Released 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~rc2-0ubuntu4 Candidate: 1:3.6.2~rc2-0ubuntu4 Version table: *** 1:3.6.2~rc2-0ubuntu4 0 900 http://archive.ubuntu.com/ubuntu/ quantal-updates/main i386 Packages 100 /var/lib/dpkg/status 1:3.6.2~rc2-0ubuntu3 0 500 http://archive.ubuntu.com/ubuntu/ quantal/main i386 Packages 3) What is expected to happen in Calc via a terminal: cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1082449/+attachment/3442313/+files/test.xls && localc --nologo test.xls 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://archive.ubuntu.com/ubuntu/ quantal/universe i386 Packages 100 /var/lib/dpkg/status 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://ppa.launchpad.net/ubuntu-wine/ppa/ubuntu/ quantal/main i386 Packages 100 /var/lib/dpkg/status ProblemType: Bug DistroRelease: Ubuntu 12.10 Package: libreoffice-calc 1:3.6.2~rc2-0ubuntu4 ProcVersionSignature: Ubuntu 3.5.0-19.30-generic 3.5.7 Uname: Linux 3.5.0-19-generic x86_64 NonfreeKernelModules: nvidia wl 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) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1082449/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
