Bug 163199 - Wrong formula description for DATE in formula wizard
Summary: Wrong formula description for DATE in formula wizard
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Function-Wizard
  Show dependency tree / graph
 
Reported: 2024-09-29 10:27 UTC by Andreas Säger
Modified: 2024-12-16 16:59 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
Screenshot (30.81 KB, image/png)
2024-09-29 20:57 UTC, m_a_riosv 		Details
View All 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 Andreas Säger 2024-09-29 10:27:20 UTC 
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.
Comment 1 m_a_riosv 2024-09-29 20:57:44 UTC 
Created attachment 196789 [details]
Screenshot

Reproducible
Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: f7fbf6504fd6190187f6e4d092af880ba8c7bf6a
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded