OOo 2.2 Spreadsheet Slooowww

[Macario Valle]

On Thu, 2007-08-23 at 10:01 -0700, Rick Knight wrote:
> 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
> 

I had the same problem a while back.  I blamed it on some
misconfiguration, or damaged file.  So, I removed all the packages
related to OOo, then did a "sudo aptitude purge <name of packages>"
I cannot remmeber the name of the packages, as I just did a an apt-cache
search of openoffice.
Afterwards, i did an install with adept, as that was the easier method
and forgot about it until nowthat i see this thread.

My OOo has been working correctly, and fast enough, since.