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 treegraph
 
Reported: 2021-09-23 19:01 UTC by Mike Kaganski
Modified: 2024-05-02 05:45 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

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
Comment 3 QA Administrators 2024-05-02 03:15:18 UTC Comment hidden (obsolete)
Comment 4 Mike Kaganski 2024-05-02 05:45:18 UTC
Still repro using Version: 24.2.3.1 (X86_64) / LibreOffice Community
Build ID: fc604d5980a783e74808a001f1918a603d920494
CPU threads: 24; OS: Windows 10.0 Build 22631; UI render: default; VCL: win
Locale: en-GB (ru_RU); UI: en-GB
Calc: CL threaded