Apache OpenOffice (AOO) Bugzilla – Issue 105584
Adapt row height - ecalc
Last modified: 2017-05-20 09:57:19 UTC
Hi, noticed a couple of other filed issues around this topic but didn't seem to deal with what I'm facing. I am working with a fairly large file - however 30 minutes to open this file seems like a long time! File is approx 25,000 rows, 6 sheets (two of them 25k rows) other sheets less than 1000 rows each. On all sheets I have a =COUNTIF(C$1:C$65536;C3) formula in each cell on one of the columns. The other columns are just data - no functions or forulas.. Maybe I'm just trying to process too much in one file - accepted - but would be nice if I could work on a sheet this size. When I try and open this file it hangs with "Adapt row heaight" in the status bar on bottom left hand of the ecalc screen. When I copy and paste to a new sheet or generally try and work with this file it is painfully slow (10-30 minutes minimum to process some of the changes to the data. Regards, Matt ps: I'm about to chop down my original file and work with smaller chunks - still would be nice if I could punch the original file around. :) pps: I'm downloading 3.1.1 in case it is any better
Hi- I've got an issue that is apparently similar. I've got a spreadsheet of 3000 rows, and 10 columns; 3 of which are vlookup()s to other sheets; each of these referenced sheets have between 3000 - 30000 rows. On opening the spreadsheet, while it takes < 10 seconds to open the spreadsheet, the status bar then changes display Adapt row height; and the progress bar takes approx. 10 minutes to complete. This is running XP, 2.0GHz dual core CPU; 2GB RAM. Opening the same spreadsheet in excel takes less than 10 seconds.
I'm using Ubuntu 9.10 with OOo 3.1.1. I've found out that if I set "Tools/Options/Language Settings/Languages/Locale" setting to "Default", opening one of my documents with a lot of macros and formulas takes 12 seconds, but if I set that setting to, for example, "Serbian Latin", opening of the document takes 1 minute and 45 seconds (with almost all that time taken by "Adapt row height"). I guess that somwhere there lies the (part of a) problem... (I've sent this on sevral bug reports dealing with the similar issues)
Please attach file.
No info from author.