<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 - trivial sum() bad value"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116104">116104</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>trivial sum() bad value
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.1 all versions
</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>fabrizio@bzimage.it
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=140238" name="attach_140238" title="screenshot of the bug, libreoffice info + bugged .ods">attachment 140238</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=140238&action=edit" title="screenshot of the bug, libreoffice info + bugged .ods">[details]</a></span>
screenshot of the bug, libreoffice info + bugged .ods
Very strange bug: sum() seems to not to work in a trivial usage.
All info in attached files.
cells in red show bad sum() value while green cell shows right value.
yellow cells has formula inside, while orange cells dont.
However only the white column show the correct sum() value (green) at the end.
See attached png what i see and libreoffice details.
The correct sum is 3793.58 (nor -46664.52 or 11493.58)</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>