[Libreoffice-bugs] [Bug 122158] DAY(), MONTH() and YEAR() functions don't handle Gregorian cut-over
https://bugs.documentfoundation.org/show_bug.cgi?id=122158 Regina Henschel changed: What|Removed |Added CC||phili...@quarta.com.br --- Comment #5 from Regina Henschel --- *** Bug 149040 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 122158] DAY(), MONTH() and YEAR() functions don't handle Gregorian cut-over
https://bugs.documentfoundation.org/show_bug.cgi?id=122158 Regina Henschel changed: What|Removed |Added CC||mikekagan...@hotmail.com --- Comment #4 from Regina Henschel --- *** Bug 144692 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 122158] DAY(), MONTH() and YEAR() functions don't handle Gregorian cut-over
https://bugs.documentfoundation.org/show_bug.cgi?id=122158 Eike Rathke changed: What|Removed |Added Severity|normal |enhancement --- Comment #3 from Eike Rathke --- 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 Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 122158] DAY(), MONTH() and YEAR() functions don't handle Gregorian cut-over
https://bugs.documentfoundation.org/show_bug.cgi?id=122158 --- Comment #2 from Hiromi Kuramoto --- Created attachment 147637 --> https://bugs.documentfoundation.org/attachment.cgi?id=147637=edit attachment 20181218 I tried this reproduce in same way in macOS Sierra. I can checked 10 days gap between 1582-10-15 to 1582-10-04, and =DAY, =MONTH, =YEAR function also show same wrong. Version: 6.1.3.2 Build ID: 86daf60bf00efa86ad547e59e09d6bb77c699acb CPU threads: 4; OS: Mac OS X 10.12.5; UI render: default; Locale: en-US (ja_JP.UTF-8); Calc: group threaded -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 122158] DAY(), MONTH() and YEAR() functions don't handle Gregorian cut-over
https://bugs.documentfoundation.org/show_bug.cgi?id=122158 Oliver Brinzing changed: What|Removed |Added CC||oliver.brinz...@gmx.de --- Comment #1 from Oliver Brinzing --- Created attachment 147634 --> https://bugs.documentfoundation.org/attachment.cgi?id=147634=edit 10 days gap -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 122158] DAY(), MONTH() and YEAR() functions don't handle Gregorian cut-over
https://bugs.documentfoundation.org/show_bug.cgi?id=122158 Eike Rathke changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEW -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs