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 > <stevefann...@libreoffice.org <mailto:stevefann...@libreoffice.org>> 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 > <gron...@cs.iitr.ac.in <mailto: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 <mailto: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 > <mailto:stevemfanning...@gmail.com>> > >>> To: "GANDHI RONNIE" <gron...@cs.iitr.ac.in > <mailto:gron...@cs.iitr.ac.in>> > >>> Cc: "Olivier Hallot" <olivier.hal...@libreoffice.org > <mailto:olivier.hal...@libreoffice.org>>; "Documentation > >>> Team" <documentation@global.libreoffice.org > <mailto: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 > <mailto:gron...@cs.iitr.ac.in>> > >>> To: "Steve (GMail)" <stevemfanning...@gmail.com > <mailto:stevemfanning...@gmail.com>> > >>> Cc: "Olivier Hallot" <olivier.hal...@libreoffice.org > <mailto:olivier.hal...@libreoffice.org>>; "Documentation > >>> Team" <documentation@global.libreoffice.org > <mailto: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 <mailto: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 > <mailto:gron...@cs.iitr.ac.in>> > >>>> To: "Steve (GMail)" <stevemfanning...@gmail.com > <mailto:stevemfanning...@gmail.com>> > >>>> Cc: "Documentation Team" <documentation@global.libreoffice.org > <mailto: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 <mailto: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 > <mailto:gron...@cs.iitr.ac.in>> > >>>>> To: documentat...@libreoffice.org > <mailto:documentat...@libreoffice.org>; "Documentation Team" > >>>>> <documentation@global.libreoffice.org > <mailto: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 > <mailto:documentation%2bunsubscr...@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 > >>>>> > -- 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: 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