Exporting to .xlsx the (new since LO 3.6 and now also known to Excel 2013) spreadsheet functions IMCOSH, IMCOT, IMCSC, IMCSCH, IMSEC, IMSECH, IMSINH and IMTAN are written with their programmatic name instead of _xlfn. prefixed names, for example instead of _xlfn.IMSINH(1) it is com.sun.star.sheet.addin.Analysis.getImsinh(1) that during import again results in a #NAME? error. LO 3.6 wrote IMSINH(1), which also was wrong, but could not read it either.
Working on this.
Created attachment 73887 [details] testcase source
Created attachment 73888 [details] testcase exported xlsx old 4.0.0.2
Created attachment 73889 [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=d701e808782f5849f22c112311a9553f08c8d553 resolved fdo#60043 write correct IM* function names 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.
Change pending review for 4-0 as https://gerrit.libreoffice.org/1920
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=f3f092903bfaae0ee27ec56f7a004476e35460e1&h=libreoffice-4-0 resolved fdo#60043 write correct IM* function names 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.