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...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.0.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Desktop-Integration
  Show dependency treegraph
 
Reported: 2016-02-22 11:39 UTC by chrissc.humbert
Modified: 2019-10-07 12:11 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


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

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
Hello

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.

Thanks
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]
Bug
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
Hello 

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...

KR
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

KR
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

Hello

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

Thanks
Comment 11 chrissc.humbert 2016-04-11 09:33:02 UTC
Hello Just tested with last version
Version: 5.1.2.2
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
Confirmed.

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
Version: 5.2.0.0.alpha1+
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
Hello

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 5.2.0.4
Comment 14 Xisco Faulí 2016-09-19 15:29:44 UTC Comment hidden (obsolete)