** Tags added: i386 ** Description changed:
- There is an error in sorting columns in calc. + 1) lsb_release -rd + Description: Ubuntu 12.10 + Release: 12.10 - How to test: - Create a spread sheet similar to this + 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 - C A D B F E - R1 a d - R2 b e - R3 c f + 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 - Mark the columns labled C, A...E - Sort the columns ascending - You expect + 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 Expected, noted in the file: + A B C D E F + a d + b e + c f - A B C D E F - R1 a d - R2 b e - R3 c f + 4) What happens instead is it sorts as Result, noted in the file: + C A D B F E + c f + a d + b e - but you get + WORKAROUND: Use Gnumeric. - C A D B F E - R1 c f - R2 a d - R3 b e + 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 - very strange + WORKAROUND: Use Word via WINE. + Microsoft Office Professional Plus 2010 Word Version 14.0.6023.1000 (32-bit) - Testfile included + 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) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1082449 Title: Error sorting columns in calc To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1082449/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs