Download it now!
Bug 130326 - XLSX: Long time for file opens and using 100% of one core of CPU after opening
Summary: XLSX: Long time for file opens and using 100% of one core of CPU after opening
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks: XLSX
  Show dependency treegraph
 
Reported: 2020-01-31 14:07 UTC by Roman Kuznetsov
Modified: 2020-02-02 00:19 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
XLSX file (1.29 MB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-01-31 14:09 UTC, Roman Kuznetsov
Details
perf flamegraph (160.85 KB, application/x-bzip)
2020-01-31 19:06 UTC, Julien Nabet
Details
Modified sample file without INDIRECT and ranges formula from 10000 to 50 (1.12 MB, application/zip)
2020-02-02 00:19 UTC, m.a.riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Kuznetsov 2020-01-31 14:07:56 UTC
Description:
XLSX: Long time for file opens and using 100% of one core of CPU after opening

Steps to Reproduce:
1. Open file from attach
2. It opens a long time
3. After opening it takes 100% of one core of CPU

I think there are problems with long formulas in D2:G38 range

Actual Results:
Long time for file opens and using 100% of one core of CPU after opening

Expected Results:
A file opens fast and doesn't use 100% of one core of CPU after opening


Reproducible: Always


User Profile Reset: No



Additional Info:
Версия: 7.0.0.0.alpha0+ (x64)
ID сборки: 47c598260a8f07cf3a1e4cab061df3f2d261932c
Потоков ЦП: 4; ОС:Windows 10.0 Build 17763; Отрисовка ИП: GL; VCL: win; 
Локаль: ru-RU (ru_RU); Язык интерфейса: ru-RU
Calc: threaded
Comment 1 Roman Kuznetsov 2020-01-31 14:09:26 UTC
Created attachment 157561 [details]
XLSX file
Comment 2 Roman Kuznetsov 2020-01-31 14:27:04 UTC
Julien, hello. Could you test it problem and (if you can confirm it) make perfgraph :
for opening file process
and
for time after opening (I'm not sure, but possible it can be different problems)
Comment 3 Julien Nabet 2020-01-31 19:06:19 UTC
Created attachment 157567 [details]
perf flamegraph

On pc Debian x86-64 with master sources updated today, I got kindda of hanging at the beginning of loading.
Comment 4 Julien Nabet 2020-01-31 19:07:27 UTC
After 20/30 secs waiting, I stopped the test (Ryzen 2600, 32Gb)
I'll give another try once this first pb will be fixed.
Comment 5 Roman Kuznetsov 2020-01-31 19:18:45 UTC
Noel, possibly you will be interested to look at it
Comment 6 m.a.riosv 2020-02-02 00:19:01 UTC
Created attachment 157586 [details]
Modified sample file without INDIRECT and ranges formula from 10000 to 50

Modifying the sample file without INDIRECT function and ranges in formula from 10000 to 50, the issue still persist. After open I'm not able to do anything on it.