[Libreoffice-bugs] [Bug 131481] New: Undo doesn't restore references in other sheets to a moved cell

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=131481

            Bug ID: 131481
           Summary: Undo doesn't restore references in other sheets to a
                    moved cell
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: barteks2x at gmail.com

Steps to reproduce (tested with version 6.3.4.2.0 on Gentoo linux, I wanted to
test on latest but that will have to wait until I update libreoffice):

0. Create an empty spreadsheet in LibreOffice calc
1. Create 2 sheets named Sheet1 and Sheet2 in this spreadsheet
2. In Sheet1, set some value at cell A1
3. In Sheet2, write the formula =$Sheet1.A1 in any cell
4. Select cells A1-A2 (or any range of cells containing A1)
5. Drag and drop that selected cells to move them somewhere else. Reference in
Sheet2 changes to new location of the content of A1
6. Undo (ctrl+c or edit->undo). Cell in Sheet1 is moved back to A1. Reference
in Sheet2 is not changed back to the original.


This may "corrupt" a spreadsheet beyond practical recovery if noticed too late.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200322/d875e0df/attachment.htm>