[Libreoffice-bugs] [Bug 118800] HOUR function>> 24 is displayed instead of 0(zero) if Number argument in the range from -0.000001 to min negative number.

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Jul 18 17:44:15 UTC 2018


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

Winfried Donkers <winfrieddonkers at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Assignee|libreoffice-bugs at lists.free |winfrieddonkers at libreoffice
                   |desktop.org                 |.org
             Status|NEW                         |ASSIGNED

--- Comment #2 from Winfried Donkers <winfrieddonkers at libreoffice.org> ---
There is a rounding error in the code.
For example, =HOUR("10:59:59.6") returns 11, whereas it should return 10.

I will fix it.

-- 
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/20180718/3b4e1b4a/attachment.html>


More information about the Libreoffice-bugs mailing list