https://bugs.documentfoundation.org/show_bug.cgi?id=141292
--- Comment #17 from steffan.steff...@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. _______________________________________________ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise