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
*** This bug has been marked as a duplicate of bug 103088 ***