Bug 87321 - FILEOPEN: high memory footprint opening a xls containg a big html table in Calc
Summary: FILEOPEN: high memory footprint opening a xls containg a big html table in Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLS Memory
  Show dependency treegraph
 
Reported: 2014-12-15 10:02 UTC by Gabriele
Modified: 2019-01-11 13:01 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
text.xls with a big html table. Open with plenty of RAM... (67.91 KB, application/zip)
2014-12-15 10:02 UTC, Gabriele
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabriele 2014-12-15 10:02:16 UTC
Created attachment 110849 [details]
text.xls with a big html table. Open with plenty of RAM...

Opening a xls file with a big html table (~40k rows and ~20 cols) in Calc takes over 4.5GB of memory.
The file is opened and works correctly if enough RAM is provided.

Tested on Libreoffice Calc 4.3.4.1 Linux 64bit

Attached a sample file to reproduce the issue.
Comment 1 Tim Lloyd 2014-12-15 20:52:10 UTC
Hi Gabriele, the attachment does not open as a LO doc. This is a problem I have seen before and it is due to the way the bugzilla sees the attachment.

If any gurus are reading could you pls modify the attachment so it is readable?

Cheers
Comment 2 Buovjaga 2014-12-16 12:04:10 UTC
I guess I didn't have enough RAM because of my Ubuntu VM running, so LibO just hung. Let's set to NEW.

Win 7 64-bit Version: 4.5.0.0.alpha0+
Build ID: 170616e9f2d30c1302bbb5a7a4b588bc05cd5cc9
TinderBox: Win-x86@39, Branch:master, Time: 2014-12-12_01:58:46
Comment 3 QA Administrators 2015-12-20 16:17:45 UTC Comment hidden (obsolete)
Comment 4 Gabriele 2015-12-24 10:56:40 UTC
I'm the original submitter

The bug is still present in

Libreoffice 5.0.4.2 (build id:2b9802c1994aa0b7dc6079e128979269cf95bc78)
Kubuntu 15.10 64bit 

According to htop calc use over 5GB RAM while opening the file.
After some time that the file is opened (without doing anything on it) RAM usage is down to 3037MB.
Comment 5 QA Administrators 2017-01-03 19:55:31 UTC Comment hidden (obsolete)
Comment 6 Gabriele 2017-01-05 15:58:03 UTC
I'm the original submitter

The bug is still present in

Versione: 5.2.3.2
Build ID: 1:5.2.3~rc2-0ubuntu1~xenial1
Thread CPU: 8; Versione SO: Linux 4.4;
Versione locale: it-IT (it_IT.UTF-8);

According to htop calc use ~4.6GB RAM while opening the file.

I've reported it 2 years ago, I'll be happy to test if someone have a look at it.
Comment 7 QA Administrators 2018-07-31 02:33:43 UTC Comment hidden (obsolete)
Comment 8 Gabriele 2018-08-28 11:19:51 UTC
I'm the original submitter

The bug is still present in

version: 6.0.6.2
Build ID: 1:6.0.6-0ubuntu0.18.04.1
Thread CPU: 8; SO: Linux 4.15; Resa interfaccia: predefinito; VCL: gtk3; 
Versione locale: it-IT (it_IT.UTF-8); Calc: group

According to htop calc use ~4.6GB RAM while opening the file.