[Libreoffice-bugs] [Bug 144692] New: YEAR() / MONTH() / DAY() give results inconsistent with entered/displayed dates

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 144692
           Summary: YEAR() / MONTH() / DAY() give results inconsistent
                    with entered/displayed dates
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com

Check:

=YEAR("1581-12-22")
=MONTH("1581-12-22")
=DAY("1581-12-22")

The expected results are: 1581, 12, 22.
The actual results are: 1582, 1, 1.

The problem is the use of Julian calendar for date recognition and formatting
for dates prior to 1582-10-15, but use of proleptic Gregorian for
YEAR/MONTH/DAY.

-- 
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/20210924/209e467e/attachment.htm>