https://bugs.documentfoundation.org/show_bug.cgi?id=144687
Bug ID: 144687
Summary: ISLEAPYEAR gives FALSE for years displaying Feb 29th
Product: LibreOffice
Version: 3.4.0 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
1. Enter number '-292127' in A1, and format as a date
=> it will show 1100-02-29
2. In B1, put formula '=ISLEAPYEAR(A1)'
=> it will show FALSE
The problem is that the date is before introduction of Gregorian calendar
(1582-10-15); the serial dates from that period are displayed using Julian
calendar, but ISLEAPYEAR uses proleptic Gregorian calendar to determine if the
year is leap.
--
You are receiving this mail because:
You are the assignee for the bug.
