https://bugs.documentfoundation.org/show_bug.cgi?id=150049
Bug ID: 150049 Summary: Formatted time is not rounding by most granular token Product: LibreOffice Version: unspecified Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: d...@sheetjs.com Description: A format like `HH:MM:SS` should round based on the most granular time. Steps to Reproduce: =TEXT(0.00069,"ss") Actual Results: 59 Expected Results: 00 Reproducible: Always User Profile Reset: Yes Additional Info: 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 | -- You are receiving this mail because: You are the assignee for the bug.