<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Undo doesn't restore references in other sheets to a moved cell"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131481">131481</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Undo doesn't restore references in other sheets to a moved cell
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>barteks2x@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>