[Libreoffice-bugs] [Bug 138595] New: calc ROUND() precision bug
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Tue Dec 1 12:20:13 UTC 2020
https://bugs.documentfoundation.org/show_bug.cgi?id=138595
Bug ID: 138595
Summary: calc ROUND() precision bug
Product: LibreOffice
Version: 7.0.3.1 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs at lists.freedesktop.org
Reporter: beckyomegakawaii at gmail.com
Description:
Video displaying the bug
https://youtu.be/Qg3eWC104c4
ODF file in question
https://mega.nz/file/WyYhHCTC#XxMHXwCSk6p3a_BtMFo5lr1C8IvelwhvMn8mtyNyb7w
Steps to Reproduce:
1.Have a formula that results in a number with EXACTLY .5000000000~ (not
0.499999~ or similar)
2.ROUND() the result
3.Most of the time rounds up as it should, but sometimes it rounds down.
Actual Results:
Rounds down
Expected Results:
Rounds up
Reproducible: Sometimes
User Profile Reset: No
Additional Info:
This has been happening since a long time ago, but I thought it was my
machine/the formula etc. I have confirmed that it happens on every single
computer i've ever tried.
--
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/20201201/c08189f5/attachment.htm>
More information about the Libreoffice-bugs
mailing list