https://bugs.documentfoundation.org/show_bug.cgi?id=105364
m.a.riosv <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
CC| |[email protected]
| |rg
Resolution|--- |NOTABUG
--- Comment #2 from m.a.riosv <[email protected]> ---
(In reply to Frank van Wensveen from comment #0)
> ....
> Demonstrate incorrect behavior (i.e. expose the bug) as follows:
> 9. Right-click sheet1_2, select "Delete Sheet", click "Yes"
> 10. Right-click "Sheet1" tab, select "Move/Copy Sheet", under "Action"
> select "Copy"; under "Location" select "Insert Before Sheet1", click "OK".
> This will create a new tab "Sheet 1_2" before the "Sheet1" tab.
> 8 Click "Sheet1_2", click cell A1. Value in this cell will now be:
> "=Sheet2.A1". THIS IS INCORRECT BEHAVIOR. The value should be "=Sheet3.A1"
> as was the case when the copy was inserted after the "Sheet1" tab.
If you want it behaves in that way use absolute references for the sheet in the
formula:
=$Sheet3.A1
It's the same behaviour like if you copy the formula from one sheet to another.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
