Created attachment 96782 [details] simple test case document New functions not defined in OOXML (e.g. introduced in Excel 2010) are saved without the _xlfn. prefix and when the document is reloaded the functions are not recognized and lead to #NAME? errors when recalculated. For example functions BETA.DIST and CHISQ.DIST and all others implemented in Calc in the mean time. Load attached test case document, save as Excel 2007 .xlsx, reload .xlsx, hit Shift+Ctrl+F9
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=31e4419ac7581aa7864905bcd4ce42e14df6c9bb resolved fdo#76949 correct grammar is GRAM_OOXML 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.
Pending review for 4-2 at https://gerrit.libreoffice.org/8817 for 4-2-3 at https://gerrit.libreoffice.org/8818
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=2dd84cf254f28523c3ff7f014fdbc515e9b89daa&h=libreoffice-4-2 resolved fdo#76949 correct grammar is GRAM_OOXML It will be available in LibreOffice 4.2.4. 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.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-2-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=ce2c62175858a6dd1fc9c5e62904442009177833&h=libreoffice-4-2-3 resolved fdo#76949 correct grammar is GRAM_OOXML It will be available already in LibreOffice 4.2.3. 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.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/909f343f267a45028f58b577179b3e594b430d39 tdf#76949: sc: Add unittest It will be available in 7.0.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.