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