Bug 64914 - FILEOPEN: Libreoffice freezes importing a file containing a chart with large data source
Summary: FILEOPEN: Libreoffice freezes importing a file containing a chart with large ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: haveBacktrace, perf
Depends on:
Blocks: Chart
  Show dependency treegraph
Reported: 2013-05-23 12:40 UTC by Xisco Faulí
Modified: 2022-01-07 15:17 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

sample with 66000 points in the chart (1.85 MB, application/vnd.ms-excel)
2013-05-23 12:40 UTC, Xisco Faulí
Callgrind with 5.3 (6.89 MB, application/x-xz)
2016-07-18 18:27 UTC, Buovjaga

Note You need to log in before you can comment on or make changes to this bug.
Description Xisco Faulí 2013-05-23 12:40:08 UTC
Created attachment 79703 [details]
sample with 66000 points in the chart

Description from #i121058 (https://issues.apache.org/ooo/show_bug.cgi?id=121058):
Open the sample file with large chart, it takes too much time on loading, looks like freeze. And sometimes a warning dialog pops up with warning msg "Main memory shortage. Please quit other applications or close some windows before continuing.", click "OK" button on this dialog, then pops up an error dialog and AOO crashes.

AOO solution isn't that good because it only works for numeric data, not for text data. Besides, as Kohei suggested, it should be done in the chart engine, not in calc
Comment 1 Thomas van der Meulen 2013-05-26 08:27:00 UTC
Thank you for your bug report, I can reproduce this bug running libreoffice Version:
Build ID: 3a2c2d2417101e45fe07cfd8358acf2204a98f3 on Mac osx 10.8.3 
and version

Loading does take like 2 minute and I get the spinning wheel on my mac. 
Wen I look at my system use LibreOffice uses 98.9% of my cpu. after loading just 0.2%
Comment 2 Kevin Suo 2014-07-12 14:32:07 UTC
It's the same problem with version May be from Aoo?

I am wondering how this chart was created, as when I was trying to create a chart from data which contains 10K+ rows, it's really slow, and when you try to rezise the chart, calc will freeze.

Also, when attachment 79703 [details] finished loading finally in Calc, if you scroll, there is secious lag/delay. There is a saperate bug report regard this issue: Bug 81230. I added as see also.
Comment 3 QA Administrators 2015-07-18 17:43:01 UTC Comment hidden (obsolete)
Comment 4 Xisco Faulí 2015-07-21 08:14:45 UTC
This issue is still reproducible with Version:
Build ID: 2c39ebcf046445232b798108aa8a7e7d89552ea8.
It took me 3 minutes and 10 seconds to open the file under Window 7
Comment 5 Buovjaga 2016-07-18 09:21:31 UTC
Yeah, freezy, but not entirely. Should probably try a callgrind on Linux later..

Win 7 Pro 64-bit Version:
Build ID: 28ac6fdc11559b58ac62089300aa99530b0b822d
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2016-07-18_02:54:20
Locale: fi-FI (fi_FI); Calc: CL
Comment 6 Buovjaga 2016-07-18 18:27:16 UTC
Created attachment 126287 [details]
Callgrind with 5.3

Callgrind of opening the file an scrolling just a little bit.

Arch Linux 64-bit, KDE Plasma 5
Build ID: ab1b351840160655a9f0caedbb35e9fdf203c5a0
CPU Threads: 8; OS Version: Linux 4.6; UI Render: default; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on July 16th 2016
Comment 7 Xisco Faulí 2017-03-25 16:43:14 UTC

Build ID: 193f8966135064a32164c9da08d01dab9c1fc15d
CPU threads: 4; OS: Linux 4.8; UI render: default; VCL: gtk2; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group

it takes

real	0m48.947s
user	0m32.280s
sys	0m1.480s

I think we can delete the crask work from the summary.
Comment 8 QA Administrators 2018-05-11 02:33:27 UTC Comment hidden (obsolete)
Comment 9 Xisco Faulí 2020-03-25 14:51:39 UTC
it takes

real	0m30,883s
user	0m21,790s
sys	0m0,984s


Build ID: 9163755e9f64a0b1dd5f2090e0702c19e31c12c9
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded

I think we can reduce its priority
Comment 10 Buovjaga 2021-11-06 14:24:50 UTC
30 sec stopwatch time here

Version: (x64) / LibreOffice Community
Build ID: 5c5f36aa73b11356a3bff0a9cc8b5fe8d1a776b9
CPU threads: 2; OS: Windows 10.0 Build 19042; UI render: default; VCL: win
Locale: fi-FI (fi_FI); UI: en-US
Calc: threaded
Comment 11 Roman Kuznetsov 2022-01-07 15:17:25 UTC
32 sec (Intel Core2Quad 9450) in

Version: (x64) / LibreOffice Community
Build ID: 1be170d0629cf761f0ee4173007a3c021966546e
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: CL