https://bugs.documentfoundation.org/show_bug.cgi?id=108827
--- Comment #4 from [email protected] ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs