On 07/30/2007 07:16 AM, Jean-David Beyer wrote: > Adrian Try wrote: >> Hi NoOp >> >>> I think it's probably time to start admitting that there are >>> serious performance problems in opening excel spreadsheets: >>> >>> http://www.openoffice.org/issues/show_bug.cgi?id=79762 Excel - >>> few seconds to open Calc - 16 to 25 _minutes_ * The file is an >>> Indian Tax Return >> >> While I'm the first person to admit I'd like OpenOffice.org to >> continue addressing speed issues, I think things are improving. >> >> I just downloaded the file in question, and it opened in 1 minute >> 16 seconds. >> >> That's a _long_ way from the times stated. >> >> I think things are improving. > > I do not know what machines you are using. I just opened OO > spreadsheets and it took 2 to 3 seconds to open it on a blank > spreadsheet. I then opened a small (less than a screenfull) > spreadsheet and it was so fast I could not time it with my > wristwatch. > > I then tried the file in question and it took about 1.5 minutes. It > is completely compute-limited, taking 100% of one of my two > hyperthreaded Xeon processors, which prevents any hyperthreading of > it (the other processor runs 100% hyperthreaded). > > I do not know how bad this is for a 43,000 or so row table. Long > before I get a spreadsheet that big, I would stick in into an SQL > database. I guess India has even more bureaucracy than we do in USA. > My tax return never exceeded 50 pages, and that happened only once. > Now it is almost always half that or less.
Ah... no fair - you guys are working with modern machinery :-) OOo 2.2.1 linux, 450Mhz 384MB: 12 minutes 15 seconds OOo 2.3dev linux, same machine: 11 minutes 10 seconds I also tried later on a 2.2Ghz 512MB machine: OOo 2.2.1 windows 10 minutes 42 seconds MS Excel 2003 Gets a VBA error & corrects saved file is only 18MB vs 24.5MB so I think that it may strip out a bunch of macro info. Original file opening to vba error notice: 33 sec including my click time to tell it to repair the file. Saved file opening time: 5 seconds. OOo 2.2.1 windows - using the repaired 18MB saved .xls file 10 minutes 48 seconds OOo 2.2.0 linux (Ubuntu'ized version I don't have 2.2.1 OOo official on that machine) 9 minutes 37 seconds That said... I'm sure glad I don't need to fill out an Indian tax IT4 tax return :-) --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
