Issue 103638 - Loading a rather simple .ods file takes >10 minutes
Summary: Loading a rather simple .ods file takes >10 minutes
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.1
Hardware: PC Windows Vista
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-07-19 11:52 UTC by h_koekoek
Modified: 2013-01-29 21:45 UTC (History)
2 users (show)

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

The slow spreadsheet (102.73 KB, text/plain)
2009-07-19 11:54 UTC, h_koekoek
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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

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).

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.