<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 - Some simple calc results using SUM and MIN are in error"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114380">114380</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Some simple calc results using SUM and MIN are in error
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Mac OS X (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>dushanm@spinn.net
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=138339" name="attach_138339" title="LO Calc spreadsheet showing calc errors">attachment 138339</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=138339&action=edit" title="LO Calc spreadsheet showing calc errors">[details]</a></span>
LO Calc spreadsheet showing calc errors
LO versions 5.4.3.2 and 5.3.7.2 both produce this error. A sample spreadsheet
portion is attached. Column O calculates the result of SUM(dX:nX)-MIN(dX:nX)
for row numbers X=3 to X=24. Four of the results, in rows 5, 12, 16, and 18
(in blue), are incorrect. The correct ones are shown in column P. Except for
row 16, the error is the value in column D: it seems to be ignored.</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>