Apache OpenOffice (AOO) Bugzilla – Issue 103638
Loading a rather simple .ods file takes >10 minutes
Last modified: 2013-01-29 21:45:14 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).
Created attachment 63631 [details] The slow spreadsheet
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
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.
Removing the .gif links solves the problem. No idea where they came from. Thanks for the help.