Posted 29 June 2020, 9:28 am EST
I’m on the trial version of the Spread.Net and I’m getting frustrated trying to get around the RowCount exceptions. I need to get a range from 2 cells in a string format, such as “C1” and “C501”. Normally, you would just create a range from those 2 cells and you’re all set. Unless that range exceeds the number of rows in the Worksheet. Then you only get a null range. Ok, so now I need to increase my rows by setting the RowCount higher to avoid these exceptions. I have a string cell address “C501”. Is there some utility where I can give it an address and it can tell me the row number? Or better yet, can I set a flag that tells the Worksheet to auto-grow when my row exceeds the RowCount?
To me it makes no sense to return a null range. The range is valid even if the spreadsheet does not have values yet.