AutoHeightRows taking 1 hour

[dgottschalk]

Hello,

I have a spreadsheet where I am setting AutoHeightRows for 48464 rows. This is taking 1 hour. I looked at the AutoHeightRow procudure that is called and for each call (48464) it iterates ALL the cells to then process the cells belonging the the 1 row being set. So all the spreadsheets cells are being iterated 48464 times. Can this procedure be changed to jump directly to the cells belonging to the row in question and stopping when the cells for the row have been processed?

cheers,

David

[dgottschalk]

I had been hoping for an Official patch but in the meantime I have modified the AutoHeightRow source code myself to get down to a couple of seconds.

[Joe Griffin]

Is this for V4 (rather than V5). If so, I doubt that we will ever see a fix for it. In which case, any chance of a copy of the modified routine (I'm still using V4 under D7).

My e-mail is gerbilsoft <at> btinternet <dot> com.