https://bugs.documentfoundation.org/show_bug.cgi?id=121978
--- Comment #6 from [email protected] ---
Beware that they have corrected the failure of which =SECOND("00:00:08.99") = 9
and not 8, same as YEAR ("12/31/2018") <> 2019.
Another solution would be to round up the later unit:
=SECOND("00:00:08.990") -> SECOND("00:00:08.99") = 8, but
=SECOND("00:00:08.999") -> SECOND("00:00:09.00") = 9.
Units?
DATE (dd/mm/yyyy)
HOUR
MINUTE
SECOND
HUNDREDTH or THOUSANDTHS
--
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
