<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 - LibreOffice Calc wrong calculation"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134168">bug 134168</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>NEW
</td>
<td>RESOLVED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - LibreOffice Calc wrong calculation"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134168#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - LibreOffice Calc wrong calculation"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134168">bug 134168</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>Not a bug.
There is accumulated inaccuracy in the results you can see when applying the
General format instead of 0.00, it already starts at G6 132.025 (which itself
is correct but maybe unexpected by you) and G7 148.1882 and G8 148.834150943396
... the visual value 147.91 is in fact 147.908396164021 so multiplying that
with 147 of course gives 21742.5342361111
You need to round the calculations as desired, here 2 decimals, so in G6
=IF(E6<0;G5;ROUND((G5*SUM(E$5:E5)+F6*E6)/SUM(E$5:E6);2))
and copy down.
Either that, or activate "Precision as shown" under Tools -> Options -> Calc ->
Calculate, which is more expensive though and maybe undesired for other
formulas.</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>