How to determine row/column extent of spreadsheet?

[mfleming]

Thanks!

Cyrille, your description of the spreadsheet storage format sounds as though it is efficient for both space and element lookup. I was worried that iterating through the cells might be O(n^2) or something. You mention special zero; would that be the same as Cell(0,0)? Could I use that in a comparison to differentiate cell content in the same way as your example using average and sin?

Hi Tyann, I'm worried a user might alter the spreadsheet, and might even add a row or column. Unless I can lock the spreadsheet against changes, it seemed best to check the size each time.

A last question on spreadsheet access. As mentioned earlier, A:A(0) can access the content of column A and 1:1(0) can access the content of row 1. Is there a way to do this via a function? The help text mentions accessing a row via Cell(n, 0) or column via Cell(0, n) but that only seems valid for writing to an entire row or column. I also tried accessing an entire row by constructing a string like "9:9(0)" and passing it to EVAL. No luck there!

Accessing an entire row or column at once might be moot if cell access is O(1). I could always write my own function now that I know how to find the size of a sheet, but it would be interesting to know if a function is available.

Regards,
~ Mark