Hello Steve and Olivier, I found one more useless text in the FV function.
"In the LibreOfficeDev Calc functions, parameters marked as "optional" can be left out only when no parameter follows. For example, in a function with four parameters, where the last two parameters are marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone." Either we add this in all functions with optional parameters which I think is not possible or we remove it from here. What do you guys think? Regards, Ronnie Gandhi Undergraduate at Computer Science and Engineering Indian Institute of Technology, Roorkee +91-07874243430 On Tue, Nov 10, 2020 at 2:17 PM GANDHI RONNIE <gron...@cs.iitr.ac.in> wrote: > 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) <stevemfanning...@gmail.com> > 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)" <stevemfanning...@gmail.com> >> To: "GANDHI RONNIE" <gron...@cs.iitr.ac.in> >> Cc: "Olivier Hallot" <olivier.hal...@libreoffice.org>; "Documentation >> Team" <documentation@global.libreoffice.org> >> 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" <gron...@cs.iitr.ac.in> >> To: "Steve (GMail)" <stevemfanning...@gmail.com> >> Cc: "Olivier Hallot" <olivier.hal...@libreoffice.org>; "Documentation >> Team" <documentation@global.libreoffice.org> >> 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) <stevemfanning...@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" <gron...@cs.iitr.ac.in> >>> To: "Steve (GMail)" <stevemfanning...@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...@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" <gron...@cs.iitr.ac.in> >>>> To: documentat...@libreoffice.org; "Documentation Team" >>>> <documentation@global.libreoffice.org> >>>> 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: >>>> 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 >>>> >>>> -- 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