[Libreoffice-bugs] [Bug 124286] New: ROUNDDOWN is inaccurate with decimal numbers

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: luk_dhaene at yahoo.co.uk

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190323/ee81731b/attachment.html>