← Back to team overview

desktop-packages team mailing list archive

[Bug 1399951] Re: LibreOffice Calc removes sheet names from calculations when saving

 

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.

** Changed in: libreoffice (Ubuntu)
   Importance: Undecided => Low

** Changed in: libreoffice (Ubuntu)
       Status: Confirmed => Incomplete

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

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


References