Issue 112915 - Calc: Extreme performance issue with a file
Summary: Calc: Extreme performance issue with a file
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.2
Hardware: PC (x86_64) All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: performance
Depends on:
Blocks:
 
Reported: 2010-07-04 12:32 UTC by the_kid
Modified: 2017-05-20 10:44 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
sample file (1.67 MB, application/vnd.ms-excel)
2010-07-04 12:33 UTC, the_kid 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description the_kid 2010-07-04 12:32:42 UTC 
Open the attached .xls file, Calc crawls to death and becomes totally unusable.

This is on OOo 3.2.0 (OOO320m12, build 9483) on Gentoo Linux.

Tried creating new profile, doesn't help.
Comment 1 the_kid 2010-07-04 12:33:42 UTC 
Created attachment 70383 [details]
sample file
Comment 2 Joe Smith 2010-07-04 19:58:35 UTC 
Nothing official, just my two cents...

Talk to the people you got the file from. The document contains over 10,000
copies of two small images: one is 1x1, the other is 11x11, all transparent--web
bugs would be my guess.

If you turn off graphics (Tools > Options > OOo Calc > View > Objects >
Objects/Graphics: Hide, then the file works normally.
Comment 3 the_kid 2010-07-05 19:10:44 UTC 
Thanks for taking the time to pinpoint the root cause of the problem. 

I just tried to open the file in MS Office 2007, and apparently MS Office can
deal with the file just fine with no apparent performance problem. 

I think having 10000 images in a file is probably way beyond what most people
would see, so the file itself is obviously problematic; however, since MS Office
can open the file fine, I think I will just leave this issue as a low priority
enhancement.
Comment 4 Jean 2013-01-26 15:51:12 UTC 
(In reply to comment #2)
> Nothing official, just my two cents...
> 
> Talk to the people you got the file from. The document contains over 10,000
> copies of two small images: one is 1x1, the other is 11x11, all
> transparent--web
> bugs would be my guess.
> 
> If you turn off graphics (Tools > Options > OOo Calc > View > Objects >
> Objects/Graphics: Hide, then the file works normally.

hello
I cannot even open this ... is this even openoffice???
Thanks
Comment 5 Edwin Sharp 2013-08-23 13:49:07 UTC 
Excel 2010: 5 sec
Calc 4.0: 2 min 50 sec

AMD A6 1.50GHz 4.00GB RAM

Rev. 1513819 Win 7
Comment 6 Marcus 2017-05-20 10:44:27 UTC 
Reset the assignee to the default "issues@openoffice.apache.org".