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

          Priority: medium
            Bug ID: 69181
          Assignee: libreoffice-bugs@lists.freedesktop.org
           Summary: EDITING: copy sheet command / ctrl+move_tab renames
                    references
          Severity: normal
    Classification: Unclassified
                OS: Windows (All)
          Reporter: ebri...@gmail.com
          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
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to