[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from gmolleda at us.es ---
In relation to error bug#121978
(https://bugs.documentfoundation.org/show_bug.cgi?id=121978)
SECOND before rounds -> SECOND("00:00:08,99") -> result 9, and now result 8.

I think of two possible solutions, or have two functions: SECOND("00:00:08,99")
with result 9 and SECONDNOTROUNDED("00:00:08,99") that return 8. Or a function
with a second parameter optional rounding (with backward compatibility):
=SECOND("00:00:08,99" [, BOOLEAN ROUND]), default BOOLEAN ROUND is TRUE.

=SECOND("00:00:08,99") = SECOND("00:00:08,99",TRUE) = 9
=SECOND("00:00:08,99", FALSE) = 8

-- 
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/20181209/c6018481/attachment.html>