Bug 163365 - Add error description text to the formula wizard
Summary: Add error description text to the formula wizard
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (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-10-09 14:13 UTC by Victor K.
Modified: 2024-11-26 07:00 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
screenshot (55.07 KB, image/jpeg)
2024-10-09 14:13 UTC, Victor K. 		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 Victor K. 2024-10-09 14:13:50 UTC 
Created attachment 196985 [details]
screenshot

=DATEDIF("2024-01-01"; "1859-01-01"; "y") return error 502 with all parameters marked as correct (see screenshot)

Maybe need return  -165 or need error massage improvments
Comment 1 Mike Kaganski 2024-10-09 14:31:56 UTC 
This is not a bug.

1. The function is *documented* [1], that "End date must be later, than Start date".
2. The error codes are documented [2], and error 502 is "Function argument is not valid" (and "Error: Invalid argument" will be displayed in the status bar, if you have this formula in the current cell).

An enhancement could be to show that "Invalid argument" string in the wizard, too. Setting this enhancement to NEW.

[1] https://help.libreoffice.org/latest/en-US/text/scalc/01/func_datedif.html?DbPAR=CALC
[2] https://help.libreoffice.org/latest/en-US/text/scalc/05/02140000.html?DbPAR=CALC