Hello Steve and Olivier, I found another error in the help pages.
For the DURATION function, there is a pinpoint which is not needed I believe. *The functions whose names end with _ADD or _EXCEL2003 return the same results as the corresponding Microsoft Excel 2003 functions without the suffix. Use the functions without suffix to get results based on international standards.* Do look into it and see if you find it useless as well. Regards, Ronnie Gandhi Undergraduate at Computer Science and Engineering Indian Institute of Technology, Roorkee +91-07874243430 On Mon, Oct 26, 2020 at 2:08 AM Steve (GMail) <[email protected]> wrote: > Ronnie / Olivier, > > As promised I have created an initial list of issues with the help files > that have been noticed so far during the GSOD2020 Functions Wiki work. > > This list can be found in the GSOD2020/WIKI folder in NextCloud, file name > "Help pages - problems noticed during GSOD20.odt". We can discuss these > during our weekly Tuesday meetings as required. > > Ronnie, please have a quick look and see if I've missed any of the issues > that you have raised so far. If you spot any more, please carry on emailing > them to us. I can do a quick filter / check before adding the issue to the > list. > > Regards, > > Steve > > ------ Original Message ------ > From: "Steve (GMail)" <[email protected]> > To: "GANDHI RONNIE" <[email protected]> > Cc: "Olivier Hallot" <[email protected]>; "Documentation > Team" <[email protected]> > Sent: 25/10/2020 13:57:15 > Subject: Re[4]: [libreoffice-documentation] GSOD 2020 - Possible Error in > Help pages > > Hi Ronnie, > > With regards to the MINIFS problem, I agree with you. I propose to keep a > list of these minor changes to the help that are identified during the > GSOD20 work and will discuss with Olivier how best to fix them. > > You are also correct about the POISSON.DIST problem. This will be added > to the list above. However, in this case, there is a slightly more > significant issue - the Function Wizard contains text which indicates that > the parameter is optional when, in fact, it is required. I will raise a bug > report on this. > > Regards, > > Steve > > > ------ Original Message ------ > From: "GANDHI RONNIE" <[email protected]> > To: "Steve (GMail)" <[email protected]> > Cc: "Olivier Hallot" <[email protected]>; "Documentation > Team" <[email protected]> > Sent: 25/10/2020 10:46:58 > Subject: Re: Re[2]: [libreoffice-documentation] GSOD 2020 - Possible Error > in Help pages > > 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
