perhaps I am missing the point, but is range_trim intentionally written to be slow? sheet_is_region_empty checks essentially every cell in range. Therefore if the range has many rows to trim it checks most cells, if there are no rows to trim it checks the cells in the last row about log n times. Wouldn't it be usually be faster simply to start at the bottom and check whether the row is empty and trim it if possible?


Prof. Dr. Andreas J. Guelzow Assoc. Prof of Mathematics
Concordia University College of Alberta

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]