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 <gron...@cs.iitr.ac.in>
> 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: documentation+unsubscr...@global.libreoffice.org
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
