desktop-packages team mailing list archive

[Daniel Burton <lordofthebrambles@xxxxxxxxx>]

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.

** Attachment added: "City Comparison.ods"
   https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1399951/+attachment/4275322/+files/City%20Comparison.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/1399951

Title:
  LibreOffice Calc removes sheet names from calculations when saving

Status in libreoffice package in Ubuntu:
  New

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