Re: [libreoffice-documentation] GSOD 2020 - Possible Error in Help pages
Sure Steve thanks. Will do that now.
Regards,
On Thu, 26 Nov 2020, 2:58 pm Steve Fanning,
wrote:
> Hi Ronnie,
>
> Please link both pages to the ODF's WORKDAY function but explain that:
>
> (1) Calc's WORKDAY function does not support the optional Workdays
> argument that is specified in the ODF. Also, with regards to the issues you
> raise concerning the example definitions of the work week, please would
> you note them on the Discussion page for now and I'll look into them when I
> review the page.
>
> (2) Calc's WORKDAY.INTL function swaps the order of the optional Holidays
> and Workdays arguments that are specified in the ODF; it also extends the
> definition of the Workdays argument compared to the ODF. Calc's
> WORKDAY.INTL function is consistent with Excel's function of the same name
> for improved inter-operability.
> Regards,
>
> Steve
>
>
> On 26/11/2020 07:33, GANDHI RONNIE wrote:
>
> For this issue:
>
> WORKDAY.INTL seems linked to WORKDAY of ODF based on the parameters but
> Weekend accepts 1 to 17 or 011 type of string.
>
> So both functions are somehow similar to ODF function WORKDAY. So which one
> to link?
>
>
> The function WORKDAY in help pages and also its implementation has only
> the first 3 parameters whereas ODF section has 4 parameters. Also ODF
> mentions passing {0;0;0;0;0;1;1} or {1;0;0;0;0;0;1} or even this
> {0;0;0;1;1;1;1} as the Holiday parameter which when I tried does not
> change the result.
>
> I have stated that "Calc's implementation of WORKDAY function is not
> strictly in accordance with ODF 1.2." in wiki.
>
> Calc's function works just like MS Excel's function does.
>
> Regards,
> Ronnie Gandhi
> Undergraduate at Computer Science and Engineering
> Indian Institute of Technology, Roorkee
> +91-07874243430
>
>
> Regards,
> Ronnie
>
>
> On Sun, Oct 4, 2020 at 11:35 PM GANDHI RONNIE
>
> wrote:
>
>
> 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
> equivalenthttps://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
Re: [libreoffice-documentation] GSOD 2020 - Possible Error in Help pages
For this issue:
WORKDAY.INTL seems linked to WORKDAY of ODF based on the parameters but
Weekend accepts 1 to 17 or 011 type of string.
So both functions are somehow similar to ODF function WORKDAY. So which one
to link?
> The function WORKDAY in help pages and also its implementation has only
> the first 3 parameters whereas ODF section has 4 parameters. Also ODF
> mentions passing {0;0;0;0;0;1;1} or {1;0;0;0;0;0;1} or even this
> {0;0;0;1;1;1;1} as the Holiday parameter which when I tried does not
> change the result.
>
> I have stated that "Calc's implementation of WORKDAY function is not
> strictly in accordance with ODF 1.2." in wiki.
>
> Calc's function works just like MS Excel's function does.
>
> Regards,
> Ronnie Gandhi
> Undergraduate at Computer Science and Engineering
> Indian Institute of Technology, Roorkee
> +91-07874243430
>
Regards,
Ronnie
>
> On Sun, Oct 4, 2020 at 11:35 PM GANDHI RONNIE
> wrote:
>
>> 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
Re: [libreoffice-documentation] GSOD 2020 - Possible Error in Help pages
Hello Olivier and Steve,
The function WORKDAY in help pages and also its implementation has only the
first 3 parameters whereas ODF section has 4 parameters. Also ODF mentions
passing {0;0;0;0;0;1;1} or {1;0;0;0;0;0;1} or even this {0;0;0;1;1;1;1} as
the Holiday parameter which when I tried does not change the result.
I have stated that "Calc's implementation of WORKDAY function is not
strictly in accordance with ODF 1.2." in wiki.
Calc's function works just like MS Excel's function does.
Regards,
Ronnie Gandhi
Undergraduate at Computer Science and Engineering
Indian Institute of Technology, Roorkee
+91-07874243430
On Sun, Oct 4, 2020 at 11:35 PM GANDHI RONNIE wrote:
> 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
Re: [libreoffice-documentation] GSOD 2020 - Possible Error in Help pages
Hello Olivier and Steve, I believe the SHEET function has error in both ODF section and help pages. The function states that it returns sheet number or name string for the referenced sheet (either by cell or by name area or a sheet name). But I believe it *can only return sheet number not sheet name*. MS Excel's documentation seems to not have that error and Calc's function is also working accordingly. Regards, Ronnie Gandhi Undergraduate at Computer Science and Engineering Indian Institute of Technology, Roorkee +91-07874243430 On Mon, Nov 23, 2020 at 10:43 PM Steve Fanning wrote: > Thanks Ronnie. > > I've added HLOOKUP to our list. > > Regards, > > Steve > > > On 23/11/2020 11:50, GANDHI RONNIE wrote: > > 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 < > stevefann...@libreoffice.org> > > 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 > >>>> 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, > >>>> > Ronn
Re: [libreoffice-documentation] GSOD 2020 - Possible Error in Help pages
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 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 > >> 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 > >> 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 > >> >> > >> >> >
Re: [libreoffice-documentation] GSOD 2020 - Possible Error in Help pages
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 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 > 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)" > >>> To: "GANDHI RONNIE" > >>> Cc: "Olivier Hallot" ; "Documentation > >>> Team" > >>> 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 t
Re: Re[5]: [libreoffice-documentation] GSOD 2020 - Possible Error in Help pages
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 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) > 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)" >> To: "GANDHI RONNIE" >> Cc: "Olivier Hallot" ; "Documentation >> Team" >> 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" >> To: "Steve (GMail)" >> Cc: "Olivier Hallot" ; "Documentation >> Team" >> 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?=CALC=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) >> 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.”. >>> >
[libreoffice-documentation] Issue understanding PROB function
Hello Steve and Olivier, I am having an issue understanding PROB. I tried running the function using details from help and in the same way as MS's counterpart but in Calc it returns a #VALUE! error. Can you point out the reason for the same since I am unable to get any legit numerical result till now. [image: error_prob.png] Regards, 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
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?=CALC=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) 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" > To: "Steve (GMail)" > Cc: "Documentation Team" > 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) > 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" >> To: documentat...@libreoffice.org; "Documentation Team" >> >> 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
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) 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" > To: documentat...@libreoffice.org; "Documentation Team" > > 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
Re: [libreoffice-documentation] Re: Feeback for docs
Steve, Did u find any issue because I referred help section while editing the contents for Ceiling functions and most or I should say all lines are almost same. Regards, Ronnie On Mon, 7 Sep 2020, 4:34 pm Steve (GMail), wrote: > Hi Ronnie, > > I have had a look at the various CEILING functions and do not propose to > provide detailed comments on the Discussion tabs for these functions. > > However, please could you compare their contents against the Help topics > for each function and update the wording on the wiki pages to match the > Help? The text on the wiki is currently inaccurate in some instances. > > The Help information for all CEILING and FLOOR functions was thoroughly > reviewed and updated quite recently and should be accurate. > > Regards, > > Steve > > -- Original Message -- > From: "GANDHI RONNIE" > To: "stevemfanning...@gmail.com" > Sent: 06/09/2020 18:34:40 > Subject: Feeback for docs > > >Hello Steve, > > > >I am receiving email notification for all the comments that you are > >giving on the wiki page. > > > >I'll let you complete it and meanwhile I'll start mending it. > > > >Take your time. > > > >Regards, > >Ronnie > > > > > >-- > >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
Re: [libreoffice-documentation] Please give your feedback for this document edit
Hello Olivier, Steve and all, I have completed the first 23 Mathematics functions in alphabetical order from this page: https://wiki.documentfoundation.org/Documentation/Calc_Functions/Find_By_Category 1. ABS <https://wiki.documentfoundation.org/Documentation/Calc_Functions/ABS> 2. ACOS <https://wiki.documentfoundation.org/Documentation/Calc_Functions/ACOS> 3. ACOSH <https://wiki.documentfoundation.org/Documentation/Calc_Functions/ACOSH> 4. ACOT <https://wiki.documentfoundation.org/Documentation/Calc_Functions/ACOT> 5. ACOTH <https://wiki.documentfoundation.org/Documentation/Calc_Functions/ACOTH> 6. AGGREGATE <https://wiki.documentfoundation.org/Documentation/Calc_Functions/AGGREGATE> 7. ASIN <https://wiki.documentfoundation.org/Documentation/Calc_Functions/ASIN> 8. ASINH <https://wiki.documentfoundation.org/Documentation/Calc_Functions/ASINH> 9. ATAN <https://wiki.documentfoundation.org/Documentation/Calc_Functions/ATAN> 10. ATAN2 <https://wiki.documentfoundation.org/Documentation/Calc_Functions/ATAN2> 11. ATANH <https://wiki.documentfoundation.org/Documentation/Calc_Functions/ATANH> 12. BITAND <https://wiki.documentfoundation.org/Documentation/Calc_Functions/BITAND> 13. BITLSHIFT <https://wiki.documentfoundation.org/Documentation/Calc_Functions/BITLSHIFT> 14. BITOR <https://wiki.documentfoundation.org/Documentation/Calc_Functions/BITOR> 15. BITRSHIFT <https://wiki.documentfoundation.org/Documentation/Calc_Functions/BITRSHIFT> 16. BITXOR <https://wiki.documentfoundation.org/Documentation/Calc_Functions/BITXOR> 17. CEILING <https://wiki.documentfoundation.org/Documentation/Calc_Functions/CEILING> 18. CEILING.MATH <https://wiki.documentfoundation.org/Documentation/Calc_Functions/CEILING.MATH> 19. CEILING.PRECISE <https://wiki.documentfoundation.org/Documentation/Calc_Functions/CEILING.PRECISE> 20. CEILING.XCL <https://wiki.documentfoundation.org/Documentation/Calc_Functions/CEILING.XCL> 21. COLOR <https://wiki.documentfoundation.org/Documentation/Calc_Functions/COLOR> 22. COMBIN <https://wiki.documentfoundation.org/Documentation/Calc_Functions/COMBIN> 23. COMBINA <https://wiki.documentfoundation.org/Documentation/Calc_Functions/COMBINA> These are the functions that I have worked on. I hope you like them and you can comment in the discussion section. I'll look into each one of them and besides these I am currently working to finish the first column by today 4 remain. Also I want to ask about the CONVERT_OOO <https://wiki.documentfoundation.org/Documentation/Calc_Functions/CONVERT_OOO> function. It seems quite shady as it states it can convert from one measurement to another. If so what all measurements it supports as help page only shows euro type of currency conversion but it says that better to use EUROCONVERT so what are the ranging applications and what is it's excel equivalent? Since it was my first week I was a bit slow but I'll try to finish 7 functions a day making around 42-49 functions a week this way we will have enough time to go through everything once in the end as well. Looking forward to your comments. Regards, On Thu, Sep 3, 2020 at 12:43 AM Ilmari Lauhakangas < ilmari.lauhakan...@libreoffice.org> wrote: > Please always add your signature at the end of your reply by clicking on > the "Signature and timestamp" button between Italics and Link button. > > Consult this: https://www.mediawiki.org/wiki/Help:Talk_pages > > Use : for indenting your replies, so the hierarchy is communicated (see > the help article). > > Ilmari > > Steve (GMail) kirjoitti 2.9.2020 klo 22.08: > > Thanks Olivier, that's fine. > > > > I've put a useless test comment on the ACOS page. We'd better remember > > to initial our comments so that Ronnie knows who has raised each one. > > > > Regards, > > > > Steve > > > > > > -- Original Message -- > > From: "Olivier Hallot" > > To: documentation@global.libreoffice.org > > Sent: 02/09/2020 19:41:23 > > Subject: Re: [libreoffice-documentation] Please give your feedback for > > this document edit > > > >> Hi Steve > >> > >> Each wiki page has (after login) a discussion tab on the top left. > >> > >> It appeared to me a good place to add comments on the page being edited, > >> about the technicalities... > >> > >> Olivier > >> > >> > >> > >> Em 02/09/2020 10:20, Steve (GMail) escreveu: > >>> Hi Ronnie and Olivier, > >>> > >>> During our Monday meeting, I think it was suggested
Re: Re[6]: [libreoffice-documentation] Please give your feedback for this document edit
Yes, I agree. I'll do that as you suggested. Also regarding comments I think Olivier can better tell. Regards, Ronnie On Wed, 2 Sep 2020, 6:55 pm Steve (GMail), wrote: > Hi Ronnie, > > Since you mention the ABS function, I quite like the description of its > argument (because the argument may be a cell reference rather than a > number). The same applies to ACOS and many other functions. > > Hence would the first line of the Arguments section for ACOS read better > as "*Number* is a real number, or a reference to a cell containing that > number, *between -1 and +1.*" > > I assume that you are still planning to change the second line of that > section, as per comments? > > Regards, > > Steve > > > -- Original Message -- > From: "GANDHI RONNIE" > To: "Steve (GMail)" > Cc: "Documentation Team" > Sent: 02/09/2020 13:40:41 > Subject: Re: Re[4]: [libreoffice-documentation] Please give your feedback > for this document edit > > Hello Steve, > > Done! > >> I don't think there's any need to change the wording throughout to >> reflect the name "arccosine". I just thought it would be worth >> mentioning in the Summary sub-section that "inverse trigonometric >> cosine" and "arccosine", and maybe even "arccos", are just different >> names for the same thing. >> >> I have written the code and generating new ones will take a few minutes > only, it just a matter of choice also I have moved them to additional > section. > >> With regards to the GIF, I'm quite happy with the animated version. My >> motivation for raising the comment was a concern that there might be >> more effort involved for you to create the animated GIF compared to the >> static equivalent. As long as it isn't too onerous for you, that's fine. >> >> I think opening in a new tab is better but as far as I know we need to > make that adjustment on Admin Home -> Editing and Plugins, General Settings > Tab, "External links and images" section. Which will open all external > links in the new window. > >> One further general point for discussion, the link to ODF standard >> currently takes the user off our wiki. Should we consider opening the >> ODF page in a new browser window? >> >> I'm looking forward to reviewing some more. >> > I will send some more pages soon. > >> >> Regards, >> >> Steve >> >> >> >> -- Original Message -- >> From: "GANDHI RONNIE" >> To: "Steve (GMail)" >> Cc: "Documentation Team" >> Sent: 02/09/2020 12:14:51 >> Subject: Re: Re[2]: [libreoffice-documentation] Please give your >> feedback for this document edit >> >> >Hello Steve, >> > >> > Thanks for your comments. >> >>As Olivier commented, this update is what we hoped for. >> >> >> >>A few further comments for you to consider: >> >> >> > >> >>SUMMARY SUB-SECTION >> >Thats a good suggestion.Done! >> >>1.Should the summary state that this function calculates the >> >>“principal value”, which is an accepted term I believe. >> > >> >If we see Microsoft's description they have used arccosine everywhere >> >should we also shift to it. I actually continued what already exists >> >but we can consider. What do you say? >> >>2.Similarly, would it be worth mentioning “arc cosine” as well as >> >>“inverse trigonometric cosine”. >> >> >> > >> >>ARGUMENTS SUB-SECTION >> >Done! >> >>1.Since the Syntax sub-section gives the argument name as Number, >> >>I >> >>would suggest that the singular form is used in this subsection too. >> >>2.A very minor point, but is it worth putting a plus sign before >> >>“1”? >> >>3.I would be wary about using the acronym NaN which may not be >> >>familiar to some of our users. Perhaps replace with the more specific >> >>“an invalid numeric value (#NUM!) error”. >> >Actually I should apologise as I somehow skipped this line and actually >> >it doesn't make any sense to me as well. Actually I found that this >> >line is coming from the description section of this >> > >> https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Math/acos#:~:text=acos()%20method%20returns%20a,Math%20is%20not%20a%20constructor). >> >> >webpage but it makes little sense for our users here to be added hence &g
Re: Re[4]: [libreoffice-documentation] Please give your feedback for this document edit
Hello Steve, Done! > I don't think there's any need to change the wording throughout to > reflect the name "arccosine". I just thought it would be worth > mentioning in the Summary sub-section that "inverse trigonometric > cosine" and "arccosine", and maybe even "arccos", are just different > names for the same thing. > > I have written the code and generating new ones will take a few minutes only, it just a matter of choice also I have moved them to additional section. > With regards to the GIF, I'm quite happy with the animated version. My > motivation for raising the comment was a concern that there might be > more effort involved for you to create the animated GIF compared to the > static equivalent. As long as it isn't too onerous for you, that's fine. > > I think opening in a new tab is better but as far as I know we need to make that adjustment on Admin Home -> Editing and Plugins, General Settings Tab, "External links and images" section. Which will open all external links in the new window. > One further general point for discussion, the link to ODF standard > currently takes the user off our wiki. Should we consider opening the > ODF page in a new browser window? > > I'm looking forward to reviewing some more. > I will send some more pages soon. > > Regards, > > Steve > > > > -- Original Message -- > From: "GANDHI RONNIE" > To: "Steve (GMail)" > Cc: "Documentation Team" > Sent: 02/09/2020 12:14:51 > Subject: Re: Re[2]: [libreoffice-documentation] Please give your > feedback for this document edit > > >Hello Steve, > > > > Thanks for your comments. > >>As Olivier commented, this update is what we hoped for. > >> > >>A few further comments for you to consider: > >> > > > >>SUMMARY SUB-SECTION > >Thats a good suggestion.Done! > >>1.Should the summary state that this function calculates the > >>“principal value”, which is an accepted term I believe. > > > >If we see Microsoft's description they have used arccosine everywhere > >should we also shift to it. I actually continued what already exists > >but we can consider. What do you say? > >>2.Similarly, would it be worth mentioning “arc cosine” as well as > >>“inverse trigonometric cosine”. > >> > > > >>ARGUMENTS SUB-SECTION > >Done! > >>1.Since the Syntax sub-section gives the argument name as Number, > >>I > >>would suggest that the singular form is used in this subsection too. > >>2.A very minor point, but is it worth putting a plus sign before > >>“1”? > >>3.I would be wary about using the acronym NaN which may not be > >>familiar to some of our users. Perhaps replace with the more specific > >>“an invalid numeric value (#NUM!) error”. > >Actually I should apologise as I somehow skipped this line and actually > >it doesn't make any sense to me as well. Actually I found that this > >line is coming from the description section of this > > > https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Math/acos#:~:text=acos()%20method%20returns%20a,Math%20is%20not%20a%20constructor). > > >webpage but it makes little sense for our users here to be added hence > >I have removed it. > >>4.Apologies but I do not know what the last sentence really means > >>(“Because ACOS is a static method of Math, you always use it as > >>Math”). > >> > >Thanks > >>EXAMPLES SUB-SECTION > >>1.I think the format looks great. > >Done > >>2.In description for third and fourth examples, radian and degree > >>should both be plural. > >>3.In description for fourth example, insert “by” before 180/PI(). > >>4.In description for fifth example, again I would not bother with > >>the NaN acronym. So maybe change “error (NaN)” to “an error”. Also I > >>suspect you could safely delete “which is between -1 and 1” as it is > >>already been stated. > > > >About this as I earlier mentioned we don't aim at creating such gifs > >for all purposes but it will be fine for some trigonometric and > >statistical the distributions ones. Otherwise if you see I have edited > >ABS function as well but I didn't care about adding a gif or even an > >image there. Also Olivier seem to like this one here. > >>5.A point for discussion – is the dynamic GIF appropriate for > >>functions like this or is animation unnecessary for such a simple > >>function? Would a static GIF con
Re: Re[2]: [libreoffice-documentation] Please give your feedback for this document edit
Steve, If you believe that gif isn't needed then we can have simple png for these functions and only in a special case we will opt for gifs? Regards, Ronnie On Wed, Sep 2, 2020 at 4:44 PM GANDHI RONNIE wrote: > Hello Steve, > > Thanks for your comments. > >> As Olivier commented, this update is what we hoped for. >> >> A few further comments for you to consider: >> >> > >> SUMMARY SUB-SECTION >> > Thats a good suggestion.Done! > >> 1.Should the summary state that this function calculates the >> “principal value”, which is an accepted term I believe. >> > > If we see Microsoft's description they have used arccosine everywhere > should we also shift to it. I actually continued what already exists but we > can consider. What do you say? > >> 2.Similarly, would it be worth mentioning “arc cosine” as well as >> “inverse trigonometric cosine”. >> >> > >> ARGUMENTS SUB-SECTION >> > Done! > >> 1.Since the Syntax sub-section gives the argument name as Number, I >> would suggest that the singular form is used in this subsection too. >> 2.A very minor point, but is it worth putting a plus sign before >> “1”? >> 3.I would be wary about using the acronym NaN which may not be >> familiar to some of our users. Perhaps replace with the more specific >> “an invalid numeric value (#NUM!) error”. >> > Actually I should apologise as I somehow skipped this line and actually it > doesn't make any sense to me as well. Actually I found that this line is > coming from the description section of this > https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Math/acos#:~:text=acos()%20method%20returns%20a,Math%20is%20not%20a%20constructor). > webpage but it makes little sense for our users here to be added hence I > have removed it. > >> 4.Apologies but I do not know what the last sentence really means >> (“Because ACOS is a static method of Math, you always use it as Math”). >> >> Thanks > >> EXAMPLES SUB-SECTION >> 1.I think the format looks great. >> > Done > >> 2.In description for third and fourth examples, radian and degree >> should both be plural. > > 3.In description for fourth example, insert “by” before 180/PI(). >> 4.In description for fifth example, again I would not bother with >> the NaN acronym. So maybe change “error (NaN)” to “an error”. Also I >> suspect you could safely delete “which is between -1 and 1” as it is >> already been stated. >> > > About this as I earlier mentioned we don't aim at creating such gifs for > all purposes but it will be fine for some trigonometric and statistical the > distributions ones. Otherwise if you see I have edited ABS function as well > but I didn't care about adding a gif or even an image there. Also Olivier > seem to like this one here. > >> 5.A point for discussion – is the dynamic GIF appropriate for >> functions like this or is animation unnecessary for such a simple >> function? Would a static GIF convey the necessary information >> adequately? >> 6.Another point for discussion – as the GIF covers the whole of the >> function and isn’t really an example, would it be more appropriately >> placed in the Additional details sub-section? >> >> It did. Thanks > >> I hope these thoughts help. And please keep up the good work! >> >> One thing I would like to add is that this was the first one hence I took > reviews to avoid getting in a situation where I am working 4-5 days with > different minds but now since we are on the right track as we discussed in > the meeting I'll send 20-30 function pages for review in the weekend of > your convenience. > > Regards, > Ronnie > -- 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
[libreoffice-documentation] Please give your feedback for this document edit
Hello all, I have edited this Calc function ACOS's wiki page where I made a few changes: 1. Following a tabular example format 2. Added bad case example 3. Added a gif I created myself to avoid copyright issues besides getting benefit of customizing to our needs 4. Adding related functions 5. Linked to corresponding ODF section https://wiki.documentfoundation.org/Documentation/Calc_Functions/ACOS I would be applying similar changes to Calc functions one by one with an exception of Gifs and images only wherever needed. Looking forward to your feedback. Regards, Ronnie -- 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
[libreoffice-documentation] New Season of Docs student
Hello all, I am Ronnie Gandhi, a Computer Science undergraduate Student from IIT Roorkee, India. I have been selected by Olivier and Steve to work on the "Calc Functions Reference and User Guide" project as a technical writer for LibreOffice under the Season of Docs program. I would be happy to share my queries I'll be working on here. Regards, Ronnie -- 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
