[Libreoffice-bugs] [Bug 144377] Dates are not correctly auto-extrapolated if exclude days

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144377

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|REOPENED                    |RESOLVED

--- Comment #6 from Mike Kaganski <mikekaganski at hotmail.com> ---
(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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210909/c3c2833c/attachment-0001.htm>