https://bugs.documentfoundation.org/show_bug.cgi?id=150049
--- Comment #2 from SheetJS <d...@sheetjs.com> --- Duration formats are currently broken (see https://bugs.documentfoundation.org/show_bug.cgi?id=150028) The assertion "LibreOffice does not round wall clock time formats" is incorrect and an example was included in the "additional info" section: """ Rounding does work with sub-second units. Testing with the value 0.002415: | format | LO | Excel | +:-------+:-------+:-------+ | ss | 28 | 29 | | ss.0 | 28.7 | 28.7 | | ss.00 | 28.66 | 28.66 | | ss.000 | 28.656 | 28.656 | """ To be more explicit, if LO were internally consistent, for the value 0.002415 you would expect the following (written in the reverse order for clarity): "ss.000" -> "28.656" "ss.00" -> "28.65" "ss.0" -> "28.6" "ss" -> "28" However, LO generates the following: "ss.000" -> "28.656" "ss.00" -> "28.66" /* rounding :( */ "ss.0" -> "28.7" /* rounding :( */ "ss" -> "28" /* not rounding */ -- You are receiving this mail because: You are the assignee for the bug.