<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:peter.beurle@bigpond.com.au" title="Peter Beurle <peter.beurle@bigpond.com.au>"> <span class="fn">Peter Beurle</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Cells not recalculating after moving"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121002">bug 121002</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>RESOLVED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>NOTABUG
</td>
<td>---
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Cells not recalculating after moving"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121002#c8">Comment # 8</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Cells not recalculating after moving"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121002">bug 121002</a>
from <span class="vcard"><a class="email" href="mailto:peter.beurle@bigpond.com.au" title="Peter Beurle <peter.beurle@bigpond.com.au>"> <span class="fn">Peter Beurle</span></a>
</span></b>
<pre>Steps to reproduce;
1. Create a blank worksheet
2. Ensure AutoCalculate is turned on Data|Calculate. This should mean any
changes to cell values are recalculated automatically, without F9 manual
recalculation.
3. Create a small table of four rows and three columns. In column C put a
formula SUM(A1:B1) and copy down to row four.
4. In A3 and B3 put in 3, C3 should now show 6
5. In A4 and B4 put in 4, C4 should now show 8
6. Select cells A3 to B4 and drag (move) to A1. A1 and B1 should now have 3 in
them and A2 and B2 should now have 4 in them.
7. Cell C1 shows zero. The formula in cell C1 is SUM(A1:B1). Expected result is
6
8. Cell C2 shows zero. The formula in cell C2 is SUM(A2:B2). Expected result is
6
9. Select cell C1 and push F9, result is 6 ∴ cells did not auto recalculate.
10. The relationship between the values and result on row three and four
changed on the move. The formula in C3 now represents the values in A1 and B1.
The formula in C1 has had its values change, effectively overwritten by the
move. If you do this in Excel formula in C1 and C2 return #REF!, indicating the
references have been broken. This warns the user that they have made changes to
the referenced cells A1:B2</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>