Hi Ronnie, Steve Removed from the Help. https://gerrit.libreoffice.org/c/help/+/105531
Thanks Olivier Em 10/11/2020 06:43, Steve Fanning escreveu: > Hello Olivier and Ronnie, > > I agree that the note about _ADD and _EXCEL2003 does not appear to be > relevant to this particular function (DURATION). > > I have added this to our list of help issues to be addressed on > completion of GSOD20. > > I'm looking forward to speaking to you both later. > > Regards, > > Steve > > > On 10/11/2020 08:47, GANDHI RONNIE 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) >> <[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 >>>>> -- Olivier Hallot LibreOffice Documentation Coordinator Rio de Janeiro - Brasil - Local Time: UTC-03:00 LibreOffice – free and open source office suite: https://www.libreoffice.org Respects your privacy, and gives you back control over your data http://tdf.io/joinus -- 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
