Bug 144687 - ISLEAPYEAR gives FALSE for years displaying Feb 29th
Summary: ISLEAPYEAR gives FALSE for years displaying Feb 29th
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.0 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency tree / graph
 
Reported: 2021-09-23 19:01 UTC by Mike Kaganski
Modified: 2022-05-02 13:14 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2021-09-23 19:01:00 UTC 
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.
Comment 1 Andreas Heinisch 2021-09-24 09:13:29 UTC 
Ongoing discussion: https://gerrit.libreoffice.org/c/core/+/122545
Comment 2 Xisco Faulí 2021-09-29 09:57:30 UTC 
Moving to NEW