https://bugs.documentfoundation.org/show_bug.cgi?id=124286
Bug ID: 124286
Summary: ROUNDDOWN is inaccurate with decimal numbers
Product: LibreOffice
Version: 5.1.6.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
The ROUNDDOWN function is imprecise in some cases involving decimal numbers.
For example:
ROUNDDOWN(8,94;2) yields 8,94 (correct).
ROUNDDOWN(8,94-8;2) yields 0,93 (wrong).
ROUNDDOWN(7,94-7;2) yields 0,94 (correct).
Steps to Reproduce:
1.Let cell A1 =8.94-8
2.Note how the correct result is displayed (0.94).
3.Let cell B1 =ROUNDDOWN(A1;2)
4. Note the wrong result (0,93).
Actual Results:
Wrong result (0.93)
Expected Results:
Correct result (0.94)
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
--
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
