← Back to team overview

desktop-packages team mailing list archive

[Bug 1395901] Re: libreOffice calc formulas are loosing references when moving rows or cells

 

Marking as fixed released then as 1:4.2.7-0ubuntu2~ppa2 has been updated
to Ubuntu 14.04 via SRU as 1:4.2.7-0ubuntu2:
https://launchpad.net/ubuntu/+source/libreoffice/1:4.2.7-0ubuntu2

** Changed in: libreoffice (Ubuntu)
       Status: New => Fix Released

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

Title:
  libreOffice calc formulas are loosing references when moving rows or
  cells

Status in libreoffice package in Ubuntu:
  Fix Released

Bug description:
  Using LibreOffice Version 4.2.7.2 and also losing the Sheet Reference
  in cells. This is reproducible on old spreadsheets and new.

  After doing some testing, it is cause by the cut and paste of a cell.
  So I guess moving the contents of a cell is the same thing.

  It doesn't matter if the cell you cut and paste is reference or not.
  All sheet references are removed. Even if you have sheet references in
  cells on other sheets. All sheet references are removed, but the cell
  reference is still there.

  The cell data displayed doesn't change (very deceiving), but if you
  save and reload, the data now displays the new cell reference data.

  The only work around I have got, is to avoid the cut and paste steps,
  and do a copy paste and delete.

  NOTE: There's a bug report here that explains this with more detail:

    https://bugs.freedesktop.org/show_bug.cgi?id=86125

  At the end, somebody said that this is not happening in more recent
  versions, so maybe all is need is a backport to Trusty

  ProblemType: Bug
  DistroRelease: Ubuntu 14.04
  Package: libreoffice-core 1:4.2.7-0ubuntu1
  ProcVersionSignature: Ubuntu 3.13.0-39.66-generic 3.13.11.8
  Uname: Linux 3.13.0-39-generic i686
  NonfreeKernelModules: nvidia
  ApportVersion: 2.14.1-0ubuntu3.5
  Architecture: i386
  CurrentDesktop: Unity
  Date: Mon Nov 24 18:33:17 2014
  ExecutablePath: /usr/lib/libreoffice/program/soffice.bin
  InstallationDate: Installed on 2014-04-29 (209 days ago)
  InstallationMedia: Ubuntu 14.04 LTS "Trusty Tahr" - Release i386 (20140417)
  ProcEnviron:
   LANGUAGE=es_AR:es
   PATH=(custom, no user)
   XDG_RUNTIME_DIR=<set>
   LANG=es_AR.UTF-8
   SHELL=/bin/bash
  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/1395901/+subscriptions


References