Bug 98077 - When files are embedded (OLE) and associated with Excel, internally associate them with Calc instead
Summary: When files are embedded (OLE) and associated with Excel, internally associate...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Desktop-Integration
  Show dependency treegraph
Reported: 2016-02-22 11:39 UTC by chrissc.humbert
Modified: 2023-09-28 11:55 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Bug (8.79 KB, image/png)
2016-02-24 08:27 UTC, chrissc.humbert
Navigator View (14.41 KB, image/png)
2016-02-24 08:28 UTC, chrissc.humbert
Sample file with issue (2.14 MB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2016-02-25 20:45 UTC, chrissc.humbert

Note You need to log in before you can comment on or make changes to this bug.
Description chrissc.humbert 2016-02-22 11:39:11 UTC

On a weekly basis I receive file (.xlsx)  quite complex with multi sheets and tables on each of those sheets and all OLE (Excel file embedded) appear only as image and are not event listed when I am going to the Navigator

I am on Ubuntu 15.10

I do not know how I can send the file because there are some sensible information and by removing them and saving it I am afraid it will lose information eventually necessary for investigations

For the record it has been the case for all the versions of Libre Office I have had so far.

Comment 1 m.a.riosv 2016-02-24 03:19:24 UTC
Hi @chrissc,

I'm not sure, but maybe the file was created in windows with the OLE object associated to a different program than LibreOffice that you have not in Ubuntu.
Comment 2 chrissc.humbert 2016-02-24 08:27:36 UTC
Created attachment 122934 [details]
Comment 3 chrissc.humbert 2016-02-24 08:28:04 UTC
Created attachment 122935 [details]
Navigator View
Comment 4 chrissc.humbert 2016-02-24 08:29:22 UTC

The file is an Excel file containing other excel files. Everything was created on Windows platform.

Kind Regards
Comment 5 m.a.riosv 2016-02-24 23:48:38 UTC
I can only suppose you have not installed the application that must open the OLE object.
Comment 6 chrissc.humbert 2016-02-25 08:22:34 UTC
Hello @m.a.riosv

Please read carefully what is written!

This an excel file with embedded excel files in it. 
I am opening it with Libre Office and Libre Office is able to open excel files 

I deeply hope this is clearer...

Comment 7 m.a.riosv 2016-02-25 10:53:02 UTC
The application for open the embedded file, if I'm not wrong is the application selected when the OLE was created, than can have nothing to do with LibreOffice.
Comment 8 chrissc.humbert 2016-02-25 11:00:25 UTC
So you are saying if the OLE Object is created with Excel then we cannot open it in LibreOffice?

I am missing something here in the logic

Libre office is able to open Excel files

So my point is my colleague create Excel file Excel1.xls with Excel
He is also creating Excel2.xls with Excel

He is embedding Excel2 in Excel1 as OLE object

And he is sending me Excel1 (with embedded Excel 2 as OLE object).

I am opening Excel1 in my LibreOffice, I should be able to open the Excel2 which is embedded in Excel1 no?

For me definitely otherwise I do not see the point in OLE objects

Comment 9 raal 2016-02-25 16:09:38 UTC
Please attach some test file  - the same type of file (xls,xlsx, xlsm) and the same type of embedded OLE object  (xls,xlsx, xlsm). Thanks.
Comment 10 chrissc.humbert 2016-02-25 20:45:57 UTC
Created attachment 122996 [details]
Sample file with issue


As requested. The important sheet is the one labelled Future Changes

Comment 11 chrissc.humbert 2016-04-11 09:33:02 UTC
Hello Just tested with last version
Build ID: 1:5.1.2~rc2-0ubuntu1~wily0

Still the same issue

Kind Regards
Comment 12 Buovjaga 2016-04-24 17:09:02 UTC

I guess we should be so bold to make the decision to capture the Excel association to Calc.. but I think it should happen on the fly and not altering the modified file as otherwise you would be breaking the files for the people who sent them to you!

This is more of a feature request than a bug, though.

Adding needAdvice so devs might review the feasibility of the idea.

Arch Linux 64-bit, KDE Plasma 5
Build ID: 334599030e7b45153107a3075f9049a7463aac80
CPU Threads: 8; OS Version: Linux 4.5; UI Render: default; 
Locale: fi-FI (fi_FI.UTF-8)
Built on April 22nd 2016
Comment 13 chrissc.humbert 2016-08-17 15:57:53 UTC

Sorry for the delay in my response but for me it is a standard feature when embedding document inside other document..otherwise I do not understand what is called OLE

And still the same issue with version
Comment 14 Xisco Faulí 2016-09-19 15:29:44 UTC Comment hidden (obsolete)
Comment 15 Mike Kaganski 2023-09-28 11:31:26 UTC
I very much suspect that this is a duplicate of bug 104065, fixed by Caolan in 2017. I can't test on Linux ATM, could someone check and close if it works? Thanks.
Comment 16 Buovjaga 2023-09-28 11:42:22 UTC
(In reply to Mike Kaganski from comment #15)
> I very much suspect that this is a duplicate of bug 104065, fixed by Caolan
> in 2017. I can't test on Linux ATM, could someone check and close if it
> works? Thanks.

I opened attachment 122996 [details], sheet Future Changes, double-clicked on the Excel icons, but nothing happened.

Version: (X86_64) / LibreOffice Community
Build ID: 60(Build:2)
CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded

Version: (X86_64) / LibreOffice Community
Build ID: f8e591ab9182e0a61c4ae5b8f77b166fcaeaa877
CPU threads: 2; OS: Windows 10.0 Build 22621; UI render: default; VCL: win
Locale: en-US (en_FI); UI: en-US
Calc: threaded
Comment 17 Mike Kaganski 2023-09-28 11:42:37 UTC
(In reply to Mike Kaganski from comment #15)

On the other hand: on Windows, with MS Excel installed, attachment 122996 [details] opens, but the icons on "Future Changes" sheet are just drawings, not openable even there. So likely the sample is useless... possibly got corrupt when re-saved by LibreOffice 5.1.
Comment 18 Mike Kaganski 2023-09-28 11:55:47 UTC
So, what is needed here:

1. Either a working sample;
2. Or a test by chrissc.humbert.

In the absence of this information, the NEEDINFO would eventually expire, and it will autoclose, which would be OK, since otherwise it's not actionable.