Summary: | Using the new STDEV.M and STDEV.P formulas in MS Excel 2010 results in errors in LibreOffice. | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Gorka Navarrete <gorkang> |
Component: | Calc | Assignee: | Winfried Donkers <winfrieddonkers> |
Status: | RESOLVED FIXED | ||
Severity: | enhancement | CC: | rb.henschel, winfrieddonkers |
Priority: | medium | ||
Version: | 3.5.0 Beta2 | ||
Hardware: | x86-64 (AMD64) | ||
OS: | Linux (All) | ||
See Also: |
https://bugs.freedesktop.org/show_bug.cgi?id=70000 https://bugs.freedesktop.org/show_bug.cgi?id=70797 https://bugs.freedesktop.org/show_bug.cgi?id=70798 |
||
Whiteboard: | target:4.2.0 | ||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 70798 | ||
Attachments: | Excel 2010 file showing the error |
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. |
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.