[Libreoffice-bugs] [Bug 131246] New: Surprizing result from ROUND()

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=131246

            Bug ID: 131246
           Summary: Surprizing result from ROUND()
           Product: LibreOffice
           Version: 6.1.5.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: stasinos at konstant.gr

Description:
For a particular cell, ROUND(5.5) gives 5 instead of 6. I tried seeing more
decimal digits in case the number is a 5,499999999, but it is a clear 5.5.

If I perform the same calculation in a different cell, the result is as
expected.

The file was originally created on MS Excel, and then edited and saved in
LibreOffice as an xlsx. If saved as an ods, the error disappears. 

Steps to Reproduce:
Open the attahed file.
See sheet3

Actual Results:
ROUND(5.5) gives 5

Expected Results:
ROUND(5.5) should give 6.
It does give 6, except for that particular cell.


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 6.1.5.2
Build ID: 1:6.1.5-3+deb10u3
CPU threads: 6; OS: Linux 4.19; UI render: default; VCL: gtk3_kde5; 
Locale: en-US (en_US.UTF-8); Calc: group threaded

-- 
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/20200309/865643c5/attachment.htm>