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) <stevemfanning.wh@gmail.com> 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" <gronnie@cs.iitr.ac.in> To: "Steve (GMail)" <stevemfanning.wh@gmail.com> Cc: "Documentation Team" <documentation@global.libreoffice.org> 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) <stevemfanning.wh@gmail.com> 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" <gronnie@cs.iitr.ac.in> To: documentation@libreoffice.org; "Documentation Team" <documentation@global.libreoffice.org> Sent: 04/10/2020 19:05:41 Subject: [libreoffice-documentation] GSOD 2020 - Possible Error in Help pagesHello Olivier and Steve, I could sense an error on the help pages for BETA.INV and BETAINVfunction.The definition of Number is wrong. It states Number to be between StartandEnd 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 thisNumberis wrong. One eg to prove the point is : =BETA.INV(0.5,3,4,3,4) gives3.42140719069071But =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+unsubscribe@global.libreoffice.orgProblems?https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/Posting guidelines + more:https://wiki.documentfoundation.org/NetiquetteList archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
-- To unsubscribe e-mail to: documentation+unsubscribe@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