Wolf Rogner, thank you for reporting this upstream, and your comments. Regarding your comments https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1082449/comments/8 : >"as for the suggested workaround: double sort This does not work under Ubuntu >12.10 / LibreOffice 3.6.2.2 sorry"
I also tried the Windows/3.6.3.2 work around in Ubuntu before editing the Bug Description, and noticed it did not work. This is why I did not create a third, separate "WORKAROUND:..." entry in the Bug Description. >"Excel is not a valid workaround as the purpose of using open solutions is to NOT use proprietary systems." For the purposes of satisfying the work around criteria noted at https://wiki.ubuntu.com/Bugs/Importance : "Bugs that have easy work-arounds" it is clear Excel would not be considered this, due to Excel not being provided by Ubuntu. This is why I marked this report Medium, instead of Low. The WORKAROUNDs in the Bug Description provide informational options one may potentially use while remaining booted in Ubuntu, irrespective of software license or cost. As well, noting this information provides ammo for getting this addressed sooner, as LibreOffice intends compatibility with Office. This would fit the criteria of expectation compatibility. "Gnumeric might me a workaround for some (but not for me)." Ok. Given Gnumeric is FOSS, providing this potentially gives developers code to base a patch off of, and as you noted, a work around for others until the patch lands in Ubuntu. Thank you for your understanding. ** Also affects: df-libreoffice via https://www.libreoffice.org/bugzilla/show_bug.cgi?id=57465 Importance: Unknown Status: Unknown ** Summary changed: - Calc mis-sorts left to right (sort columns) + [Upstream] Calc mis-sorts left to right (sort columns) -- 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: Unknown Status in “libreoffice” package in Ubuntu: Triaged 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
