Bug 60043

Summary: FILESAVE,FILEOPEN: .xlsx: new functions IMCOSH,IMCOT,IMCSC,IMCSCH,IMSEC,IMSECH,IMSINH,IMTAN written as programmatic Add-In names
Product: LibreOffice Reporter: Eike Rathke <erack>
Component: CalcAssignee: Eike Rathke <erack>
Status: RESOLVED FIXED    
Severity: normal    
Priority: medium    
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-29 23:36:09 UTC
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.
Comment 1 Eike Rathke 2013-01-29 23:36:39 UTC
Working on this.
Comment 2 Eike Rathke 2013-01-29 23:52:59 UTC
Created attachment 73887 [details]
testcase source
Comment 3 Eike Rathke 2013-01-29 23:53:35 UTC
Created attachment 73888 [details]
testcase exported xlsx old 4.0.0.2
Comment 4 Eike Rathke 2013-01-29 23:53:59 UTC
Created attachment 73889 [details]
testcase exported xlsx new with change
Comment 5 Not Assigned 2013-01-30 00:00:02 UTC
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.
Comment 6 Eike Rathke 2013-01-30 00:02:27 UTC
Change pending review for 4-0 as https://gerrit.libreoffice.org/1920
Comment 7 Not Assigned 2013-01-30 21:44:54 UTC
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.