Bug 85059 - FILEOPEN: Document wont load on Windows with LO's default MS embedded objects settings
Summary: FILEOPEN: Document wont load on Windows with LO's default MS embedded objects...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Impress (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All Windows (All)
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:ppt, perf
Depends on: 85364
Blocks: OLE-Objects File-Opening Options-Dialog-Load-Save PPT
  Show dependency treegraph
 
Reported: 2014-10-15 13:19 UTC by SriJanani
Modified: 2024-01-18 03:09 UTC (History)
12 users (show)

See Also:
Crash report or crash signature:


Attachments
Attached MS file (2.18 MB, application/vnd.ms-powerpoint)
2014-10-15 13:19 UTC, SriJanani
Details
CPU details 1 (239.97 KB, image/jpeg)
2014-10-16 05:35 UTC, SriJanani
Details
CPU Details2 (184.89 KB, image/jpeg)
2014-10-16 05:35 UTC, SriJanani
Details
converted pptx with MS Office 2010 (1.90 MB, application/vnd.openxmlformats-officedocument.presentationml.presentation)
2017-05-12 14:06 UTC, paulystefan
Details
perf flamegraph (1.44 MB, application/gzip)
2019-04-28 19:03 UTC, Julien Nabet
Details
Windows Performance Analyzer output (143.53 KB, image/png)
2024-01-18 03:08 UTC, Matt K
Details
Windows Performance Analyzer output 2nd attachment (149.40 KB, image/png)
2024-01-18 03:09 UTC, Matt K
Details

Note You need to log in before you can comment on or make changes to this bug.
Description SriJanani 2014-10-15 13:19:18 UTC
Created attachment 107871 [details]
Attached MS file

Hi,


Facing difficulty in opening huge files no matter if its impres/calc/writer. The base files are created in Ms office(opens within a sec in MS office). Attaching the file. Appreciate your response.

Tested with all the versions of Libre office. Using windows platform.

Thank You,

Regards,
SriJanani
Comment 1 Yousuf Philips (jay) (retired) 2014-10-15 13:51:24 UTC
Hello SriJanani,

I was able to open it on 4.3.3 and master, though it took a bit of time to open, it did open after 2 or so minutes. How long does it normally take for you?
Comment 2 SriJanani 2014-10-15 15:28:34 UTC
It takes more than ten mins to load half through but never opens. We tried with version 4.3.2.2. Pls advice.


Regards 
Srijanani
Comment 3 tommy27 2014-10-15 18:10:46 UTC
@SriJanani
give exact details of your O/S and CPU
Comment 4 SriJanani 2014-10-16 05:35:06 UTC
Created attachment 107910 [details]
CPU details 1
Comment 5 SriJanani 2014-10-16 05:35:42 UTC
Created attachment 107911 [details]
CPU Details2
Comment 6 SriJanani 2014-10-16 05:36:11 UTC
Attached 2 screenshots of different PC.
Comment 7 SriJanani 2014-10-16 11:25:55 UTC
Can you tell me if you opening the same file in windows platform or anyother platform. After too many trys we tried the same file to open with openoffice it opened immediately. Any views on this.

Thank You,

Regards,
SriJanani
Comment 8 Yousuf Philips (jay) (retired) 2014-10-17 09:35:47 UTC
My previous test was on Linux Mint 13 32-bit.

I just tested 3.3.0, 3.6.7, 4.3.2 and master on Windows 7 64-bit and i cancelled trying to open the file after 5 minutes. The loading progress bar goes to around 60% and not any farther. Tried doing a backtrace but with no luck.
Comment 9 SriJanani 2014-10-17 09:48:18 UTC
Hi,

Right we have no clue why we are unable to open. We tried to open the same file in Open office 3.4.1 it opens without any issues.

Thank You,

Regards,
SriJanani
Comment 10 Yousuf Philips (jay) (retired) 2014-10-17 10:30:17 UTC
On Linux:
AOO 4.1: 3 seconds
LO  4.4: > 3 minutes with single core running at 100%

@Michael: Any ideas on how i can track down what is going wrong on Windows.
Comment 11 Yousuf Philips (jay) (retired) 2014-10-17 11:15:33 UTC
Waited 40 minutes to see if the file would open under Windows, but no luck.
Comment 12 SriJanani 2014-10-17 11:33:47 UTC
Even if you wait for an day it wont open..... Even other libre files cannot be opened.

Thank You,

Regards,
SriJanani
Comment 13 Michael Meeks 2014-10-17 18:44:32 UTC
Oh fun - just get a few stack traces during the load; it'll show the problem nicely I guess; odd though - I don't see any huge changes in our automated performance testing, so ... at least our test files are still loading nice & quickly there =) then again - we limit the size of those.

Seems to be spending a lot of time re-saving the embedded objects as ODF etc. and ... Hmm. not good.

Jay - I suspect that changing the defaults:

Tools->Options->Load/Save->Microsoft Office

around embedded objects [ we always convert them - otherwise they will not be editable ;-) - and I think AOO just leaves them as-is ].

This is a horrible false-dichotomy that shouldnt' exist; we should convert them as/when we need to on activation / macro use etc. but ... it is there.

Can you compare AOO with those options set.

