https://bugs.documentfoundation.org/show_bug.cgi?id=103089
Bug ID: 103089
Summary: LOGNORMDIST function - 3 parameters in excel, 4
parameters in Calc
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: r...@post.cz
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs