Bug 76949 - FILESAVE: .xlsx new functions are saved without _xlfn. prefix and lead to #NAME? error when reloaded
Summary: FILESAVE: .xlsx new functions are saved without _xlfn. prefix and lead to #NA...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.3.2 rc
Hardware: All All
: highest blocker
Assignee: Eike Rathke
URL:
Whiteboard: target:4.3.0 target:4.2.3 target:7.0.0
Keywords: regression
Depends on:
Blocks: mab4.2
  Show dependency treegraph
 
Reported: 2014-04-02 13:33 UTC by Eike Rathke
Modified: 2020-05-16 21:22 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
simple test case document (11.63 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-04-02 13:33 UTC, Eike Rathke
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Eike Rathke 2014-04-02 13:33:45 UTC
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
Comment 1 Commit Notification 2014-04-02 14:59:31 UTC
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.
Comment 2 Eike Rathke 2014-04-02 15:08:48 UTC
Pending review
for 4-2 at https://gerrit.libreoffice.org/8817
for 4-2-3 at https://gerrit.libreoffice.org/8818
Comment 3 Commit Notification 2014-04-02 16:20:34 UTC
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.
Comment 4 Commit Notification 2014-04-03 09:01:23 UTC
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.
Comment 5 Commit Notification 2020-05-16 21:22:17 UTC
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.