Thanks! That was exactly what I suspected. When I went over from MS Office to OpenOffice.org I had MS Office '97 and Windows 98 or Windows 2000. One of the first things I noticed was that OpenOffice.org was sooo sloooow, and I think when using AutoFilter was the first time I thought that this is really annoyingly slow. My thought was that if it is this slow already at 1000 or so lines (the file grows every day - the original that is, not this test version), how slow will it be in a couple of yearas when there are maybe 10000 rows or 65000 rows? Well, 65000 rows in this case would maybe happen in like 50-100 years or so, but maybe there could be other spreadsheets out there, growing faster…
Well, I know, maybe I should use Base for this, but that doesn't mean that OpenOffice.org doesn't need to be faster. J.R. 2009/5/14 Gordon <gbpli...@gmail.com>: > Johnny Rosenberg wrote: >> >> 2009/5/14 Gordon <gbpli...@gmail.com>: >>> >>> Johnny Rosenberg wrote: >>> >>>> There are a bit more than 2000 rows and what I want you to do is to >>>> use the autofilter function. >>>> For example I did this: >>>> Click the autofilter button in the ”Till” column, which is column I. >>>> Select the first thing in the list: ”Adindy” (yes, it's a fake word >>>> and means nothing - if it does in some language, it's a coincidence). >>>> This took about 18 seconds on my computer! >>>> Selecting All took about 15 s. >>> >>> between 3 and 5 seconds to filter on "Adindy". >>> Using Open Office 3.1.0 on Ubuntu 9.04 in a WUBI install on dual core >>> 1.6GHz processors, 2GB RAM. >>> I have set the memory options in OO to 256MB for OO and 196 MB per >>> object. >> >> >> Since you have a Wubi install I guess that you have Windows too. Maybe >> even Excel? If so, it would be nice if you could test this in Excel >> too. >> >> J.R. > > OK. Excel 2007 0n Vista Home Premium, same computer specs as above. > Firstly it takes 12 seconds to open the file. > Filter on Adindy is almost instantaneous. > Filter on All again almost instantaneous. > > Compared with OO 3.1 on Vista Home Premium..... > 10 seconds to open. > Filter on Adindy takes 5 seconds > Filter on All takes about 2.5 seconds. > > Seems OO is not the best at filtering...... ;-) > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.org > For additional commands, e-mail: users-h...@openoffice.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org