[Libreoffice-bugs] [Bug 122158] DAY(), MONTH() and YEAR() functions don't handle Gregorian cut-over

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|normal                      |enhancement

--- Comment #3 from Eike Rathke <erack at redhat.com> ---
So this is actually not a bug. ODFF even states that "evaluators should use a
proleptic Gregorian system (continuing the years backwards as if the calendar
existed in those years)", see
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018898_715980110

The problem is that the date serial number of a "date cell" usually is
formatted using a locale specific calendar, or even any specified calendar
available for a locale from the number formatter.

To solve this, we'd need

a) proleptic Gregorian (ISO 8601:2004) calendar date formats, e.g. with an
[~ISO] calendar modifier, for which "ISO" is not yet specified in ODF 19.341
number:calendar but seems possible,
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part1.html#__RefHeading__1417544_253892949

b) new spreadsheet functions that obtain the calendar used by the number format
of the referenced cell given as argument, or take a parameter to specify the
calendar; such as CALENDARDAY(), CALENDARMONTH() and CALENDARYEAR()

-- 
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/20181219/80291c54/attachment.html>