Sure Steve thanks. Will do that now. Regards,
On Thu, 26 Nov 2020, 2:58 pm Steve Fanning, <[email protected]> wrote: > 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]> > <[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 > equivalenthttps://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
