https://bugs.documentfoundation.org/show_bug.cgi?id=159297
Bug ID: 159297
Summary: Decimal calculation error with 1800's and 1777,**
Product: LibreOffice
Version: 7.5.0.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
If I say "=1800-1777,42" (or use other numbers like 1820, 1850 for the first
number or use other decimal numbers behind the 1777,**) in a field the result
always has a long decimal e.g. 22,5799999999999. My original numbers were
=1840-1777,58 with the result 62,4200000000001.
If I change the 1777,58 to 777,58 or 2777,58 you get a normal result and the
bug doesn't happen.
I will round it off in the mean time but so weird!
--
You are receiving this mail because:
You are the assignee for the bug.
