[Libreoffice-bugs] [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 #20 from steffan.steffner at gmx.net ---
(In reply to b. from comment #19)
> it's two different problems ... 
> 
> one is the logical problem with rounding in totaling calculations, e.g the
> conflict between selling two items for 1,02 bucks, each charged with 19
> percent VAT resulting in - rounded down - two times 0,19 -> 0,38, vs.
> calculating the VAT for the full net amount of 2,04 bucks to - rounded up -
> 0,39 is a problem a spreadsheet can't solve, the user must be aware that
> there are pitfalls, check the correct way to calculate with his accountant,
> and take that into account ... 
> 
> (spreadsheets can be set up correctly for each schema, but not for both at
> the same time)

Actually, in my case at hand, it would have been quite difficult to do the
summing first, if there is 16% VAT on the first amount and 19% VAT on the
second amount.

Apart from that I completely agree that this is a well known problem, like i.e.
here  https://www.manager.io/guides/9499

But I think that most people would agree that in an invoice the numbers as
displayed or "on paper" have to add up, even if this means that the result is
mathematically less exact. The problem is that this case (see attachment
"screenshot calculated in normal way" ) does not happen every day, so a person
(like I) will be caught by surprise. Thus my request for a tooltip.

-- 
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/20210410/c34bdce7/attachment.htm>