1/ LibreOffice did not update references correctly and consistently on sort before 4.2.x/trusty in general before 4.2.7 2/ There are sets of users that want references to be updated by a sort. There is an equal set of users who want references to _not_ be updated by a sort. 3/ _Not_ updating references after a sort considered closest to the previous LibreOffice 4.2.x/trusty behaviour
As such the current package in by default does _not_ update references after a sort, but offers a "UpdateReferenceOnSort"[1] option, which is disabled by default (which is what most other vendors, e.g. Collabora do to). Note that enabling "UpdateReferenceOnSort" by default would cause just as many users complain about the behaviour (see bugs below) and claim it to be a regression, because they expect the references _not_ to be updated. The current behaviour in 4.2.7-0ubuntu1 is _not_ a regression as -- as noted above -- LibreOffice 4.2.x/trusty did not update references consistently anyway, despite examples existing were it did. So 4.2.7-0ubuntu1 behaves as close as possible to the 4.2.x/trusty series, but offers the option to update references too (but its not the default, because that would be a different behaviour from the one in previous 4.2.x/trusty). This has been extensively discussed upstream: https://bugs.freedesktop.org/show_bug.cgi?id=85215 https://bugs.freedesktop.org/show_bug.cgi?id=81633 https://bugs.freedesktop.org/show_bug.cgi?id=85490 https://bugs.freedesktop.org/show_bug.cgi?id=85584 http://nabble.documentfoundation.org/minutes-of-ESC-call-tt4125271.html (section "Calc sorting issue") also note the number of reviewers/testers on the related patches: https://gerrit.libreoffice.org/gitweb?p=core.git;a=commit;h=f4c179ea7f69e87e55a416c1588ee0aad7c146c0 https://gerrit.libreoffice.org/gitweb?p=core.git;a=commit;h=67f3ce3a9df2bc62db5602dd84975047c1137b92 [1] https://gerrit.libreoffice.org/gitweb?p=core.git;a=blobdiff;f=officecfg/registry/schema/org/openoffice/Office/Calc.xcs;h=54e15fc87bc9d090b2353544d2a5769763323764;hp=0cdb9d51cd1e916d3b426e3083dd141b6f5baaf4;hb=67f3ce3a9df2bc62db5602dd84975047c1137b92;hpb=970f4c775b47d09d26469f6cd304a19ad44731f7 ** Bug watch added: freedesktop.org Bugzilla #85215 https://bugs.freedesktop.org/show_bug.cgi?id=85215 ** Bug watch added: freedesktop.org Bugzilla #85490 https://bugs.freedesktop.org/show_bug.cgi?id=85490 ** Bug watch added: freedesktop.org Bugzilla #81309 https://bugs.freedesktop.org/show_bug.cgi?id=81309 -- 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/1389858 Title: Libreoffice calc 4.2.7 not sorting right Status in “libreoffice” package in Ubuntu: Triaged Bug description: Update to LibreOffice 4.2.7 is causing incorrect sort behaviour in Calc. As initially reported here: http://www.reddit.com/r/Ubuntu/comments/2le7qu/libreoffice_calc_update_a_few_hours_ago_is_buggy/ Attached is sample Calc document. To reproduce, highlight B6 to E14, select Sort and sort by Column D, see that column E didn't get sorted. ProblemType: Bug DistroRelease: Ubuntu 14.10 Package: libreoffice (not installed) ProcVersionSignature: Ubuntu 3.16.0-24.32-generic 3.16.4 Uname: Linux 3.16.0-24-generic x86_64 ApportVersion: 2.14.7-0ubuntu8 Architecture: amd64 CurrentDesktop: Unity Date: Wed Nov 5 15:49:03 2014 InstallationDate: Installed on 2013-11-26 (344 days ago) InstallationMedia: Ubuntu 13.10 "Saucy Salamander" - Release amd64 (20131016.1) SourcePackage: libreoffice UpgradeStatus: Upgraded to utopic on 2014-10-08 (27 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1389858/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
