References do not match right row after sorting

[Daniel Burton]

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)

[Daniel Burton (lordofthebrambles)]

Also attached is the previous version of this file, before all the calculations got out of order by sorting.

[penalvch (penalvch)]

Daniel Burton, thank you for reporting this and helping make Ubuntu better.

To see if this is already resolved, could you please test one of the 5.x PPAs from https://launchpad.net/~libreoffice and advise to the results?

To advise, searching via the following in the first sheet (Cities_Charts) noted Search key not found:
Comparison_Chart

[Launchpad Janitor (janitor)]

[Expired for libreoffice (Ubuntu) because there has been no activity for 60 days.]