AutoHeightRows taking 1 hour

Questions and answers on how to use XLSReadWriteII 3/4/5.
Post Reply
dgottschalk
Posts: 2
Joined: Wed Jun 19, 2013 11:27 pm

AutoHeightRows taking 1 hour

Post by 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
Posts: 2
Joined: Wed Jun 19, 2013 11:27 pm

Re: AutoHeightRows taking 1 hour

Post by 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
Posts: 13
Joined: Tue Feb 13, 2007 8:47 am
Location: West Sussex England

Re: AutoHeightRows taking 1 hour

Post by 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.
Joe Griffin
GerbilSoft Associates Limited
Post Reply