Hi Paul,

it would be interesting for me how long it takes for your system to do this with MY spreadsheet. Would you try it if I email my spreadsheet file to you? It's about 800 kB.

Johnny

Den 2005-11-28 00:46:57 skrev Paul <[EMAIL PROTECTED]>:

I'm using P4 2.6Ghz, 512MB ram with winxp...  I duplicated your
spreadsheet (admittedly the formulas in each of the cells were
simplistic adds), but did not get the performance you mentioned.

Each of the filters (several columns were tried) the results were sub
second. I doubled the number of rows and the performance was still
comparable.

Not alot of info was available about the machine you used - so it
could be that. Additionally, you could try to 'repair' the OOo
installation to see if that improves things.

Certainly that level of performance is not standard.

/paul

On 11/25/05, Johnny.1966 <[EMAIL PROTECTED]> wrote:
Hi!
I have a spreadsheet file, created with OOo 1.1 almost 2 years ago. It has
now grown to about 2100 rows and every one of them contains formulas or
values. Maybe 20 columns are used in this spreadsheet.

I use the autofilter function sometimes and today I tried to do that with the new OOo 2.0. I just selected one of the rows of the pop-up menu at the arrow button and then I waited. And waited. And waited some more... then I
did the famous Ctrl-Alt-Delete and killed it. Next step was to open the
file with 1.1.5. This time it took incredibly long time, maybe 5-10
seconds, but at least something happened...
Now I converted the spreadsheet to the new ods format with OOo 2.0, opened
it again with OOo 2.0, then tried to use the autofilter again. Now I
decided to wait until it's finished no matter how long it takes, so I
waited. And waited. And waited...... About 13 minutes (YES, minutes, not
milliseconds!) later something happened on the screen. However it seemed
more or less dead. Didn't respond to any actions. Suddenly it responded,
but it seemed to be very slow. From pushing the down arrowkey until the
cursor moved one step down it took about 9 seconds! EVERY TIME! This is
totally unusable, at least for me.

Did anyone else experience anything like this?

I'm on a HP Pavilion ZV5000 laptop (it's not mine so I don't know about
exactly everything about it), Windows XP.

The spreadsheet file is somewhat less than 800 kB and, like I said, about
2100 rows. Shouldn't cause any problems, and it doesn't with OOo 1.1.5,
except that things take seconds instead of milliseconds of course.

I am just trying to figure out if there is something wrong with my system
or if I should file an issue.

Johnny

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



--
Inget virus hittades.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.8/184 - Release Date: 2005-11-27




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to