Download it now!
Bug 131481 - Undo doesn't restore references in other sheets to a moved cell
Summary: Undo doesn't restore references in other sheets to a moved cell
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: bibisected, bisected, regression
Depends on:
Reported: 2020-03-22 16:56 UTC by barteks2x
Modified: 2020-03-23 06:40 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description barteks2x 2020-03-22 16:56:04 UTC
Steps to reproduce (tested with version 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.
Comment 1 Mike Kaganski 2020-03-22 17:16:54 UTC
Repro with Version: (x64)
Build ID: b29fb89d0a49fde0f5757774d64a7aba8298ac75
CPU threads: 12; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: CL

No repro with Version:
Build ID: 1ba9640ddd424f1f535c75bf2b86703770b8cf6f
Locale: ru_RU
Comment 2 Mike Kaganski 2020-03-23 06:40:06 UTC
Regression after