Bug 103089 - LOGNORMDIST function - 3 parameters in excel, 4 parameters in Calc
Summary: LOGNORMDIST function - 3 parameters in excel, 4 parameters in Calc
Status: RESOLVED DUPLICATE of bug 103088
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-10-10 12:12 UTC by raal
Modified: 2016-10-10 13:01 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description raal 2016-10-10 12:12:49 UTC
Description:
> excel define Lognormdist function as
> LOGNORMDIST(x,mean,standard_dev)
>
> ODFF
> Syntax: LOGNORMDIST( Number x [ ; Number m = 0 [ ; Number s = 1 [ ; Logical
> Cumulative = TRUE() ] ] ] )
>
> Compare:   3 parameters in excel, 4 parameters in Calc


> When I write formula =LOGNORMDIST(0.1,0,1,1)  in Calc and export the file to
> xlsx, then in excel is formula invalid (excel delete the formula and
> preserve value) .

todo:   if 5 arguments are present the export should write LOGNORM.DIST
instead of LOGNORMDIST.


Actual Results:  
> When I write formula =LOGNORMDIST(0.1,0,1,1)  in Calc and export the file to
> xlsx, then in excel is formula invalid (excel delete the formula and
> preserve value) .

Expected Results:

todo:   if 5 arguments are present the export should write LOGNORM.DIST
instead of LOGNORMDIST.


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:49.0) Gecko/20100101 Firefox/49.0
Comment 1 raal 2016-10-10 13:01:48 UTC

*** This bug has been marked as a duplicate of bug 103088 ***