https://bugs.documentfoundation.org/show_bug.cgi?id=151183
Bug ID: 151183
Summary: DATE spreadsheet function gives unexpected results for
small year values, different from Excel
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
In Calc:
=DATE(6;1;-2)
gives 2005-12-29
In Excel the same function gives 1905-12-29.
ODFF [1] does not specify that the function depends on HOST-NULL-YEAR.
[1]
https://docs.oasis-open.org/office/OpenDocument/v1.3/OpenDocument-v1.3-part4-formula.html#DATE
--
You are receiving this mail because:
You are the assignee for the bug.
