diff options
| author | Steve Fanning <stevemfanning@yahoo.co.uk> | 2021-01-31 01:09:50 +0100 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2021-01-31 17:33:26 +0100 |
| commit | c0f70b871b7a558f5f7de355e6e18636cd90ac93 (patch) | |
| tree | 93c6a2d3be24a7bc872293cc6fe36df55f219d19 /source/text/scalc | |
| parent | tdf#132643 Translate German section IDs (diff) | |
| download | help-c0f70b871b7a558f5f7de355e6e18636cd90ac93.tar.gz help-c0f70b871b7a558f5f7de355e6e18636cd90ac93.zip | |
The syntax given in the Help file for Calc’s LOGNORM.INV function is incorrect (see Bug 137649). Specifically, the second (“Mean”) and third (“StDev”) arguments are optional rather than required in Calc’s current implementation. If omitted the Mean argument defaults to 0.0 and the StDev argument defaults to 1.0.
Note: The corresponding Excel function’s three arguments are all required (none are optional) and so one possible outcome of Bug 137649 is for Calc to be updated to match this behaviour for interoperability. However, we do not know if or when this might happen and so, in the meantime, I propose to update the Help to more accurately reflect Calc’s current behaviour.
The change affects only one file, 04060183.xhp.
Change-Id: I69934a8123d5de41007bc4dfca1cbc478ed963a6
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110150
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc')
| -rw-r--r-- | source/text/scalc/01/04060183.xhp | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/source/text/scalc/01/04060183.xhp b/source/text/scalc/01/04060183.xhp index cc5039eefc..b4eb4c6f25 100644 --- a/source/text/scalc/01/04060183.xhp +++ b/source/text/scalc/01/04060183.xhp @@ -225,11 +225,11 @@ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3153049" xml-lang="en-US">LOGINV(Number [; Mean [; StDev]])</paragraph> <paragraph role="paragraph" id="par_id3148390" xml-lang="en-US"> -<emph>Number</emph> is the probability value for which the inverse standard logarithmic distribution is to be calculated.</paragraph> +<emph>Number</emph> (required) is the probability value for which the inverse standard logarithmic distribution is to be calculated.</paragraph> <paragraph role="paragraph" id="par_id3149538" xml-lang="en-US"> -<emph>Mean</emph> is the arithmetic mean of the standard logarithmic distribution.</paragraph> +<emph>Mean</emph> (optional) is the arithmetic mean of the standard logarithmic distribution (defaults to 0 if omitted).</paragraph> <paragraph role="paragraph" id="par_id3145355" xml-lang="en-US"> -<emph>StDev</emph> is the standard deviation of the standard logarithmic distribution.</paragraph> +<emph>StDev</emph> (optional) is the standard deviation of the standard logarithmic distribution (defaults to 1 if omitted).</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id3155623" xml-lang="en-US"> <item type="input">=LOGINV(0.05;0;1)</item> returns 0.1930408167.</paragraph> @@ -244,13 +244,13 @@ <paragraph id="par_id290122405814" role="paragraph" xml-lang="en-US">This function is identical to LOGINV and was introduced for interoperability with other office suites.</paragraph> <embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph role="code" id="par_id2901049" xml-lang="en-US">LOGNORM.INV(Number; Mean; StDev)</paragraph> +<paragraph role="code" id="par_id2901049" xml-lang="en-US">LOGNORM.INV(Number [; Mean [; StDev]])</paragraph> <paragraph role="paragraph" id="par_id2901390" xml-lang="en-US"> <emph>Number</emph> (required) is the probability value for which the inverse standard logarithmic distribution is to be calculated.</paragraph> <paragraph role="paragraph" id="par_id2901538" xml-lang="en-US"> -<emph>Mean</emph> (required) is the arithmetic mean of the standard logarithmic distribution.</paragraph> +<emph>Mean</emph> (optional) is the arithmetic mean of the standard logarithmic distribution (defaults to 0 if omitted).</paragraph> <paragraph role="paragraph" id="par_id2901355" xml-lang="en-US"> -<emph>StDev</emph> (required) is the standard deviation of the standard logarithmic distribution.</paragraph> +<emph>StDev</emph> (optional) is the standard deviation of the standard logarithmic distribution (defaults to 1 if omitted).</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id2901623" xml-lang="en-US"> <item type="input">=LOGNORM.INV(0.05;0;1)</item> returns 0.1930408167.</paragraph> |