desktop-packages team mailing list archive

[Björn Michaelsen <bjoern.michaelsen@xxxxxxxxxxxxx>]

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