https://bugs.documentfoundation.org/show_bug.cgi?id=159556
Bug ID: 159556
Summary: LibreOffice Calc; mathematical rounding error
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
In LibreOffice Calc mathematical rounding error occur in Cell D42 when adding
mathematical formula values from cells D39 and D40. If you need, i can send the
File to you.
Actual Results:
D33 has the value 211718.850; D34 has the value 216257.900; D35 mathematical
Formula =Sum(D34-D33); D36 has a value of €0.1257; D39 mathematical formula
=Sum(D35*D36) -Value is 570.56€; B40 has a value of 19; D40 mathematical
formula=Sum((D39*B40)/100 - value is €108.41; D42 mathematical
formula=Sum(D39+D40) - value is €678.96. This value should be €678.97!! !
Expected Results:
678,97€ in Cell D42
Reproducible: Always
User Profile Reset: No
Additional Info:
I don't know what I can write here
--
You are receiving this mail because:
You are the assignee for the bug.
