Created attachment 125893 [details] shows how to recreate bug This bug may be related Bug ID 86652. I tried to provide more precise instructions to recreate the bug. Abstract: It seems as if one copies a sheet containing references to another sheet, the sheet references are relative, not absolute. (I had a better example, but Calc saved the spreadsheet as a CSV file without warning. A separate bug report. This spreadsheet implied the problem was more severe, but I can only recreate the following at this time.) 1. Open a new spreadsheet (I used ``soffice --calc'' from the BASH command prompt) 2. In cells A1:C2, put 1 2 3 4 5 6 3. Make a new sheet, insert at the end. 4. Make Cell A1 in Sheet2, =Sheet1.A1 5. Drag and drop the other cells in the range A1:C2 So far, so good 6. Right click Sheet2, choose ``Move/Copy Sheet'', and Copy, Insert before ``Sheet 1''. Name it Sheet3. 7. All values become ``#REF!''. Cell A1, for example, has the formula =#REF!.A1 . [Hypothesis: There is no sheet to the left/before this sheet.] ---- Note: I made a new Sheet 4, but inserted after Sheet2. I thought I might get some errors, but I did not. ------ 8. In Sheet1, make Cell A7 have the value 7. 9. In Sheet2, make Cell B7 have the formula ``=Sheet1.A7''. A. Right click Sheet2, choose ``Move/Copy Sheet'', and Copy, Insert ``- move to end position -'' Name this sheet "after_b7". B. The value of B7 in sheet after_b7, is ``0''; the formula is ``=Sheet4.A7'' Note: If you copy =Sheet2.A7, you should get the same result. That is, A1 yields the same result (modulo formatting), no matter what cell the formula is in. It seems it is copying from the sheet to the left ``Sheet4''.
On which LO version are you? FYI, last stable one is 5.1.3 (and 5.1.4 will be released soon)
Julien, 5.1.4 is already out. According to bug 100598, the version used is 4.2.8.2.
(In reply to Aron Budea from comment #2) > Julien, 5.1.4 is already out. > According to bug 100598, the version used is 4.2.8.2. You're right! I thought it was RC2.
Yes, this computer does have version 4.2.8.2 installed. And, yes, I know it is old, however, to make a long story short, after some trouble with apt-get dependencies, I successfully upgraded another computer to LO 5 point something; ``unoconv'' no longer worked. Therefore, I never upgraded my other computers. I can check a newer version if you want.
Yes, please try with 5.1.4. Here are detailed steps on installing it in parallel with your existing installation: https://wiki.documentfoundation.org/Installing_in_parallel/Linux
I installed the latest version; the sheets were copied correctly. BTW, the directions on how to install an alternate version were somewhat out of date.
Thank you for your feedback aa169d62f81. Let's put this one to WFM then.
aa169d62f81, could you pinpoint the outdated part of the wiki page? Thanks!