https://bugs.documentfoundation.org/show_bug.cgi?id=136615
--- Comment #27 from Regina Henschel <[email protected]> --- Hi Eike, you have worked on it. Do the results in LibreOffice match the definitions in upcoming ODF 1.4? The draft of the upcoming ODF 1.4 is in https://github.com/oasis-tcs/odf-tc/tree/master/docs/odf1.4/part4-formula Here an extract: Second = MOD(ROUND(T * 86400) ; 60) Minute = (MOD(ROUND(T * 86400) ; 3600) - Second) / 60 Hour = (MOD(ROUND(T * 86400) ; 86400) - Minute * 60 - Second) / 3600 DAY( DateParam D ); Returns the day portion of D after first rounding (using ROUND()) to the nearest second. MONTH( DateParam D ); Returns the month portion of D after first rounding (using ROUND()) to the nearest second. YEAR( DateParam D ); Returns the year portion of D after first rounding (using ROUND()) to the nearest second. -- You are receiving this mail because: You are the assignee for the bug.
