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 -- Mailing list: https://launchpad.net/~desktop-packages Post to : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
