Hi Ronnie,
Please link both pages to the ODF's WORKDAY function but explain that:
(1) Calc's WORKDAY function does not support the optional Workdays
argument that is specified in the ODF. Also, with regards to the issues
you raise concerning the example definitions of the work week, please
would you note them on the Discussion page for now and I'll look into
them when I review the page.
(2) Calc's WORKDAY.INTL function swaps the order of the optional
Holidays and Workdays arguments that are specified in the ODF; it also
extends the definition of the Workdays argument compared to the ODF.
Calc's WORKDAY.INTL function is consistent with Excel's function of the
same name for improved inter-operability.
Regards,
Steve
On 26/11/2020 07:33, GANDHI RONNIE wrote:
For this issue:
WORKDAY.INTL seems linked to WORKDAY of ODF based on the parameters but
Weekend accepts 1 to 17 or 0000011 type of string.
So both functions are somehow similar to ODF function WORKDAY. So which one
to link?
The function WORKDAY in help pages and also its implementation has only
the first 3 parameters whereas ODF section has 4 parameters. Also ODF
mentions passing {0;0;0;0;0;1;1} or {1;0;0;0;0;0;1} or even this
{0;0;0;1;1;1;1} as the Holiday parameter which when I tried does not
change the result.
I have stated that "Calc's implementation of WORKDAY function is not
strictly in accordance with ODF 1.2." in wiki.
Calc's function works just like MS Excel's function does.
Regards,
Ronnie Gandhi
Undergraduate at Computer Science and Engineering
Indian Institute of Technology, Roorkee
+91-07874243430
Regards,
Ronnie
On Sun, Oct 4, 2020 at 11:35 PM GANDHI RONNIE <[email protected]>
wrote:
Hello Olivier and Steve,
I could sense an error on the help pages for BETA.INV and BETAINV
function. The definition of Number is wrong. It states Number to be between
Start and End but actually it is the probability which is associated with
BETA function for other given arguments and the output will be that Number.
Compare it with MS excel equivalent
https://support.microsoft.com/en-us/office/beta-inv-function-e84cb8aa-8df0-4cf6-9892-83a341d252eb
.
Actually out function works the same way but the description of this
Number is wrong.
One eg to prove the point is : =BETA.INV(0.5,3,4,3,4) gives
3.42140719069071
But =BETA.INV(3.5,3,4,3,4) gives Err:502 which infact qualifies the
definition.
Ronnie Gandhi
Undergraduate at Computer Science and Engineering
Indian Institute of Technology, Roorkee
+91-07874243430
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy
