desktop-packages team mailing list archive

[Daniel Burton <lordofthebrambles@xxxxxxxxx>]

Public bug reported:

I am trying to sort the rows of a table with a bunch of data about
various cities and summary columns calculated from that data.  I am
trying to sort descending on the final column, which is a percentage
"score," which is a summary derived from all the other data.  After
sorting, suddenly the references point to the wrong row (Row 4 has
references to Row 5,  and so forth).  Everything is seemingly in a
random order.  This used to work in the last LTS Ubuntu release, and
after sorting, the data would be in the correct order with all the
references pointing to the same correct column.

Attached is the spreadsheet I am using.  I am selecting the
"Comparison_Chart" data range on the first sheet and attempting to sort
the rows by Column CJ ("Combined Rating (% Scale)").

ProblemType: Bug
DistroRelease: Ubuntu 14.04
Package: libreoffice-core 1:4.2.7-0ubuntu1
ProcVersionSignature: Ubuntu 3.13.0-40.69-generic 3.13.11.10
Uname: Linux 3.13.0-40-generic i686
ApportVersion: 2.14.1-0ubuntu3.6
Architecture: i386
CurrentDesktop: XFCE
Date: Sat Dec  6 08:34:55 2014
ExecutablePath: /usr/lib/libreoffice/program/soffice.bin
InstallationDate: Installed on 2014-10-19 (48 days ago)
InstallationMedia: Xubuntu 14.04.1 LTS "Trusty Tahr" - Release i386 (20140723)
SourcePackage: libreoffice
UpgradeStatus: No upgrade log present (probably fresh install)

** Affects: libreoffice (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: apport-bug i386 trusty

** Attachment added: "City Comparison - Copy.ods"
   https://bugs.launchpad.net/bugs/1399955/+attachment/4275338/+files/City%20Comparison%20-%20Copy.ods

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

Title:
  References do not match right row after sorting

Status in libreoffice package in Ubuntu:
  New

Bug description:
  I am trying to sort the rows of a table with a bunch of data about
  various cities and summary columns calculated from that data.  I am
  trying to sort descending on the final column, which is a percentage
  "score," which is a summary derived from all the other data.  After
  sorting, suddenly the references point to the wrong row (Row 4 has
  references to Row 5,  and so forth).  Everything is seemingly in a
  random order.  This used to work in the last LTS Ubuntu release, and
  after sorting, the data would be in the correct order with all the
  references pointing to the same correct column.

  Attached is the spreadsheet I am using.  I am selecting the
  "Comparison_Chart" data range on the first sheet and attempting to
  sort the rows by Column CJ ("Combined Rating (% Scale)").

  ProblemType: Bug
  DistroRelease: Ubuntu 14.04
  Package: libreoffice-core 1:4.2.7-0ubuntu1
  ProcVersionSignature: Ubuntu 3.13.0-40.69-generic 3.13.11.10
  Uname: Linux 3.13.0-40-generic i686
  ApportVersion: 2.14.1-0ubuntu3.6
  Architecture: i386
  CurrentDesktop: XFCE
  Date: Sat Dec  6 08:34:55 2014
  ExecutablePath: /usr/lib/libreoffice/program/soffice.bin
  InstallationDate: Installed on 2014-10-19 (48 days ago)
  InstallationMedia: Xubuntu 14.04.1 LTS "Trusty Tahr" - Release i386 (20140723)
  SourcePackage: libreoffice
  UpgradeStatus: No upgrade log present (probably fresh install)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1399955/+subscriptions