LibreOffice Calc removes sheet names from calculations when saving

[Daniel Burton]

LibreOffice Calc is removing the sheet names form some of my calculations when I save my spreadsheet. I have one sheet called "Cities_Chart" with a comparison of different cities and data about those cities and it comes up with a score by adding up the data with weights from a separate sheet called "Weights". When I open the document, after saving, "Weights" has been removed from all the calculations on the first sheet, and it is using the data in cells on the same sheet instead. For exampled, $Weights.$B$9 is replaced by $B$9.

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:15:49 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)]

Attached is my spreadsheet. The issue is on the first sheet, Columns BZ to CG. I have previous saved versions in this document, and in the most recent one, these calculations are correct, so you can see what they are supposed to look like. Oddly, when I compare to the last saved revision, the changes in these calculations do not show up.

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[T (tamam-khadduri)]

I am facing the same issue, on 2 separate files. Calc keeps removing the sheet names from the formulas even before saving sometimes, but after switching from sheet to sheet.

I am happy to share the files if required.

[madbiologist (me-again)]

I'm pretty sure that the sheet name needs to be enclosed in single quotes.

[penalvch (penalvch)]

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

First, I want to ensure the following isn't being tripped on here https://help.libreoffice.org/Calc/Addresses_and_References,_Absolute_and_Relative .

If this isn't, could you please test one of the 5.x PPAs via https://launchpad.net/~libreoffice and advise if this is still reproducible?

If so, please post as a comment the precise line item of the cell prior to when when the document is saved, closed, and reopened demonstrates this problem.

[Launchpad Janitor (janitor)]

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