desktop-packages team mailing list archive

[Luke <1389858@xxxxxxxxxxxxxxxxxx>]

Björn,
> 1/ LibreOffice did not update references correctly and consistently on sort before 4.2.x

You are confusing the issues here. No spreadsheet software consistently updates or does not update references, because there are many types of references. However, there is a well established behavior that 
a) Sorting RELATIVE references does not update 
b) Sorting ABSOLUTE references does  update 
All spreadsheet software followed this behavior, including LibreOffice before 4.2.x, Gnumeric, Google Sheets. WPS Sheets, and EXCEL

> There is an equal set of users who want references

Equal? Over the past few years there have just been a few bug reports
asking for the new sort behavior. These were filled out by users who
admittedly are new to spreadsheets and do not know how to use absolute
references. In just a few weeks, this new sort has caused dozens of bug
reports like this one and all the dupes of Bug 81633. In fact the [Meta]
Bug 85490  that's supposed to track usecases could only find ONE
synthetic example that could easily be FIXED with absolute references.

> Note that the upcoming LibreOffice 4.4.x will default to the fdo#81309
behaviour (Sorting should automatically adjust references.)

By changing the behavior to update references, you will be insidiously
breaking spreadsheets. Unless the users are looking at the formula, they
may not realize that newly sorting spreadsheets are giving invalid
results like https://bugs.freedesktop.org/show_bug.cgi?id=85571 Where
1+1 = 3  after a sort with the new system

Why are we breaking old spreadsheets and interoperability for a few
users that don't know how to use absolute references?

** Bug watch added: freedesktop.org Bugzilla #85571
   https://bugs.freedesktop.org/show_bug.cgi?id=85571

-- 
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-0ubuntu1 not updating references after sort

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