Hello Steve and Olivier, I have found some more errors in help pages:
For MINIFS <https://help.libreoffice.org/7.1/en-US/text/scalc/01/func_minifs.html?&DbPAR=CALC&System=UNIX> the 2nd example in "Using regular expressions and nested functions" section the regex is about "book" but description states "pen". Also in POISSON.DIST <https://help.libreoffice.org/7.1/en-US/text/scalc/01/04060184.html?DbPAR=CALC#bm_id2953985> the function says "C" parameter is optional but that is not true. I tried it in Calc. Please look into the above. Regards, Ronnie Gandhi Undergraduate at Computer Science and Engineering Indian Institute of Technology, Roorkee +91-07874243430 On Tue, Oct 20, 2020 at 8:09 PM Steve (GMail) <[email protected]> wrote: > Ronnie / Olivier, > > Section 6.18.37 in the Open Document Format for Office Applications > (OpenDocument) Version 1.2 contains the following statement: “cumulative is > a Logical parameter … If omitted, FALSE() is assumed.”. > > The 7.1 Help description of this function states that “The cumulative > distribution function is the default if no value is specified for this > parameter”. It also states that if cumulative is set to anything other than > FALSE or 0, then you get the cumulative distribution function. Therefore, > there is a discrepancy between the Help description and the ODF. > > Moving on to the software, the following fragment of a spreadsheet > demonstrates its behaviour. (Note: image wont be visible via mailing list) > > > > This shows that the software is defaulting cumulative to 0, in accordance > with the ODF. > > Consequently, it looks to me as if the help page is wrong in this respect. > It should be changed to say that the default is the probability density > function. > > Olivier, if you agree, would you like me to make the change via Gerrit? > > Regards, > > Steve > > > ------ Original Message ------ > From: "GANDHI RONNIE" <[email protected]> > To: "Steve (GMail)" <[email protected]> > Cc: "Documentation Team" <[email protected]> > Sent: 18/10/2020 17:20:43 > Subject: Re: [libreoffice-documentation] GSOD 2020 - Possible Error in > Help pages > > Hello Steve and Olivier, > > I found one more erroneous function in help pages. HYPEGEOMDIST's > description of *cumulative *parameter's last statement is wrong. It > states "The cumulative distribution function is the default if no value is > specified for this parameter." but I tested and by default probability > density function is considered. So changes should be incorporated > accordingly. > > Regards, > Ronnie Gandhi > Undergraduate at Computer Science and Engineering > Indian Institute of Technology, Roorkee > +91-07874243430 > > > On Mon, Oct 5, 2020 at 1:58 PM Steve (GMail) <[email protected]> > wrote: > >> Hi Ronnie, >> >> I agree that the Help page for these two functions could be improved. >> >> I will raise a bug in our Bugzilla system so that the issue can be >> progressed. >> >> Regards, >> >> Steve >> >> >> >> ------ Original Message ------ >> From: "GANDHI RONNIE" <[email protected]> >> To: [email protected]; "Documentation Team" >> <[email protected]> >> Sent: 04/10/2020 19:05:41 >> Subject: [libreoffice-documentation] GSOD 2020 - Possible Error in Help >> pages >> >> >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 >> >> -- 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
