Exporting to .xlsx the spreadsheet functions ACOT, ACOTH, COT, COTH, CSC, CSCH, SEC and SECH are wrongly written as ATAN, ATANH, TAN, TANH, SIN, SINH, COS and COSH. This was not the case in 3.6.x
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.