Issue 115305 - Sheet with 1.000 text boxes very slow to open
Summary: Sheet with 1.000 text boxes very slow to open
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.2.1
Hardware: All All
: P4 Minor with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-10-28 20:25 UTC by josir
Modified: 2017-05-20 11:35 UTC (History)
2 users (show)

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


Attachments
File with 1.000 text boxes (95.76 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-10-28 20:27 UTC, josir
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description josir 2010-10-28 20:25:06 UTC
Hi folks, I attached a xls spreadsheet with 1.000 text boxes inside. It took very 
long to open. but on Excel, it opens very quick.

It seems that those boxes are garbage because users don't know they exists.

When I try to delete some of them, OpenOffice halts. It occurs either on Windows 
and Linux.
Comment 1 josir 2010-10-28 20:27:23 UTC
Created attachment 72774 [details]
File with 1.000 text boxes
Comment 2 Jean 2013-01-26 15:55:14 UTC
(In reply to comment #0)
> Hi folks, I attached a xls spreadsheet with 1.000 text boxes inside. It took
> very 
> long to open. but on Excel, it opens very quick.
> 
> It seems that those boxes are garbage because users don't know they exists.
> 
> When I try to delete some of them, OpenOffice halts. It occurs either on
> Windows 
> and Linux.

I see what you are saying...I cannot even scroll down ... I will get back to you later :)
Comment 3 Andrea Pescetti 2013-01-26 17:26:52 UTC
On my system, with OpenOffice 3.4.1, the document takes 90 seconds to open (yes, slow, but a pathological document). I was able to see the Text Boxes using the Navigator (F5 key) and to delete them by selecting them there one at a time, provided I started with the first one listed in the Navigator).

Now, this might actually be a performance problem (I'm confirming it as such), but the 1000 text boxes seem definitely meaningless...
Comment 4 Marcus 2017-05-20 11:35:09 UTC
Reset assigne to the default "issues@openoffice.apache.org".