<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 - Adding multiple spanned cells causes addition error"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=118069">118069</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Adding multiple spanned cells causes addition error
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.3.6.1 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>howie@greenmuon.org
</td>
</tr></table>
<p>
<div>
<pre>Description:
A spreadsheet has lots of numbers in many rows in one column. The next column
right adds up sequential ranges of rows to get a number. Another column to the
right of the second one adds up the second one's results to get further sums.
That third column starts producing incorrect results after the first few
additions.
Steps to Reproduce:
1. Load the attached "DiceRolling.ods" file in Calc.
2. Look at the additions being performed in cells F6, F9, F13, and F18
3. Compare the results of F9, F13, & F18 with what they should be (noted in
column G for those rows.)
Actual Results:
1+3+6 = 10 (that's OK)
1+3+6+10 = 26 (should be 20)
1+3+6+10+15 = 41 (should be 35)
1+3+6+10+15+21 = 62 (should be 56)
Expected Results:
See note above for actual versus correct results.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version 5.3.6.1
Build ID 5.3.6.1-10.el7
CPU Threads: 8; OS Version: Linux 3.10; UI Render: default; VCL: gtk3; Layout
Engine: new; Locale: en-AU (en_AU.UTF-8); Calc: group
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
Firefox/52.0</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>