desktop-packages team mailing list archive

[Luke <1389858@xxxxxxxxxxxxxxxxxx>]

@Björn Michaelsen

> The 4.2.7-0ubuntu1 package should now satisfy the fdo#81633

Please try the attached test file along with the attached test cases in
81633 such as  test_offset.ods and  Calc bug.ods.  None of these work
with Ubuntu's Calc 4.2.7.2, but worked just fine under 4.2.6.

>  Apparently these two reddit users are not aware that they have
exactly opposing opinions on the expected behaviour.

As Manuel pointed out, what people want is the old sorting behavior
back.  They're probably using the wrong terminology because this change
is confusing and requires toggling a secret option (update refs) that is
not well documented.

While 4.2.6 may not have been perfect, as least it mostly followed the
industry conventions of updating relative references, while never
updating Absolute references. It did this automatically, without the
need to toggle any settings that require a restart. Take a look at the
use cases in FDO# 85490 to see how many spreadsheets sorted fine in
4.2.6 and Excel but with 4.2.7 there is no clear UpdateRefs setting that
always works.

To be clear, with 4.2.7 there is no way to return to the old style
sorting routine. Some spreadsheets that worked fine in Excel and 4.26
require UpdateRefs=True, while others require it to be false. Others are
broken with either UpdateRefs setting because of bugs introduced in this
new sorting routine. Is it any wonder users are confused?

-- 
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