https://bugs.documentfoundation.org/show_bug.cgi?id=106987
Bug ID: 106987
Summary: SUM not using round up for Total
Product: LibreOffice
Version: 5.2.6.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Rounding error on CALC
Previous total is $ 4,400.00 (3rd column, picture attachment (?) will show
these actions)
784.51 (price) is added correctly for $ 5,184.31 (3rd column)
784.51 is multiplied by 2% for (4th column) product, which
15.69 is added from 1st column to new total in 3rd, SHOWING INCORRECT ROUNDING
ERROR Total of $ 5,199.99 (SHOULD BE $ 5,200.00)
previously happened, so I show the product below original to 10 decimal places.
I can clip picture, to show here in attachment.
Steps to Reproduce:
1.just a rounding error, I am unable to replace (?) with Format (s).
2.
3.I check against my BANK, I must add a penney ( .01 ).
Actual Results:
Previous total is $ 4,400.00 (3rd column, picture attachment (?) will show
these actions)
784.51 (price) is added correctly for $ 5,184.31 (3rd column)
784.51 is multiplied by 2% for (4th column) product, which
15.69 is added from 1st column to new total in 3rd, SHOWING INCORRECT ROUNDING
ERROR Total of $ 5,199.99 (SHOULD BE $ 5,200.00)
previously happened, so I show the product below original to 10 decimal places.
I can clip picture, to show here in attachment.
Expected Results:
correct amount added, .01 + .09 should equal .10 (penney), not .09,
as in
784.31 + 15.69 should be $ 800.00,
not $ 799.99
Reproducible: Sometimes
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Builds ID: LibreOffice 5.2.6.2
User-Agent: Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/57.0.2987.133 Safari/537.36
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
