Ask Your Question
0

Calc deleted several foreign sheet name references [closed]

asked 2014-12-17 03:34:28 +0200

marexposed gravatar image

updated 2016-03-07 01:58:19 +0200

Alex Kemp gravatar image

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)

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-07 01:58:25.926757

1 Answer

Sort by » oldest newest most voted
0

answered 2014-12-17 03:51:48 +0200

ROSt52 gravatar image

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.

edit flag offensive delete link more

Comments

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.

marexposed gravatar imagemarexposed ( 2014-12-17 04:20:03 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2014-12-17 03:34:28 +0200

Seen: 188 times

Last updated: Dec 17 '14