** Description changed: 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 + 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 Expected, noted in the file: - A B C D E F - a d - b e - c f + A B C D E F + a d + b e + 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 + C A D B F E + c f + a d + b e 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 + 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 Word via WINE. Microsoft Office Professional Plus 2010 Word 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 + 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)
** Description changed: 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 Expected, noted in the file: - A B C D E F - a d - b e - c f + 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 Result, noted in the file: - C A D B F E - c f - a d - b e + 4) What happens instead is it sorts as noted in the file Result. 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 Word via WINE. Microsoft Office Professional Plus 2010 Word 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) ** Summary changed: - Error sorting columns in calc + 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: Calc mis-sorts left to right (sort columns) Status in “libreoffice” package in Ubuntu: New 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. 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 Word via WINE. Microsoft Office Professional Plus 2010 Word 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/ubuntu/+source/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