OOo 2.2 Spreadsheet Slooowww

[Rick Knight]

O. Sinclair wrote:
> guido dom wrote:
>   
>> it works in ubuntu feisty with Gnome
>>
>>
>> 2007/8/21, O. Sinclair <o.sinclair at gmail.com <mailto:o.sinclair at gmail.com>>:
>>
>>     Neil Winchurst wrote:
>>      > On Tue, 21 Aug 2007 09:49:42 +0200
>>      > "O. Sinclair" <o.sinclair at gmail.com
>>     <mailto:o.sinclair at gmail.com>> wrote:
>>      >
>>      >> Open Office - Making It Start Faster!
>>      >> Posted: 15 Aug 2007 05:51 PM CDT
>>      >>
>>      >> therefore this may be a short post. Alright, let's get on with it.
>>      >> Open up Write or Calc.
>>      >> Goto Tools, then Options.
>>      >> Locate the setting on the left called 'Memory'. Then on the
>>     right, check
>>      >> to make sure that the following are in place.
>>      >> Number of steps is set to 20.
>>      >> Graphics Cache for Open Office is set to 128 MB.
>>      >> Memory per object is set to 20.0 MB.
>>      >> Enable systray quickstarter is check-marked.
>>      >>  From here, simply hit OK and restart the program. From this
>>     point on,
>>      >> the applications of the Open Office suite will run MUCH faster at
>>      >> start-up. ;)
>>      >>
>>      >> It did help me,
>>      >> Sinclair
>>      > Interesting. I did the above and indeed both the writer and the
>>      > spreadsheet go much faster. Just one puzzle - I check-marked the
>>      > quickstarter as you said, but when I went back to check  the mark
>>     had
>>      > been removed.
>>      >
>>      > Still, it doesn't seem to matter, it goes really quickly now. Thanks.
>>      >
>>     I should maybe have added that the quickstarter option is not even
>>     available for me, don't know if that is one of those Gnome/KDE issues.
>>
>>     Sinclair
>>     
> As a further followup - there is a separate quickstart package for 
> OpenOffice and KDE, actually 2 of them. The "oooqs2-kde" worked in 
> Kubuntu but seems to make no difference in startup speed after the above 
> adjustments and the box for "enable quickstart" is still grayed-out in 
> OpenOffice. It does however give a convenient way to start OO with 
> documents etc. from the tray if you wish.
>
> Sinclair
>
>   
Thanks everyone for these tips. While they may have made a difference in 
how long it takes to start OpenOffice Calc, they didn't improve the 
overall performance of OpenOffice. I have 3 similarly equiped PCs 
running Kubuntu. One of them, my desktop at home, is still running 
Kubuntu 6.06 with OOo 2.0.2. The other 2 PCs, my notebook and my desktop 
at work both run Kubuntu Feisty 7.04 with OOo 2.2.0. At home using OOo 
2.0.2 I can open this spreadsheet in under 3 seconds. When I click the 
upper left corner to select the entire spreadsheet, selection is 
instant. No delay at all. I can navigate around the spreadsheet without 
any delay or latency. Everything works fine. On both my notebook PC and 
my desktop at work running Feisty 7.04 with OOo 2.2.0 the same 
spreadshet takes 30 seconds to open. Doing the same procedure as above 
to select all takes 9 minutes, yes minutes. Navigating around the 
spreadsheet is so slow I have to stop constantly to let the sheet catch 
up with me. This makes OOo Calc pretty much unusable for me. Problem is, 
the other 2 or 3 linux spreadsheet apps lack features I need. Most of my 
spreadsheets are .csv format and range from about 400 rows to just over 
3500 rows and 26 columns. The spreadsheet example above is 445 rows, 15 
columns and 719K.

My home desktop PC is a 4 year old clone P4 2.4 GHz with 2 GB RAM 
Kubuntu 6.06
My work desktop PC is a Dell Optiplex GX52 Pentium D 3.2 GHz with 3 GB 
RAM Kubuntu Feisty 7.04
My notebook PC is an HP nc8230 Pentium Centrino 1.87 GZ with 2 GB RAM 
and Kubuntu Feisty 7.04.

Thanks for any help with this,

Rick Knight