https://bugs.documentfoundation.org/show_bug.cgi?id=163199
Bug ID: 163199
Summary: Wrong formula description for DATE in formula wizard
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Documentation
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Help on Calc function DATE:
»... Month is an integer indicating the month.
Day is an integer indicating the day of the month.
If the values for month and day are out of bounds, they are carried over to the
next digit. If you enter =DATE(00;12;31) the result will be 2000-12-31. If, on
the other hand, you enter =DATE(00;13;31) the result will be 2001-01-31.«
whereas, the formula wizard indicates 1-12 and 1-31 as permissible values for
month and day.
The formula wizard is wrong here. DATE can calculate dates from positive and
negative integers.
--
You are receiving this mail because:
You are the assignee for the bug.
