Is it possible to "turn off" the automatic "Adapt row height" in Calc 2.0?
I have a calc workbook with 2 worksheets. Sheet1 currently has about 20 columns and 2000 rows. Sheet2 has about 20 columns and 200 rows with lots of array formulas referring back to Sheet1. The whole sheet is about 81 KB in .ods format. When I open the file, or if I change all of the formulas on Sheet2 (change 1 of them, then highlight and Fill Down) it spends about 45 seconds on "Adapt row height" (blue progress bar filling at the bottom). I've tried manually setting the row height (select the entire sheet and go to Format->Row->Height), but that didn't change anything. In searching the archives, this looks like the same problem: http://www.openoffice.org/servlets/ReadMsg?list=users&msgNo=43162 but no answer seems to have been given. A database would likely be more effective than my spreadsheet, and even a Pivot Table might work more efficiently, but I don't want to tackle the learning curve at the moment. Even if another format would be more effective, I would like to know how to disable the "Adapt row height" (or that it cannot be done at this time). I'm running OpenOffice 2.0 (just dl'ed and installed it last night) on a Dual-Core Pentium (3 or 4, not sure?) 836GM at 2.80 GHz with 1GB of RAM. OS is Windows XP Media Center Edition SP2 (it's a Gateway machine bought at CostCo Summer 2005). When doing the "Adapt row height" the task manager shows soffice.bin at a constant 50% CPU meaning it is using all of 1 of the 2 processing cores. I can email a copy of the spreadsheet if anyone wants to see it (the source data is more or less publicly available, and from a game anyway). I'm subscribed to the digest version of [email protected], so a Cc: to me on any replies would be appreciated. -- [EMAIL PROTECTED] --------------------------------- Yahoo! Mail Bring photos to life! New PhotoMail makes sharing a breeze.
