https://bugs.documentfoundation.org/show_bug.cgi?id=105364
Bug ID: 105364
Summary: Copy sheet, insert copy before first breaks
inter-sheet cell links
Product: LibreOffice
Version: unspecified
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
When copying a sheet and inserting the copy before the first sheet (tab) breaks
the links between cells in different sheets.
Encountered on: LibreOffice 3.5.7.2 Build ID 350m1 (Build:2) running on Ubuntu
Linux 12.04.5 LTS, kernel 3.2.0-119-generic-pae #162-Ubuntu SMP Tue Dec 6
14:37:52 UTC 2016 i686 i686 i386 GNU/Linux.
How to reproduce:
Set up a new spreadsheet as follows:
1. Create new spreadsheet
2. Click "Sheet3" tab
3. Enter a value in cell A1 (e.g. "123")
4. Click "Sheet1" tab
5. In cell A1, enter "=", then click "Sheet3" tab, click cell A1, hit ENTER.
6. Click "Sheet1" tab, click cell A1. Value in this cell will now be:
"=Sheet3.A1".
Demonstrate correct behavior as follows:
7. Right-click "Sheet1" tab, select "Move/Copy Sheet", under "Action" select
"Copy"; under "Location" select "Insert Before Sheet2", click "OK". This will
create a new tab "Sheet 1_2" after the "Sheet1" tab.
8 Click "Sheet1_2", click cell A1. Value in this cell will now be:
"=Sheet3.A1". This is correct behavior.
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.
--
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
