Download it now!
Bug 105036 - xlsx file with huge drawing.xml will not open
Summary: xlsx file with huge drawing.xml will not open
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
Keywords: perf
Depends on:
Blocks: XLSX File-Opening
  Show dependency treegraph
Reported: 2017-01-02 03:39 UTC by Howard Houliston
Modified: 2020-03-23 17:01 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

An xlsx file with four tabs (611.99 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-01-02 03:41 UTC, Howard Houliston

Note You need to log in before you can comment on or make changes to this bug.
Description Howard Houliston 2017-01-02 03:39:31 UTC
1. Attached xlsx file instead of opening sees open progress bar get to about 80% then stop. 
2. Happens if opening attempted via double-click or by starting Calc then using File > Open. 
3. Happens with version in Win10 and version in Linux Mint. 
4. Can be opened with Excel (2010).

Steps to Reproduce:
1.Attempt to open the file in whatever way you choose.

Actual Results:  
Open Progress bar quickly gets to about 80% and stops. Task Manager showed CPU usage had gone from around 30% to 60% but very little disk activity. CPU usage again went down to 30% when Calc was closed.

Expected Results:
Calc should have shown the contents of the spreadsheet

Reproducible: Always

User Profile Reset: No

Additional Info:

User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:50.0) Gecko/20100101 Firefox/50.0
Comment 1 Howard Houliston 2017-01-02 03:41:15 UTC
Created attachment 130081 [details]
An xlsx file with four tabs
Comment 2 Bartosz 2017-01-03 01:00:33 UTC
In that .xlsx document the drawing.xml files are huge (about 350000 lines per sheet).
We should optimize opening of such big files.
Comment 3 QA Administrators 2018-01-04 03:35:37 UTC Comment hidden (obsolete)
Comment 4 Andrew 2018-04-14 06:21:02 UTC
This bug is still present in

Version: (x64)
Build ID: 8f48d515416608e3a835360314dac7e47fd0b821
CPU threads: 4; OS: Windows 6.3; UI render: GL; 
Locale: en-GB (en_GB); Calc: CL
Comment 5 Roman Kuznetsov 2019-02-28 10:09:20 UTC
still repro in

Build ID: c57dc7d41bd62f933cffab6131edb7252606382d
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded