I don’t know what happened, I have a file with multiple sheets, many of their cells formulas referencing other sheet’s cells. Several of those references simply lost the sheet name reference and it only remained the cell references. For example, if I had the formula “Sheet1.A2” in Sheet2, then the formula appears as simply “A2” in Sheet2.
I already changed everything back to normal, but something is very wrong with LibreOffice.
All I can think of is a relocation of a block I did this morning, but that block I relocated don’t have any references to the affected sheets/cells, plus, I can’t think of a valid reason for it to simply delete the sheet name from the foreing sheet formulas.
I’m letting you know, in case someone else goes through a similar or even worse nightmare, or in case this happens to be a serious bug to affect people in the future (or even me, but I only deal with personal data, nothing too scary to lose).
By the way, I’m using LibreOffice in Ubuntu 14.04, version is…
Version: 4.2.7.2
Build ID: 420m0(Build:2)
This is a bug.https://bugs.freedesktop.org/show_bug.cgi?id=86652 which is only in the 4.2.7 version - according to my tests on an XP machine. If you still have a 4.2.6 copy of a file you might better use this.
Upgrading to 4.3.4.1 solved the matter. Could/should be the solution for you as well.
Thanks. I’ll wait for the guys at Ubuntu to include the upgrade in the next set for 14.04 as I’d prefer not to include an untested repository. I don’t often do cell copy, so hopefully won’t be affected again.