Also - is this really a regression ? some big files that have not been optimised are slow - that's not really news =)
Comment 14 Matthew Francis 2014-10-18 05:51:07 UTC
Judging by the debug output, one problem is that we may be spending a long time failing to load referenced smb:// objects. The document appears to contain quite a few such references
Comment 15 Yousuf Philips (jay) (retired) 2014-10-18 09:20:40 UTC
(In reply to Michael Meeks from comment #13)
> Oh fun - just get a few stack traces during the load; it'll show the problem
> nicely I guess; odd though - I don't see any huge changes in our automated
> performance testing, so ... at least our test files are still loading nice &
> quickly there =) then again - we limit the size of those.

The problem here wasnt really the size of the file, so doubt it would effect any of the automated testing. ;D

> Seems to be spending a lot of time re-saving the embedded objects as ODF
> etc. and ... Hmm. not good.
> 
> Jay - I suspect that changing the defaults:
> 
> Tools->Options->Load/Save->Microsoft Office
> 
> around embedded objects [ we always convert them - otherwise they will not
> be editable ;-) - and I think AOO just leaves them as-is ].

Yes OpenOffice has these checkboxes unchecked and after unchecking them on LO, the file opened in 10 to 20 seconds on Windows. But what seems strange is that the file doesnt load on Windows with these checked, but loads on Linux with them checked.

> This is a horrible false-dichotomy that shouldnt' exist; we should convert
> them as/when we need to on activation / macro use etc. but ... it is there.
> 
> Can you compare AOO with those options set.

With checking these options in AOO, the file loads in > 4 minutes on Linux.

> Also - is this really a regression ? some big files that have not been
> optimised are slow - that's not really news =)

Well as this change was introduced in the first release of LO, then i wouldnt consider it a LO regression. :D
Comment 16 SriJanani 2014-10-23 05:52:13 UTC
I did tried to uncheck the embedded options and the files load quickly and accessible. So now how do we conclude the resolution. Please advice.

Thank You,

Regards,
SriJanani
Comment 17 Michael Meeks 2014-10-23 10:02:44 UTC
Well - it's an enhancement really; I hope there is another tracker enhancement for deferring the work here until embedded objects are activated; this whole idea of that setting is a global embarrassment ;-) we should "do it right".

It'd be nice to look for that enhancement to mark this one as being blocked by it  - if you can (?)
Comment 18 Yousuf Philips (jay) (retired) 2014-10-23 11:30:22 UTC
Filed it - bug 85364.
Comment 19 Björn Michaelsen 2014-11-28 09:42:18 UTC Comment hidden (obsolete)
Comment 20 Robinson Tryon (qubit) 2015-12-07 16:24:12 UTC Comment hidden (obsolete)
Comment 21 Telesto 2016-11-25 11:00:16 UTC
Confirming with:
Versie: 5.3.0.0.beta1 
Build ID: 690f553ecb3efd19143acbf01f3af4e289e94536
CPU Threads: 4; Versie besturingssysteem:Windows 6.2; UI Render: standaard; Layout Engine: new; 
Locale: nl-NL (nl_NL); Calc: CL
Comment 22 paulystefan 2017-05-12 14:04:40 UTC
workaround

convert with MS Office (my version 2010) in pptx

than import in LOO (my Version 5.2.7) successful
Comment 23 paulystefan 2017-05-12 14:06:57 UTC
Created attachment 133263 [details]
converted pptx with MS Office 2010

converted pptx  of ppt bug file with MS Office 2010

successful import with LOO 5.2.7
Comment 24 Jack 2017-06-12 10:24:01 UTC
Documents won't load. No visible text or graphics.
Comment 25 Yousuf Philips (jay) (retired) 2017-06-12 19:54:08 UTC
Aron: Maybe one for the weekend. ;D
Comment 26 Xisco Faulí 2017-10-19 15:21:27 UTC
Still reproducible in

Version: 6.0.0.0.alpha0+
Build ID: a1f93eee75450c3ab6bc623bfad4f850260b86d0
CPU threads: 1; OS: Windows 6.1; UI render: default; 
Locale: fr-BE (es_ES); Calc: group
Comment 27 QA Administrators 2018-10-20 02:53:30 UTC Comment hidden (obsolete)
Comment 28 Julien Nabet 2019-04-28 19:03:26 UTC
Created attachment 151057 [details]
perf flamegraph

On pc Debian x86-64 with master sources updated today + enable-symbols and without debug, I could reproduce this.
Comment 29 Buovjaga 2019-09-25 14:12:09 UTC
Still unable to open on Win

Version: 6.4.0.0.alpha0+ (x64)
Build ID: e1b51d4588b4b39592bb94dd5bb90de5e04d061e
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
TinderBox: Win-x86_64@62-TDF, Branch:master, Time: 2019-09-23_09:16:11
Locale: fi-FI (fi_FI); UI-Language: en-US
Calc: threaded
Comment 30 QA Administrators 2021-09-25 03:40:03 UTC Comment hidden (obsolete)
Comment 31 Sophie Sipasseuth 2023-09-25 13:23:34 UTC
Repro, I have just tried to open the biggest file (Attached MS file), and LO has stopped running.

Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: df3b95a39472e18ea8acdaae447b7176e37a9256
CPU threads: 8; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: fr-FR (fr_FR); UI: fr-FR
Calc: threaded
Comment 32 Matt K 2024-01-18 03:08:06 UTC
Created attachment 192024 [details]
Windows Performance Analyzer output

I captured an ETW trace on Windows and it shows an initial attempt at reading "ImportExcel8", but later in the trace (2nd attachment) it spends a lot of time doing export and save operations, which I'm not sure why they would be occurring on a load of a document.
Comment 33 Matt K 2024-01-18 03:09:20 UTC
Created attachment 192025 [details]
Windows Performance Analyzer output 2nd attachment