https://bugs.documentfoundation.org/show_bug.cgi?id=136615
--- Comment #9 from Mike Kaganski <[email protected]> --- (In reply to Albrecht Müller from comment #8) > There is a truncating convention where the transition from one day to the > next occurs exactly at midnight. This convention is used for example in > 4.11.7 Basis > (https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/ > OpenDocument-v1.3-os-part4-formula.html#__RefHeading__1017922_715980110) > > The other convention is the rounding convention where this transition occurs > half a second earlier. The proposed definitions of the YEAR, MONTH, DAY, > HOUR, MINUTE and SECOND functions use that convention. You put it not as the standard puts it. Specifically, there is a possible ambiguity, but not a clear conflict. Namely, the "truncate" at 4.11.7 is defined as: > truncate(date) truncates any fractional (hours, minutes, seconds) of a date > value and returns the whole date portion. It is not defined in terms of floating-point number, but in terms of fractional part of a date, so the question remains, how the fractions of a date are calculated here, to be discarded. Anyway, everything in comment 8 is unrelated to a specific problem that this issue is dedicated: inconsistency in the *related* set of functions. The interrelations with other functions, if documented, may be arbitrarily complex and still be acceptable. The change in standard is the step toward consistency in one specific part, and improvements must be done step by step. Trying to create noise in each and every issue which mentions "Calc" and "time", just because a fix to that issue does not make the world the ideal place, is not constructive. But yes, this problem is definitely not fixed yet - as the change was only at standard level, not in LibreOffice code. -- You are receiving this mail because: You are the assignee for the bug.
