https://bugs.documentfoundation.org/show_bug.cgi?id=136615
--- Comment #12 from SheetJS <[email protected]> --- There are two internally consistent ways to render date-time formats: 1) always round to the most granular date token 2) render to a standardized format and extract parts. Given the support for milliseconds, this format would be "yyyy-mm-dd hh:mm:ss.000" Right now, as described in https://bugs.documentfoundation.org/show_bug.cgi?id=150049 , LO is inconsistent. Either interpretation ("rounding" / "truncation: respectively) is fine, but it should be consistent and it should be clearly documented (especially if the decision is to clash with Excel) OOXML (Excel) definitely uses some sort of rounding. There is a test case in 18.17.4.2: > The serial date-time 0.0000115... represents 00:00:01 0.0000115 is 0.9936 / 86400, just shy of 1/86400 . Truncation would imply "00:00:00" and rounding would imply "00:00:01". The reasonable conclusion is that OOXML examples seems to imply rounding. Needless to say, LO is clashing with Excel: =TEXT(0.0000115, "hh:mm:ss") Excel and OOXML both yield 00:00:01 while LO yields 00:00:00 -- You are receiving this mail because: You are the assignee for the bug.
