Bug 131538

Summary: FILESAVE DOCX XLSX file embedded as OLE icon does not open in Word
Product: LibreOffice Reporter: NISZ LibreOffice Team <libreoffice>
Component: WriterAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal CC: aron.budea, dgp-mail, ilmari.lauhakangas, nemeth
Priority: medium Keywords: filter:docx
Version: 5.1.0.3 release   
Hardware: All   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=126476
https://bugs.documentfoundation.org/show_bug.cgi?id=126981
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 112976    
Attachments: Example file from Writer
The original file saved by Writer
Screenshot of the problem in Word

Description NISZ LibreOffice Team 2020-03-24 14:50:17 UTC
Created attachment 158942 [details]
Example file from Writer

Attached odt file contains XLSX and XLS file embedded as OLE icon.
When this is saved as DOCX Word cannot open the embedded files, although Writer does open them.


Steps to reproduce:
1.	In Writer choose Insert – Object – OLE Object.
2.	Choose Create from file, select an existing XLSX/XLS file
3.	Check the “Display as icon” box.
4.	The file is inserted as an icon.
5.	Save as DOCX and open in Word

Actual results:
Double clicking on the file in Word gives an error message.

Expected results:
Embedded file is opened by Excel for editing.

LibreOffice details:
Version: 7.0.0.0.alpha0+ (x64)
Build ID: 8e323fcacebad1afe9d867b846722a6b9bf20f78
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win; 
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: CL

Also happens in:
Verzió: 6.0.0.3
Build az.: 64a0f66915f38c6217de274f0aa8e15618924765
CPU szálak: 4; OS: Windows 6.3; Felületmegjelenítés: alapértelmezett; 
Területi beállítások: hu-HU (hu_HU); Calc: CL

Version: 5.1.0.3
Build ID: 5e3e00a007d9b3b6efb6797a8b8e57b51ab1f737
CPU Threads: 4; OS Version: Windows 6.2; UI Render: default; 
Locale: en-US (hu_HU)

Before that only a replacement image was exported.
Comment 1 NISZ LibreOffice Team 2020-03-24 14:53:31 UTC
Created attachment 158943 [details]
The original file saved by Writer
Comment 2 NISZ LibreOffice Team 2020-03-24 14:54:45 UTC
Created attachment 158944 [details]
Screenshot of the problem in Word
Comment 3 Dieter 2020-03-27 08:16:43 UTC
(In reply to NISZ LibreOffice Team from comment #0)
> Created attachment 158942 [details]
> Example file from Writer
> 
> Attached odt file contains XLSX and XLS file embedded as OLE icon.
> When this is saved as DOCX Word cannot open the embedded files, although
> Writer does open them.

I can't confirm it with

Version: 6.3.5.2 (x64)
Build-ID: dd0751754f11728f69b42ee2af66670068624673
CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: threaded

and MS Word 2016
Comment 4 Buovjaga 2020-06-15 18:47:10 UTC
NISZ: are you using MSO 2013 or...?
Comment 5 NISZ LibreOffice Team 2020-06-30 12:36:40 UTC
(In reply to Buovjaga from comment #4)
> NISZ: are you using MSO 2013 or...?

Yes the screenshot is on 2013. Have not checked on newer version.
Comment 6 Dieter 2022-02-05 16:08:34 UTC
NISZ, still reproducible in LO 7.3?
=> NEEDINFO
Comment 7 QA Administrators 2022-08-05 03:32:07 UTC Comment hidden (obsolete)
Comment 8 Aron Budea 2022-08-05 07:32:16 UTC
I have no problem with this in Word / Excel 2013, either.

When ODT is saved as DOCX in LO 7.0.0.3, in Word, when double-clicking the OLE object, the embedded spreadsheet editor view opens within Word.

When performing the same in LO 7.5.0.0.alpha0+ (fc8b757dad5d98f4ba1cd40d03505873128670cd) + Word, the spreadsheet opens separately in Excel, and not in an embedded view.
Comment 9 Gabor Kelemen (allotropia) 2023-01-27 14:06:26 UTC
(In reply to Aron Budea from comment #8)
> I have no problem with this in Word / Excel 2013, either.
> 
> When ODT is saved as DOCX in LO 7.0.0.3, in Word, when double-clicking the
> OLE object, the embedded spreadsheet editor view opens within Word.
> 
> When performing the same in LO 7.5.0.0.alpha0+
> (fc8b757dad5d98f4ba1cd40d03505873128670cd) + Word, the spreadsheet opens
> separately in Excel, and not in an embedded view.

I see the same behavior now in 7.1 (it was open in inline editor in <=7.0, which also changed embedding from icon to content, breaking layout) and newer under Win 10.

Perhaps my old Win8.1 was behaving in interesting ways like in https://bugs.documentfoundation.org/show_bug.cgi?id=138179#c5

Anyhow, let's say this is working fine now.