https://bugs.documentfoundation.org/show_bug.cgi?id=121978
--- Comment #4 from [email protected] ---
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: =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
The good thing would be that computer doing the subtraction correctly, but I
imagine that they are intrinsic problems to the floating-point calculations of
the processors.
--
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
