OOo 2.2 Spreadsheet Slooowww

[Rick Knight]

O. Sinclair wrote:
> Rick Knight wrote:
>   
>> 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.
>>
>>     
> Well, something has to be wrong alright but it beats me what. Try 
> disabling Java in Tools/Options/General - very few functions use it and 
> it can slow Oo down quite a bit.
>
> Sinclair
>
>   
Sinclair,

Thanks again for your reply. I have Java disabled already, but enabling 
it makes no difference.

Does anyone know if OOo 2.2.0 can be completely removed and replaced 
with OOo 2.0.2?

Thanks,
Rick