Issue 103638

Summary: Loading a rather simple .ods file takes >10 minutes
Product: Calc Reporter: h_koekoek <h.koekoek>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, kpalagin
Version: OOo 3.1   
Target Milestone: ---   
Hardware: PC   
OS: Windows Vista   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
The slow spreadsheet none

Description h_koekoek 2009-07-19 11:52:32 UTC 
A rather simple spreadsheet (telephone bill calculation) was working fine till
last half 2008. Then suddenly loading it takes more than 10 minutes time (It
looks as if the program hangs). Even old backup files of 2007 were that slow. At
that time I was working already some months with OOo 3.0.1. I am not aware of
downloading any patches at that time. Changing to 3.1 did not help. Saving file
to .xls also does not help.
I wil try to attach the spreadsheet (at the moment I see no field to do that).
Comment 1 h_koekoek 2009-07-19 11:54:27 UTC 
Created attachment 63631 [details]
The slow spreadsheet
Comment 2 tomwb 2009-07-20 02:05:44 UTC 
h_koekoek:

You have 41 links to some external .GIF files.  When I broke the links, the file
opens quickly.
  
1) What I found to be a a bigger problem, is that it takes a very long time for
Calc to break the links (about the same order of time as the slow loading). 

2) If my shaky DSL connection goes down, Calc still tries to open the file but
can't.  Once the connection was re-established, it then opened the file
eventually (more than ten minutes elapsed).

TomW
OOO310m11 on Vista SP2
Comment 3 kpalagin 2009-07-20 09:45:39 UTC 
Confirming with m51 on WinXP.

This is caused by our suboptimal handling of Internet-originated pictures. 
Open the file and press F5 for Navigator.
Expand Graphics and you will see many spacer.gif in the file. Deleting them 
would make the file open much faster.
Comment 4 h_koekoek 2009-07-20 19:23:39 UTC 
Removing the .gif links solves the problem. No idea where they came from. Thanks
for the help.