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]
<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
