Comment 7 for bug 1389858

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