Bug 99506 - EDITING: OLE Object: Can't open an object create with a display icon
Summary: EDITING: OLE Object: Can't open an object create with a display icon
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.0 release
Hardware: All Windows (All)
: lowest minor
Assignee: Not Assigned
URL:
Whiteboard: target:5.2.0
Keywords:
Depends on:
Blocks:
 
Reported: 2016-04-26 09:25 UTC by Guillaume Smaha
Modified: 2016-10-25 19:02 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
ODS file with OLE objects for different filetype and methods (229.99 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-04-26 09:25 UTC, Guillaume Smaha
Details
OLE objects created on a computer having Microsoft Office 2007 (54.45 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-04-26 09:26 UTC, Guillaume Smaha
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Guillaume Smaha 2016-04-26 09:25:51 UTC
Created attachment 124642 [details]
ODS file with OLE objects for different filetype and methods

Hi,

The attached ODS file has OLE objects embedded created with 4 different methods.

In the second and the last column (with ICON), it's not possible to open the OLE object for the XLS, ZIP, DOC, PPT file.
The window "Create a package" is opened instead of opening the file.

Steps to reproduce the first and second column:
1. New Calc;
2. Insert -> Objects -> OLE Objects -> Object Type: Further Objects -> Create from File -> "Browse" to select any XLS, PPT, DOC, ... file  -> Check the "Display as icon" checkbox -> Click OK.

If the checkbox "Display as icon" is not checkbox, the OLE object can be opened (first column).

Steps to reproduce the third and fourth column:
1. New Calc;
2. Insert -> Objects -> OLE Objects -> Object Type: Further Objects -> Create New -> Select "Package" in the list -> Check the "Display as icon" checkbox -> Click OK.
3. The window "Create a package" will appear
4. "Browse" to select any XLS, PPT, DOC, ... file -> Click Next -> Click Finish

If the checkbox "Display as icon" is not checkbox, the OLE object can be opened (third column).



This bug can be reproduced on Windows with LibreOffice :
- 4.3.5.2 x86
- 4.3.7.2 x86
- 5.1.3.1 x86
- 5.2.0.0.alpha1



Observation:
If I create an object with a displayed icon (second case) on a computer having Microsoft Office 2007, the OLE object can be opened from LibreOffice but through Excel/Word 2007 instead of LibreOffice.
And on another computer without Microsoft Office 2007, the OLE object will be opened with LibreOffice.
See the attachment tdf2.ods
Comment 1 Guillaume Smaha 2016-04-26 09:26:35 UTC
Created attachment 124643 [details]
OLE objects created on a computer having Microsoft Office 2007
Comment 2 Joel Madero 2016-05-06 15:12:39 UTC
Not confirming but prioritizing.

Minor: Can slow down but won't prevent high quality work;
Lowest This isn't going to affect a lot of people at all
Comment 3 Buovjaga 2016-05-09 10:43:45 UTC
Confirmed already in 3.5

Win 7 Pro 64-bit Version: 5.2.0.0.alpha1+
Build ID: 3d27afd26f7b85c46a7c7d08498000b9dbcea1c8
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2016-05-09_02:42:15
Locale: fi-FI (fi_FI)

3.5.0
Comment 4 Commit Notification 2016-05-24 07:05:03 UTC
Guillaume Smaha committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=2986e54412bbaf95ef768b9ffc18c9a465678337

Fix tdf#99506: Insert OLE object with icon failed

It will be available in 5.2.0.

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.