Bug Hunting Session
Bug 66581 - XLSX embedded OLE objects do not get imported (just icons, not clickable)
Summary: XLSX embedded OLE objects do not get imported (just icons, not clickable)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.3.3 release
Hardware: x86-64 (AMD64) Windows (All)
: highest major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 128162 (view as bug list)
Depends on:
Blocks: OLE-Objects XLSX
  Show dependency treegraph
 
Reported: 2013-07-04 09:53 UTC by squeezechart
Modified: 2019-10-17 03:06 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:


Attachments
XLSX spreadsheet (2.77 MB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2013-07-04 10:20 UTC, squeezechart
Details
XLS Format imports correctly (webM removed) (316.50 KB, application/vnd.ms-excel)
2014-10-01 06:50 UTC, Luke
Details
Example Excel 2016 file showing the issue (42.93 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-02-19 19:56 UTC, Luke
Details
DOCX version of file correctly imports (25.88 KB, application/vnd.openxmlformats-officedocument.wordprocessingml.document)
2019-02-19 19:59 UTC, Luke
Details

Note You need to log in before you can comment on or make changes to this bug.
Description squeezechart 2013-07-04 09:53:53 UTC
When opening an XLSX in Calc with embedded objects, those objects do not get imported properly. There's a rectangle showing the position where the object is but you cannot open it (LibreOffice 4.0.3.3) or a colored icon of that object with a rectangle is visible (LibreOffice 4.1).

Expected behaviour: Double-clicking on that object will open it.

Looking inside the .ODS, objects have not been stored..
Comment 1 squeezechart 2013-07-04 10:20:00 UTC
Created attachment 82015 [details]
XLSX spreadsheet
Comment 2 Jacques Guilleron 2013-07-04 12:32:14 UTC
Hi,

Same results as you when trying to open embedded-objects.xlsx. But with .xls format, this work. Can you try that way?

Have a nice day,

Jacques
Comment 3 squeezechart 2013-07-05 14:41:09 UTC Comment hidden (obsolete)
Comment 4 Jacques Guilleron 2013-07-05 19:08:22 UTC
Hi squeezechart,

I forgot to tell I produced .xls with MS Starter Kit and it didn't claim anything about write protecting.
Since I reproduce images and not linked objects with LO 4.1.0.1 & Windows 7 Home Premium, I set status to NEW.

Have a nice day,

Jacques
Comment 5 Joel Madero 2014-09-09 15:19:07 UTC Comment hidden (obsolete)
Comment 6 Luke 2014-10-01 06:50:00 UTC
Created attachment 107164 [details]
XLS Format imports correctly (webM removed)
Comment 7 Björn Michaelsen 2014-11-28 09:45:22 UTC Comment hidden (obsolete)
Comment 8 squeezechart 2015-06-10 10:39:07 UTC Comment hidden (obsolete)
Comment 9 Luke 2015-12-09 22:44:05 UTC Comment hidden (obsolete)
Comment 10 squeezechart 2016-09-20 12:44:45 UTC Comment hidden (obsolete)
Comment 11 QA Administrators 2017-11-30 06:25:43 UTC Comment hidden (obsolete)
Comment 12 Luke 2017-12-05 21:56:52 UTC
Still reproducible with Version: 6.1.0.0.alpha0+ (x64)
Build ID: eff70347190a6642fd62a9e0b20e4366c39fbc7a

XLSX does not open. XLS opens the objects.
Comment 13 Luke 2019-02-19 19:19:03 UTC
László is working on this area.
Comment 14 Luke 2019-02-19 19:56:50 UTC
Created attachment 149433 [details]
Example Excel 2016 file showing the issue


Steps to reproduce
1. In Excel, Insert -> Object -> From file
2. Uncheck Link to file
3. Check Display as icon
Comment 15 Luke 2019-02-19 19:59:52 UTC
Created attachment 149434 [details]
DOCX version of file correctly imports
Comment 16 squeezechart 2019-09-27 06:16:01 UTC
Confirm that this bug is still present in LibreOffice 6.3.2.1 and 6.4.0.0
Comment 17 m.a.riosv 2019-10-16 21:15:30 UTC
*** Bug 128162 has been marked as a duplicate of this bug. ***
Comment 18 HJ 2019-10-17 03:06:06 UTC
The object itself will produce a string of formulas 
' =EMBED("package shell object", "") ' 

fro MSO excel, then the object in calc does not have such a formula, affecting the problem of incompatibility from excel objects