[Libreoffice-bugs] [Bug 121978] Problem with new function SECOND

[bugzilla-daemon at bugs.documentfoundation.org]

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

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 #7 from Winfried Donkers <winfrieddonkers at libreoffice.org> ---
I'll take it.

Bug 118800 was meant to fix rounding 59.9 seconds to 60, which is not a valid
result for SECOND, which must return integer values between 0 and 59
(inclusive).

This bug shows that the fix for tdf118800 is not correct, as it returns the
integer part of the second value, instead of rounding the value.

ODF1.2 Part 2 §6.10.16 states that the second value is to be rounded.

That means that SECOND(11:22:59.9) should return 0 (11:23:00).

-- 
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/20181210/b2ec725e/attachment.html>