Bug 99690 - FILEOPEN: Calc hangs (100% CPU) on opening xlsx with large drawing1.xml and thousands of textboxes - tbbmalloc.dll
Summary: FILEOPEN: Calc hangs (100% CPU) on opening xlsx with large drawing1.xml and t...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: low normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: haveBacktrace
Depends on:
Blocks: Performance CPU-AT-100%
  Show dependency treegraph
 
Reported: 2016-05-05 10:06 UTC by Aurimas Fišeras
Modified: 2024-04-25 06:39 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Hangs on opening (347.81 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2016-05-05 10:06 UTC, Aurimas Fišeras
Details
a backtrace (12.45 KB, text/plain)
2016-12-11 13:19 UTC, fiftyigfuci_f_mi
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Aurimas Fišeras 2016-05-05 10:06:12 UTC
Created attachment 124856 [details]
Hangs on opening

Open attached file - LibreOffice hangs with 100% CPU.

Tried with LibO 5.1.2.2 on 32-bit Windows, 64-bit Ubuntu.
Also tried with 5.2.0.0.alpha1+ (6943396614bb223e05a9de36e7bbc955ed8e6492) on 64-bit Ubuntu.

Google Docs opens this file in several seconds.
Comment 1 MM 2016-05-05 17:53:59 UTC
Confirmed with v3.3.4 under windows 7 x64.
Confirmed with v5.0.0.0a1 under ubuntu 16.04 x64.

On 3.3.4 it actually takes a couple of mins before the file gets loaded, with the latest version it takes forever and a day.
Comment 2 m_a_riosv 2016-05-08 01:36:33 UTC
Hangs with all version on Win10x64

And hangs firefox opening on google docs, looks as it open but it's only a view, hangs processing, reading fonts.gstatic.com

And Zamzar doesn't produce an readable ods file.
Comment 3 fiftyigfuci_f_mi 2016-12-11 13:19:37 UTC
Created attachment 129497 [details]
a backtrace

I confirmed on both:
Version: 5.2.2.2
Build ID: 1:5.2.2-0ubuntu2
CPU Threads: 2; OS Version: Linux 4.9; UI Render: default; 
Locale: en-US (en_US.UTF-8); Calc: group

(My debug dev build)
Version: 5.4.0.0.alpha0+
Build ID: f35d29c8388744be1f95ec4acfca12eec706911a
CPU Threads: 2; OS Version: Linux 4.9; UI Render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); Calc: group
Comment 4 QA Administrators 2017-12-13 09:28:58 UTC Comment hidden (obsolete)
Comment 5 Aurimas Fišeras 2017-12-13 09:35:02 UTC Comment hidden (obsolete)
Comment 6 Aurimas Fišeras 2017-12-13 12:58:21 UTC Comment hidden (obsolete)
Comment 7 QA Administrators 2018-12-14 03:55:47 UTC Comment hidden (obsolete)
Comment 8 Aurimas Fišeras 2018-12-14 10:28:31 UTC
Still hangs with 1 CPU at 100%:
Versija: 6.3.0.0.alpha0+
Darinio identifikatorius: a4812a5894990f5886765bbd90d039ac0c90bcce
Procesoriaus gijos: 4; OS:Linux 4.18; Sąsajos pateikimas: numatytasis; VCL: gtk3; 
Lokalė: lt-LT (lt_LT.UTF-8); UI-Language: lt-LT
Calc: threaded

And:
Versija: 6.1.3.2
Darinio identifikatorius: 1:6.1.3-0ubuntu7
Procesoriaus gijos: 4; OS:Linux 4.18; Sąsajos pateikimas: numatytasis; VCL: gtk3; 
Lokalė: lt-LT (lt_LT.UTF-8); Calc: group threaded
Comment 9 Timur 2018-12-14 17:09:15 UTC
XLSX has a large 22 MBytes drawing1.xml in sheet1, with 23.593 empty TextBoxes.
Excel not responding when tried to delete one.
Comment 10 Aurimas Fišeras 2020-06-25 09:20:18 UTC
Versija: 6.4.4.2
Darinio identifikatorius: 1:6.4.4-0ubuntu1
Procesoriaus gijos: 8; OS:Linux 5.4; Sąsajos pateikimas: numatytasis; VCL: gtk3; 
Lokalė: lt-LT (lt_LT.UTF-8); Sąsajos kalba: lt-LT
Calc: threaded

File opens in ~27 seconds, Calc consumes 1.2 GB of RAM. Every operation in Calc is slow, consuming ~100 % of 1 CPU.
However, it is possible to print this file, generate PDF, or extract data (select all → copy → paste special without objects).
Comment 11 QA Administrators 2022-06-26 03:31:54 UTC Comment hidden (obsolete)
Comment 12 Aurimas Fišeras 2022-06-27 08:21:34 UTC
Version: 7.3.4.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 16; OS: Linux 5.18; UI render: default; VCL: gtk3
Locale: lt-LT (lt_LT.UTF-8); UI: lt-LT
Ubuntu package version: 1:7.3.4-0ubuntu0.22.04.1
Calc: threaded

Faster computer than last time.
File opens in ~12 seconds, Calc consumes 1.2 GB of RAM. Every operation in Calc is slow, consuming <100 % of 1 CPU.
However, it is possible to print this file, generate PDF, or extract data (select all → copy → paste special without objects).

Navigator shows 1001 Graphics Objects named „TextBox n“. It is possible to select invisible Graphics objects and do anything with them successfully.