Re: Re[5]: [libreoffice-documentation] GSOD 2020 - Possible Error in Help pages

[GANDHI RONNIE]

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
> 
>  the
> 2nd example in "Using regular expressions and nested functions" section the
> regex is about "book" but description states "pen".
>
> Also in POISSON.DIST
> 
>  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 Ins

Re: Re[5]: [libreoffice-documentation] GSOD 2020 - Possible Error in Help pages

[GANDHI RONNIE]

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
>> 
>>  the
>> 2nd example in "Using regular expressions and nested functions" section the
>> regex is about "book" but description states "pen".
>>
>> Also in POISSON.DIST
>> 
>>  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 probabilit