https://bugs.freedesktop.org/show_bug.cgi?id=86652

--- Comment #3 from [email protected] ---
Sorry for my mistake - the bug description is here

Procedure to reproduce:

- create a new Calc file
- enter a few numbers somewhere in sheet 1
- go to sheet 2
- link a few cells the cells with content in sheet 1 (the cells in sheet 2 show
the content of the linked cells as expected)
- right click tab of sheet 2
- click Move/copy sheet
- select Copy and move to end (others not tested)
- click OK
now the first copy of sheet2 = sheet2-2 is created
links are broken, cells show  #REF

- select sheet2-2
right click tab of sheet 2-2
- click Move/copy sheet
- select Copy and move to end (others not tested)
- click OK

now the first copy of the copy of sheet2 = sheet2-2-2 is created
links are correct to the cells of sheet1 and the correct values are shown

- select sheet2-2-2
right click tab of sheet 2-2-2
- click Move/copy sheet
- select Copy and move to end (others not tested)
- click OK

now the copy of the copy of sheet2 = sheet 2-2-2-2 is created
links now to sheet2 but values are shifted 1 row down
(look at the links and the displayed value)


- select sheet2-2-2-2
right click tab of sheet 2-2-2-2
- click Move/copy sheet
- select Copy and move to end (others not tested)
- click OK

now the copy of the copy of the copy of sheet2 = sheet2-2-2-2-2 is created
links point to sheet2-2 and there is a vertical off-set
displayed values are #REF except for top cell which shows 0 


step back
- select sheet2-2
right click tab of sheet 2-2
- click Move/copy sheet
- select Copy and move to end (others not tested)
- click OK

now the 2nd copy of sheet2 = sheet2-3 is created
links point to sheet2-2-2 and have a vertical offset

here I stopped to make further tests with further copies

I think this bug should be removed with a very high priority.

In previous versions (4.0. 4.1. 4.2 all >- x.y.4) copying a sheet inside the
same Calc file did not create any link related problems.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to