Bug 103383 - Help file needs to be updated for the functions WORKDAY.INTL, NETWOKDAYS.INTL, etc.
Summary: Help file needs to be updated for the functions WORKDAY.INTL, NETWOKDAYS.INTL...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
5.2.2.2 release
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard: target:5.3.0
Keywords:
Depends on:
Blocks:
 
Reported: 2016-10-21 11:47 UTC by Chandanathil P. Geevan
Modified: 2021-05-29 23:15 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
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 Chandanathil P. Geevan 2016-10-21 11:47:02 UTC 
Description:
Help file needs to be updated for the functions WORKDAY.INTL, NETWOKDAYS.INTL, etc. The values valid for weekends (Sat&Sun; Sun&Mon, ...) and one-day weekends for 6-day weeks (Sunday-only, ... Sat-only) are not given in the contextual help. Values are 1 to 7; 11 to 17.
Perhaps, there is a need to update help files for the newer versions. 

Steps to Reproduce:
1. Help
2. Time & date functions
3. 

Actual Results:  
Incomplete help. WORKDAY, NETWORKDAYS is included. But, WORKDAY.INTL, NETWORKDAYS.INTL are not included in the help. They are not listed in the Date & Time Functions (local help file)

Expected Results:
WORKDAY.INTL, NETWORKDAYS.INTL should be there. The values 1 to 7 for 2-day weekends (1 for Sat+Sun to 7 for Fri+Sat) and 11 to 17 for 1-day weekends (11 for Sunday only, to 17 for Saturday only).


Reproducible: Always

User Profile Reset: No

Additional Info:
How can I get involved?


User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.143 Safari/537.36
Comment 1 Buovjaga 2016-11-03 11:26:28 UTC 
Confirmed: https://help.libreoffice.org/Calc/Date_and_Time_Functions
Comment 2 Stéphane Guillou (stragu) 2021-05-29 23:15:26 UTC 
This was fixed Chandanathil P. Geevan with:

https://cgit.freedesktop.org/libreoffice/help/commit/?id=b560ca36513ef209b23081dc5b971d30dd60e5f1

Setting target to 5.3.0, same as bug fixed with the same commit: Bug 80439