https://bugs.documentfoundation.org/show_bug.cgi?id=122158
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Severity|normal |enhancement
--- Comment #3 from Eike Rathke <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
