Download it now!
Bug 106013 - IMCOSH, IMCOT, IMCSC, IMCSCH, IMSEC, IMSECH, IMSINH and IMTAN compatibility
Summary: IMCOSH, IMCOT, IMCSC, IMCSCH, IMSEC, IMSECH, IMSINH and IMTAN compatibility
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX
  Show dependency treegraph
 
Reported: 2017-02-14 21:52 UTC by raal
Modified: 2019-01-23 09:02 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
xlsx file with imtan() function (8.30 KB, application/zip)
2019-01-23 09:02 UTC, Winfried Donkers (retired)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description raal 2017-02-14 21:52:34 UTC
Description:

Downloading the document from Excel Online produced errors upon opening in Calc.

The cause of these opening errors is that Calc does not add '_xlfn.' as a prefix when saving as OOXML, nor does Calc remove the '_xlfn.' prefix when opening an OOXML document.

I think this problem applies to IMCOSH, IMCOT, IMCSC, IMCSCH, IMSEC, IMSECH, IMSINH and IMTAN

Actual Results:  
.

Expected Results:
.


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:51.0) Gecko/20100101 Firefox/51.0
Comment 1 raal 2017-02-14 21:54:48 UTC
Winfried confirmed
Comment 2 Xisco Faulí 2017-10-01 08:45:51 UTC
Dear Winfried Donkers,
This bug has been in ASSIGNED status for more than 3 months without any activity. Resetting it to NEW.
Please assigned it back to yourself if you're still working on this.
Comment 3 Winfried Donkers (retired) 2017-10-02 10:03:25 UTC
This is not a simple problem.
Add-in functions are handled completely different from the other Calc functions.

To fix this bug, a possibility must be created to combine the above handling.
And that is a time consuming task.
Comment 4 Winfried Donkers (retired) 2018-01-22 07:09:05 UTC
I see no easy way (yet) to make Addin functions work as OOXML-function and vice versa.
Comment 5 QA Administrators 2019-01-23 03:48:23 UTC Comment hidden (obsolete)
Comment 6 Winfried Donkers (retired) 2019-01-23 09:00:33 UTC
(In reply to QA Administrators from comment #5)

Problem still present in version 6.1.4.2 (Windows 10).
Comment 7 Winfried Donkers (retired) 2019-01-23 09:02:41 UTC
Created attachment 148543 [details]
xlsx file with imtan() function

Upon opening the xlsx document, the result is shown, but when recalculating an error is reported (unknown function) as _xlfn.IMTAN is not recognised as function.