https://bugs.freedesktop.org/show_bug.cgi?id=69181
Priority: medium
Bug ID: 69181
Assignee: [email protected]
Summary: EDITING: copy sheet command / ctrl+move_tab renames
references
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
Problem description:
The context command on the sheet tab "Move/Copy Sheet ..."
makes the reference invalid (=#REF!.A1)
(example below)
or renames the "reference target sheet" to the one one of the "copy sheet"
(=Sheet1.A1 instead of =Sheet2.A1)
(happened to me to a range inside a VLOOKUP unable to reproduce)
or when pressing "ctrl" move_tab with mouse to copy (reproducable but doesn't
happen all the time)
noticed in 4.1.0.4 / Windows 7 x64
Steps to reproduce:
1. create Sheet1 and Sheet2 and fill Sheet2 with data (A1)
2. create a reference in Sheet1 ( =Sheet2.A1 )
3. use the "Move/Copy Sheet ..." command mentioned above
4. look in the copied Sheet at the reference
Current behavior:
The Reference gets replaced with =#REF!.A1
or even "=Sheet1.A1"
Expected behavior:
Should copy the sheet as is
not manipulate References the way it does now.
Operating System: Windows 7
Version: unspecified
--
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