<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 - calc: move cell does not update row sum"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121568">121568</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>calc: move cell does not update row sum
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (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>satphil@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
See attached test case. Sum two rows: A1 + B1 = C1; A2 + B2 = C2 where B1 is
blank. Cut B2 and paste into B1. Result C2 is decremented correctly by old B2
value; but result C1 is NOT incremented by new B1 value. Formula of C1 remains
correct =SUM($Sheet1.A1:B1) as is C2's formula but C1 result is wrong. Saving
file, close and re-open does not fix incorrect C1 result. Undo undo to return
to initial state results in C2 now having incorrect result. Bug occurs whether
drag and drop or control-x/control-v used. This is a data integrity issue as
the wrong answer is being displayed.
Steps to Reproduce:
1. Sum two rows: A1 + B1 = C1; A2 + B2 = C2 where B1 is blank.
2. Cut B2 and paste into B1. Result C2 is decremented correctly by old B2
value; but result C1 is NOT incremented by new B1 value.
3. Formula of C1 remains correct =SUM($Sheet1.A1:B1) as is C2's formula but C1
result is wrong.
4. Saving file, close and re-open does not fix incorrect C1 result.
5. Undo undo to return to initial state results in C2 now having incorrect
result.
6. Bug occurs whether drag and drop or control-x/control-v used.
Actual Results:
C1 not incremented by new B1 value; undo does not return to initial state
Expected Results:
C1 incremented by new B1 value; undo does return to initial state
Reproducible: Always
User Profile Reset: No
Additional Info:
Reproduced reliably by <a href="mailto:olivier.tilloy@canonical.com">olivier.tilloy@canonical.com</a> on Ubuntu 16.04 and 19.04
(libreoffice 6.1.3.2).
He can also reproduce the issue with the upstream build of libreoffice
(6.1.3.2)</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>