Download it now!
Bug 60043 - FILESAVE,FILEOPEN: .xlsx: new functions IMCOSH,IMCOT,IMCSC,IMCSCH,IMSEC,IMSECH,IMSINH,IMTAN written as programmatic Add-In names
Summary: FILESAVE,FILEOPEN: .xlsx: new functions IMCOSH,IMCOT,IMCSC,IMCSCH,IMSEC,IMSEC...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.0.2 rc
Hardware: All All
: medium normal
Assignee: Eike Rathke
URL:
Whiteboard: target:4.1.0 target:4.0.1
Keywords:
Depends on:
Blocks:
 
Reported: 2013-01-29 23:36 UTC by Eike Rathke
Modified: 2013-01-30 21:55 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
testcase source (10.15 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2013-01-29 23:52 UTC, Eike Rathke
Details
testcase exported xlsx old 4.0.0.2 (4.26 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2013-01-29 23:53 UTC, Eike Rathke
Details
testcase exported xlsx new with change (4.35 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2013-01-29 23:53 UTC, Eike Rathke
Details

Note You need to log in before you can comment on or make changes to this bug.
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.