| Summary: | FILESAVE: .xlsx: functions ACOT,ACOTH,COT,COTH,CSC,CSCH,SEC,SECH wrongly written | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Eike Rathke <erack> |
| Component: | Calc | Assignee: | Eike Rathke <erack> |
| Status: | RESOLVED FIXED | ||
| Severity: | critical | Keywords: | regression |
| Priority: | high | ||
| Version: | 4.0.0.2 rc | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | target:4.1.0 target:4.0.1 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
testcase source
testcase exported xlsx old 4.0.0.2 testcase exported xlsx new with change |
||
|
Description
Eike Rathke
2013-01-30 19:54:29 UTC
Or actually in 3.6.x it works only half way because the _xlfn. prefix is missing and the functions can't be read again after re-import. Cause is that for old .xls BIFF export those functions are rewritten using functions known to Excel at that point, substituting op-codes, for example COT(x)=(1/TAN(x)) The rewrite does not happen for OOXML but the op-codes were still substituted. Created attachment 73957 [details]
testcase source
Created attachment 73958 [details]
testcase exported xlsx old 4.0.0.2
Created attachment 73959 [details]
testcase exported xlsx new with change
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=0c7a1b6e10011930b703897073b8d41e94f7d827 resolved fdo#60087 corrected .xlsx export of functions 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-0 as https://gerrit.libreoffice.org/1929 Note: this change needs the change of bug 60043 to cleanly apply, though that is not needed for functionality. Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=0998b52b725688cdd3c8f6e5150e0d74995164d3&h=libreoffice-4-0 resolved fdo#60087 corrected .xlsx export of functions It will be available in LibreOffice 4.0.1. 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. I'll mark this fixed. |