[Libreoffice-bugs] [Bug 134168] LibreOffice Calc wrong calculation

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=134168

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|NEW                         |RESOLVED

--- Comment #3 from Eike Rathke <erack at redhat.com> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200714/3bfa7e3e/attachment.htm>