https://bugs.documentfoundation.org/show_bug.cgi?id=144377
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Status|REOPENED |RESOLVED --- Comment #6 from Mike Kaganski <[email protected]> --- (In reply to buggymcbug from comment #5) > > LOL. It does not depend on "my" definition; it is what standard say, and > > what is implemented in software. > > I'm afraid the standard agrees with me. This part of the spec: > https://datatracker.ietf.org/doc/html/rfc6350#section-4.3.1 The only standard that is discussed here is ODF; you constantly try to bring unrelated matters into discussion; you started mentioning ISO 8601 etc. I mentioned the *implemented* standard - and it is ODF 1.3 currently. The relevant part there is ODF 1.3 part 4 Formula sect. 4.3.3 Date [1]: > Date is a subtype of Number. > Date is represented by an integer value. > A serial date is the expression of a date as the number of days elapsed from > a start date called the epoch. This definition explicitly says that dates, as a data sub-type in spreadsheets implementing ODF, are measured in *days*. They are *not* measured in months, in ISO strings, or in any other unit of your choice. Whenever you enter *anything* that Calc should convert to a date, it *must* convert it to "the number of *days* elapsed from a start date called the epoch". It means that your second argument about false precision is wrong premise, too. Closing NOTABUG. Please don't reopen based on arbitrary citations from unrelated places. Thanks. [1] https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#__RefHeading__1017888_715980110 -- You are receiving this mail because: You are the assignee for the bug.
