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
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.
Created attachment 122934 [details] Bug
Created attachment 122935 [details] Navigator View
Hello The file is an Excel file containing other excel files. Everything was created on Windows platform. Kind Regards
I can only suppose you have not installed the application that must open the OLE object.
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
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.
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
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.
Created attachment 122996 [details] Sample file with issue Hello As requested. The important sheet is the one labelled Future Changes Thanks
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
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
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
'needsConfirmationAdvise' is only used for unconfirmed bugs. Removing it from this bug. [NinjaEdit]
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.
(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
(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.
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.
Dear chrissc.humbert, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
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