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: [email protected]
Reporter: [email protected]
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.
