https://bugs.documentfoundation.org/show_bug.cgi?id=145750
Bug ID: 145750
Summary: Arithmetically 2-1 not always equal to 1?
Product: LibreOffice
Version: 7.1.6.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 176330
--> https://bugs.documentfoundation.org/attachment.cgi?id=176330&action=edit
calc sheet sample test
I note the following: subtracting two values the result is not always accurate.
An example: 3912,24000000000000-3892,96000000000000 = 19,27999999999970
the result should be 19,28 but a comparison =if((x-y)=19,28;"OK";"notOK") gives
the result "notOK".
(see attached test, noting that the decimal separator is comma (IT))
--
You are receiving this mail because:
You are the assignee for the bug.
