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: RESOLVED INSUFFICIENTDATA
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: 2024-04-27 03:17 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)
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: 7.6.1.2 (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
7.6.1-1
Calc: threaded

Version: 24.2.0.0.alpha0+ (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.
Comment 19 QA Administrators 2024-03-27 03:14:22 UTC Comment hidden (obsolete)
Comment 20 QA Administrators 2024-04-27 03:17:06 UTC
Dear chrissc.humbert,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp