Bug 37651 - FILEOPEN Calc uses huge amount of ram and cpu to load 18MB .xls
Summary: FILEOPEN Calc uses huge amount of ram and cpu to load 18MB .xls
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.2 release
Hardware: x86 (IA32) Linux (All)
: low normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks:
 
Reported: 2011-05-26 21:25 UTC by Chris Peñalver
Modified: 2015-12-15 11:05 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Chris Peñalver 2011-05-26 21:25:18 UTC 
Downstream bug may be found at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/148148

1) lsb_release -rd
Description: Ubuntu 11.04
Release: 11.04

2) apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.3.2-1ubuntu5
  Candidate: 1:3.3.2-1ubuntu5
  Version table:
 *** 1:3.3.2-1ubuntu5 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty-proposed/main i386
Packages
        100 /var/lib/dpkg/status
     1:3.3.2-1ubuntu4 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages

3) What is expected to happen in LibreOffice Calc via the Terminal:

cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/148148/+attachment/151803/+files/Heroforge_5.1.2.7.zip && file-roller -h Heroforge_5.1.2.7.zip && localc -nologo Heroforge_5.1.2.7.xls

it opens quickly and successfully.

4) What happens instead is it takes 7 minutes+ to load on a PC with 1 GHz CPU, 512 MB RAM.
Comment 1 Don't use this account, use tml@iki.fi 2011-05-27 00:35:03 UTC 
Most likely that is just how it is. I assume Excel does not take a huge amount of memory and CPU to open this document, but then, Excel is a different program with different internal data structures.

But sure, Kohei has in many cases managed to reduce Calc resource usage for some classes of pathological spreadsheet documents, let's hope something can be done for this one, too.
Comment 2 Rainer Bielefeld Retired 2011-06-20 22:40:27 UTC 
I modified Status to Assigned due to facts.

@Kohei:
I'm just trying to gather all Whiteboard key word recommendations. "perf" seems to be for "performance", is there any listing where I can find that definition and may be others, too?
Comment 3 Kohei Yoshida 2011-07-07 16:23:30 UTC 
(In reply to comment #2)

> @Kohei:
> I'm just trying to gather all Whiteboard key word recommendations. "perf" seems
> to be for "performance", is there any listing where I can find that definition
> and may be others, too?

Yes, I use 'perf' for performance related issues.  This is my personal whiteboard keyword but feel free to use it globally.
Comment 4 Björn Michaelsen 2013-05-28 22:32:35 UTC 
Opens and is responsive here on LibreOffice 4.0.3 with:

 9196 bjoern    20   0 1537m 561m  80m S   1.7  3.5   0:25.43 soffice.bin

thus closing as WORKSFORME.
Comment 5 Robinson Tryon (qubit) 2015-12-15 11:05:13 UTC 
Migrating Whiteboard tags to Keywords: (perf)
[NinjaEdit]