Search found 2 matches

by dgottschalk
Tue Jan 20, 2015 4:17 am
Forum: XLSReadWriteII 3/4/5
Topic: AutoHeightRows taking 1 hour
Replies: 2
Views: 9250

Re: AutoHeightRows taking 1 hour

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.
by dgottschalk
Tue Dec 16, 2014 12:51 am
Forum: XLSReadWriteII 3/4/5
Topic: AutoHeightRows taking 1 hour
Replies: 2
Views: 9250

AutoHeightRows taking 1 hour

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 a...