[Libreoffice-ux-advise] [Bug 141292] Calc should display hint "internal calculation is done without rounding".

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #28 from steffan.steffner at gmx.net ---
I should have given the exact details right from the beginning – so my fault:



[calculation below: precision as shown is *off*]

SUMME 1 (2020)            469,08 €
+SUMME 2 (2021)         1.946,96 €
+16% Mwst. (von Summe 1)  75,05 €
+19% Mwst. (von Summe 2) 369,92 €
=   Gesamtbetrag       2.861,02 €


This is the result when precision as shown is off (default). But the result is
not wrong, it is **mathematically more exact**, because in reality the numbers
are:

in Euro:
469,08 + 1946,96 + 75,0528 + 369,9224 = 2861,0152 

Thus, 2861,02 is only 0,0048 away from the exact result, whereas 2861,01 is
0,0052 away from the exact result.

The problem thus comes down to: 
In an invoice, you don’t want the mathematically more exact result, you want
results that add up with what is shown ‘on paper’.

And if you take out your calculator, and you add up what is shown on paper, you
get the result 2861,01.

Hope that made it clear.

-- 
You are receiving this mail because:
You are on the CC list for the bug.