https://bugs.documentfoundation.org/show_bug.cgi?id=167072
Bug ID: 167072
Summary: Calc: Dates in Century Years (e.g., 100, 200, 300, ...
, 1500) Incorrectly Recognized as Leap Years
Product: LibreOffice
Version: 24.8.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
LibreOffice Calc is misinterpreting the leap year rule for century years that
are not divisible by 400. It currently accepts century years 100, 200, 300,
500, 600, 700, 900, 1000, 1100, 1300, 1400, 1500 as leap year, which should be
an invalid date.
Steps to Reproduce:
Type 100-02-29 into a cell (e.g., A1) and press Enter. Repeat this process for
200-02-29, 300-02-29, and so on, up to 1500-02-29 in subsequent cells.
Actual Results:
They are accepted as valid dates.
Expected Results:
Based on the Gregorian calendar rules: "Every year that is exactly divisible by
four is a leap year, except for years that are exactly divisible by 100, but
these centurial years are leap years if they are exactly divisible by 400."
They should be treat as text.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 24.8.3.2 (AARCH64) / LibreOffice Community
Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92
CPU threads: 8; OS: macOS 15.0; UI render: Skia/Metal; VCL: osx
Locale: en-US (en_CN.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
