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 Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1395901 Title: libreOffice calc formulas are loosing references when moving rows or cells To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1395901/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
