<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 WONTFIX - Calc addition is broken: 751.19+(-700.1) != 51.09"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114295">bug 114295</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>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>WONTFIX
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WONTFIX - Calc addition is broken: 751.19+(-700.1) != 51.09"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114295#c6">Comment # 6</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WONTFIX - Calc addition is broken: 751.19+(-700.1) != 51.09"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114295">bug 114295</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>It's a known fact in computer world that decimal floating point numbers can't
be accurately represented as binary floating point numbers and specifically
adding or subtracting numbers may introduce an error margin.
See also
<a href="https://support.microsoft.com/kb/78113">https://support.microsoft.com/kb/78113</a>
<a href="https://blogs.office.com/en-us/2008/04/10/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers">https://blogs.office.com/en-us/2008/04/10/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers</a>
<a href="https://en.wikipedia.org/wiki/Numeric_precision_in_Microsoft_Excel">https://en.wikipedia.org/wiki/Numeric_precision_in_Microsoft_Excel</a>
This is similar true in Calc.</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>