https://bugs.documentfoundation.org/show_bug.cgi?id=100599
Bug ID: 100599
Summary: Copying Sheets in Calc seems to use relative sheets
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: aa169d62...@gmail.com
Created attachment 125893
--> https://bugs.documentfoundation.org/attachment.cgi?id=125893&action=edit
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''.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
