<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Calculation should show ZERO, but shows E-12 number"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134669">bug 134669</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;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>RESOLVED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Calculation should show ZERO, but shows E-12 number"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134669#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Calculation should show ZERO, but shows E-12 number"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134669">bug 134669</a>
from <span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span></b>
<pre>Repeated addition of binary floating point values leads to inaccuracy if values
aren't exactly representable, that's a fact of the IEEE 754 double format. If
in your document you widen columns D, F and H you'll see that already the
values in D22, F39 and H43 start to be slightly off. There are two measures to
calculate such series of repeated addition correctly, either round each
calculation to the desired decimals, here ROUND(...;2), or format all values to
two decimals with a number format 0.00 (which in this case already *displays*
the end result as 0.00) and maybe you'll also have to switch on General
Calculations "Precision as shown" under Tools -> Options -> Calc -> Calculate
if the repeated series gets longer with accumulated inaccuracy.
See also <a href="https://erack.de/bookmarks/D.html#010203">https://erack.de/bookmarks/D.html#010203</a></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>