Launchpad has imported 8 comments from the remote bug at https://www.libreoffice.org/bugzilla/show_bug.cgi?id=57465.
If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. ------------------------------------------------------------------------ On 2012-11-23T21:34:54+00:00 Wolf Rogner wrote: Created attachment 70488 Testfile to demonstrate behaviour Problem description: Calc sorts columns the wrong way Steps to reproduce: There is an error in sorting columns in calc. How to test: Create a spread sheet similar to this C A D B F E R1 a d R2 b e R3 c f Mark the columns labled C, A...E Sort the columns ascending Expected behavior: A B C D E F R1 a d R2 b e R3 c f Current behavior: C A D B F E R1 c f R2 a d R3 b e Platform (if different from the browser): Macbook Pro 6,2, Ubuntu 12.10 Browser: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:17.0) Gecko/17.0 Firefox/17.0 Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1082449/comments/7 ------------------------------------------------------------------------ On 2012-11-23T21:51:01+00:00 Wolf Rogner wrote: This does not happen in Calc 3.5.4.2 Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1082449/comments/10 ------------------------------------------------------------------------ On 2012-11-23T22:00:05+00:00 Davian818 wrote: Confirmed in 4.0-master, though the result is ADCBFE. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1082449/comments/11 ------------------------------------------------------------------------ On 2012-11-23T22:22:01+00:00 Markus Mohrhard wrote: Can you please test with 3.6.4.1 or 3.6.4.2 because they should be fixed there. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1082449/comments/12 ------------------------------------------------------------------------ On 2012-11-24T14:50:23+00:00 Wolf Rogner wrote: @Markus Mohrhard: I'd love to whenever the update is downstreamed into Ubuntu repositories. Q: How can such a regression happen? Any ideas or explanations? Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1082449/comments/13 ------------------------------------------------------------------------ On 2012-11-24T17:14:16+00:00 Markus Mohrhard wrote: (In reply to comment #4) > @Markus Mohrhard: > I'd love to whenever the update is downstreamed into Ubuntu repositories. > > Q: How can such a regression happen? Any ideas or explanations? Calc has about 1 million lines of own source code + several more million lines of shared source code. And how much time did you spend yourself testing master to check for regressions. Marking as fixed as I think it is fixed in 3.6.4.1 and therefore in the 3.6.4 release. Reopen if it is not fixed there. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1082449/comments/15 ------------------------------------------------------------------------ On 2012-11-24T18:29:53+00:00 Christopher M. Penalver wrote: Reproducible in: Microsoft Windows Vista Business x86 6.0.6002 Service Pack 2 Build 6002 Version 3.6.4.1 (Build ID: a9a0717) Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1082449/comments/17 ------------------------------------------------------------------------ On 2012-11-25T17:50:29+00:00 Wolf Rogner wrote: (In reply to comment #5) > (In reply to comment #4) > > @Markus Mohrhard: > > I'd love to whenever the update is downstreamed into Ubuntu repositories. > > > > Q: How can such a regression happen? Any ideas or explanations? > > Calc has about 1 million lines of own source code + several more million > lines of shared source code. And how much time did you spend yourself > testing master to check for regressions. > > Marking as fixed as I think it is fixed in 3.6.4.1 and therefore in the > 3.6.4 release. Reopen if it is not fixed there. First I am pretty sure that not all of the 1 million lines deal with sorting. Second, in my development projects we used test suites to prevent from regression and third there are statistical methods to identify areas of unstable code based on previous bug reports. Assuming that all this is in place here as well, I was wondering what could be the cause of those regressions. If you had an idea I could direct some research effort into how this can be improved. Maybe we can discuss this on a different channel (mail?) Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1082449/comments/18 ** Changed in: df-libreoffice Status: Unknown => Confirmed ** Changed in: df-libreoffice Importance: Unknown => Medium -- 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: Confirmed 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