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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sat Apr 10 14:20:58 UTC 2021


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

b. <newbie-02 at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW

--- Comment #19 from b. <newbie-02 at gmx.de> ---
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)

another problem is with which values calc calculates, and how much of it is
visible / accessible to the user, that would have been quite easy for this
case, but is a real pain once you get behind 14 digits, i vote for 'enhance
this',

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


More information about the Libreoffice-ux-advise mailing list