<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:guilleron29@aol.com" title="Jacques Guilleron <guilleron29@aol.com>"> <span class="fn">Jacques Guilleron</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - Internal SUM calculation of over 6 negative decimal values results in rounding error"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=109189">bug 109189</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;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEEDINFO
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>guilleron29@aol.com
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - Internal SUM calculation of over 6 negative decimal values results in rounding error"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=109189#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - Internal SUM calculation of over 6 negative decimal values results in rounding error"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=109189">bug 109189</a>
from <span class="vcard"><a class="email" href="mailto:guilleron29@aol.com" title="Jacques Guilleron <guilleron29@aol.com>"> <span class="fn">Jacques Guilleron</span></a>
</span></b>
<pre>Hi C.Drewke,
This sum function in Status bar follows the cells format. By default, there is
no value for decimal places with ths Standard format, you get so the greatest
precision and no rounding.
If I enter =SUM(A1:A6) into A7, I get here 0, a rounded value, with the
Standard format.
To make some differences, Excel give also a rounded value 0, when A1:A6 is
selected and -7,10543E-15 precision only when Sum in A7 is selected too, still
with the Standard format.
With any decimal place number, Excel give always a simple 0 for A1:A6 selection
and follows the cell format when A7 is selected and formatted.
Do you expect the same behavior?</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>