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. -- 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/1399951 Title: LibreOffice Calc removes sheet names from calculations when saving Status in libreoffice package in Ubuntu: Confirmed Bug description: 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) To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1399951/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp