[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 #17 from steffan.steffner at gmx.net ---
(In reply to Heiko Tietze from comment #12)
> So what you probably talk about is how a number is shown but I don't see the
> question here. Got an example?



Yes, I will show here he example that made me search for 1 hour.

It is about an incoice, and what is come down to is that I had 2 sums, one had
to be added 16% tax (for 2020), and the other had to be added 19% tax (for
2021). And the displayed result of my invoice was that the numbers displayed in
the invoice didn’t add up: The total sum was 1 Cent too high. 

So the calculations that were critical were:

469 x 0,16 = 75,0528
1.946,96 x 0,19 = 369,9224

Obviously when you add up those 2, you will get
444,9752  →  which will be rounded up to 444,98 

To clarify this: Every one of these 2 numbers will not be rounded, but the sum
of these 2 will be rounded because 00,0052 will be rounded up to 00,01. And
this was where the extra Cent came from.

You know how accountants are:  If the numbers they see on the paper don’t add
up, they will be mad at you. 

And, as you know, the solution to this problem was, that I did as recommended 
in
https://help.libreoffice.org/7.1/en-US/text/scalc/guide/rounding_numbers.html

i.e. I let calc skip the internal decimal places that are not displayed as
indicated in the above link 

>>“To calculate with the rounded off numbers instead of the internal exact >>values
>>    Choose Tools - Options - LibreOffice Calc.
>>    Go to the Calculate page. Mark the Precision as shown field and exit the >>dialog with OK.”

See also my uploads “test - ‘normal.ods”  and “test--'Precision as shown'.ods”
, as well as screenshots of these two.

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