[Libreoffice-bugs] [Bug 144687] New: ISLEAPYEAR gives FALSE for years displaying Feb 29th

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: mikekaganski at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210923/4b6b385f/attachment.htm>