Hello Steve and Olivier, Along with GETPIVOTDATA HLOOKUP's help also has no example section.
Regards, Ronnie Gandhi Undergraduate at Computer Science and Engineering Indian Institute of Technology, Roorkee +91-07874243430 On Mon, Nov 23, 2020 at 4:12 PM Steve Fanning <[email protected]> wrote: > Hello Olivier and Ronnie, > > Thanks for that information. I have made a note on our list of help > issues that the description for the GETPIVOTDATA() function does not > currently include an example of its usage. > > Regards, > > Steve > > > On 23/11/2020 09:21, Olivier Hallot wrote: > > Hi Ronnie > > Pick the example in the Help pages. All is there. > > > > > https://help.libreoffice.org/7.1/en-US/text/scalc/guide/datapilot_createtable.html?DbPAR=CALC#bm_id3148491 > > > > Regards > > Olivier > > > > Em 23/11/2020 03:48, GANDHI RONNIE escreveu: > >> Hello Steve and Olivier, > >> > >> GETPIVOTDATA function seems to be an important one but there are no > >> examples for it on the help page. > >> > >> I'll add some on the wiki pages though. > >> > >> Regards, > >> Ronnie Gandhi > >> Undergraduate at Computer Science and Engineering > >> Indian Institute of Technology, Roorkee > >> +91-07874243430 > >> > >> > >> On Tue, Nov 10, 2020 at 4:39 PM Steve Fanning > >> <[email protected] <mailto:[email protected]>> > wrote: > >> > >> Thanks Ronnie. > >> > >> I'm not even sure the statement is 100% correct if you look across > the > >> full set of Calc functions. For example, in the case of DCOUNT(), > you > >> may omit a value for the 2nd argument but must include a value for > the > >> 3rd argument. > >> > >> I'll give some thought as to how to handle these statements in the > Help. > >> > >> For the wiki, please omit the statements for now. > >> > >> Regards, > >> > >> Steve > >> > >> > >> On 10/11/2020 10:43, GANDHI RONNIE wrote: > >> > 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 > >> <[email protected] <mailto:[email protected]>> 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] <mailto:[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] > >> <mailto:[email protected]>> > >> >>> To: "GANDHI RONNIE" <[email protected] > >> <mailto:[email protected]>> > >> >>> Cc: "Olivier Hallot" <[email protected] > >> <mailto:[email protected]>>; "Documentation > >> >>> Team" <[email protected] > >> <mailto:[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] > >> <mailto:[email protected]>> > >> >>> To: "Steve (GMail)" <[email protected] > >> <mailto:[email protected]>> > >> >>> Cc: "Olivier Hallot" <[email protected] > >> <mailto:[email protected]>>; "Documentation > >> >>> Team" <[email protected] > >> <mailto:[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] <mailto:[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] > >> <mailto:[email protected]>> > >> >>>> To: "Steve (GMail)" <[email protected] > >> <mailto:[email protected]>> > >> >>>> Cc: "Documentation Team" < > [email protected] > >> <mailto:[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] <mailto:[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] > >> <mailto:[email protected]>> > >> >>>>> To: [email protected] > >> <mailto:[email protected]>; "Documentation Team" > >> >>>>> <[email protected] > >> <mailto:[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] > >> <mailto:documentation%[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
