desktop-packages team mailing list archive

[madbiologist <1399951@xxxxxxxxxxxxxxxxxx>]

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

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