Bug 137649 - Calc Function Wizard - arguments not correctly described for LOGNORM.INV function
Summary: Calc Function Wizard - arguments not correctly described for LOGNORM.INV func...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Olivier Hallot
Whiteboard: target:7.5.0 target:
Depends on:
Blocks: HelpGaps-NewFeatures
  Show dependency treegraph
Reported: 2020-10-21 10:16 UTC by Steve Fanning
Modified: 2022-11-23 19:55 UTC (History)
0 users

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Steve Fanning 2020-10-21 10:16:09 UTC
Calc's two functions LOGINV and LOGNORM.INV are understood (by code inspection) to execute the same code.

However in the Function Wizard the descriptions of the function's arguments are different. In the case of LOGINV, the Mean and STDEV arguments are marked as optional. In the case of LOGNORM.INV, those two parameters are marked as required.

Experimentation with Calc leads to the conclusion that both arguments are indeed optional for both functions, and so the text on the Function Wizard is misleading for LOGNORM.INV.

The associated help page is also misleading.

Steps to Reproduce:
Open Function Wizard and view parameter descriptions for both functions.

Actual Results:
See above.

Expected Results:
See above.

Reproducible: Always

User Profile Reset: No

Additional Info:
Version: (x64)
Build ID: 7cbcfc562f6eb6708b5ff7d7397325de9e764452
CPU threads: 6; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-US
Calc: threaded
Comment 1 Olivier Hallot 2022-06-27 13:43:19 UTC
LOGNORM.INV is an implementation of the Microsoft homonym function, as indicated the the Help with namespace COM.MICROSOFT.LOGNORM.INV

Doc source for Microsoft

Help page for LibreOffice LOGNORM.INV

LOGINV is an ODFF function.

The function wizard is correct on required and optional arguments of the 2 functions (even if the internal code is the same).

The Help page must be corrected to reflect this difference.
Comment 2 Commit Notification 2022-06-28 12:50:48 UTC
Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":


tdf#137649 Fix LOGNORM.INV optional arguments
Comment 3 Commit Notification 2022-06-28 13:27:44 UTC
Olivier Hallot committed a patch related to this issue.
It has been pushed to "libreoffice-7-4":


tdf#137649 Fix LOGNORM.INV optional arguments
Comment 4 Martin Srebotnjak 2022-11-23 19:52:06 UTC
Can we close this as RESOLVED - FIXED?