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: VERIFIED DUPLICATE of bug 124333
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 144478 (view as bug list)
Depends on:
Blocks: OLE-Objects XLSX
  Show dependency treegraph
 
Reported: 2013-07-04 09:53 UTC by squeezechart
Modified: 2022-09-29 06:19 UTC (History)
11 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
Comment 19 An-Kh 2020-11-23 01:25:08 UTC
I guess it is not present in LibreOffice 7.1.0
Someone please confirm..
Comment 20 squeezechart 2020-11-23 09:12:14 UTC
still present in LibreOffice 7.1.0 alpha 1
 - object icons are shown but none of the objects can be opened;
   they are also not present in the ods when saving.
Comment 21 NISZ LibreOffice Team 2021-09-14 11:53:33 UTC
*** Bug 144478 has been marked as a duplicate of this bug. ***
Comment 22 Julien Nabet 2021-09-14 16:56:11 UTC
(In reply to Luke from comment #12)
> Still reproducible with Version: 6.1.0.0.alpha0+ (x64)
> Build ID: eff70347190a6642fd62a9e0b20e4366c39fbc7a
> 
> XLSX does not open. XLS opens the objects.

Indeed, quite unexpected!
+ it works too with doc and docx as you indicated in another comment
so why only xlsx concerned ?
Comment 23 Julien Nabet 2021-09-15 19:21:41 UTC
Eike: any idea what might be the pb here or where to search?
I mean if it works with xls, perhaps it doesn't need much to make it work on xlsx?
Comment 24 Tünde Tóth 2022-09-28 12:31:55 UTC

*** This bug has been marked as a duplicate of bug 124333 ***
Comment 25 NISZ LibreOffice Team 2022-09-29 06:19:27 UTC
Verified in:
Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 48b9cbc742de3f6120986cb6cafc92eb5009da82
CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL threaded