https://bugs.documentfoundation.org/show_bug.cgi?id=158487
Bug ID: 158487
Summary: Calculation bug in LibreOffice Calc when working with
€
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: [email protected]
Reporter: [email protected]
I found a bug in LibreOffice Calc 7.3.7.2 in calculating money in €.
It looks though that it could also happen with any currency.
If you set the cells to € with 2 decimals like € 1234,00, it does not calculate
with those 2 decimals but with the number it has calculated.
I made a sheet where it had to calculate 25% of a number in € with 2 decimals.
In that situation I had to add 2 values in €, one being the calculated number
in € and the calculation was € 0,01 off.
That is because the number is not rounded up like people expect but Calc seems
to just drop the third decimal it calculated.
I investigated it and found out that the calculation is done with the
calculated number where the third decimal was a 5.
In one column I had 6 of those and so the calculation was wrong by € 0,03.
In my opinion it is a critical bug because it means that you cannot trust the
calculations that Cacl does with money!
And if you would be a in charge of finance for a company that uses LibreOffice
Calc to calculate all your finances, that would be a reason to stop using it.
Now I also know that you can up the decimals of a cell in € from 2 to 3 of even
more but in IT-land that is rated as a workarround and not a fix.
The way I see it there are 2 bugs in 1:
1) If you set the decimals to 2 it should also calculate with 2 decimals.
2) If you calculate 0,01 + 0,015 and round the number to 2 decimals, the
outcome should be 0,03 and not 0,02.
In mathmathics rules, if you round a number than 1 to 4 rounds down and 5 to 9
rounds up.
That means if you have to round 0,015 to 2 decimals, it should become 0,02 and
not 0,01.
--
You are receiving this mail because:
You are the assignee for the bug.
