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: libreoffice-bugs@lists.freedesktop.org Reporter: mikekagan...@hotmail.com 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.