← Back to team overview

desktop-packages team mailing list archive

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

 

Public bug reported:

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)

** Affects: libreoffice (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: apport-bug i386 trusty

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

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


Follow ups

References