Created attachment 54804 [details] Excel 2010 file showing the error The new STDEV.M and STDEV.P formulas in MS Excel 2010 (Spanish Version) are not recognized in LibreOffice. If you create a file in MS Excel 2010 using STDEV.M and STDEV.P formulas and then open that file with LibreOffice, instead of the expected result, it gives a #MACRO? error. See the results for all the available STDEV functions: RESULT FORMULA MS Excel 2010 RESULTING FORMULA LibreOffice #MACRO? DESVEST.M(F2:F7) _xlfn.STDEV.S(F2:F7) #MACRO? DESVEST.P(F2:F7) _xlfn.STDEV.P(F2:F7) 1.87082 DESVEST(F2:F7) STDEVA(F2:F7) 1.70782 DESVESTPA(F2:F7) STDEVPA(F2:F7) 1.87082 DESVEST(F2:F7) STDEV(F2:F7) It happens with both .xls and .xlsx file formats.
Yes, they are not implemented yet. There are more Excel functions missing. Find some comments in http://wiki.services.openoffice.org/wiki/Calc/Drafts/Treatment_of_new_Excel_2010_functions
Winfried Donkers committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=4a122d1e61278debe7e386e3d9f442e68eddba9b fdo#44134 adding Excel 2010 functions STDEV.P and STDEV.S The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Winfried Donkers committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=6a660262e9d1d06f4c0c6c99063e5a966e64d6d6 fdo#44134 fix omission in support of Excel 2010 The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.