Excel can actually have some high order number of rows. We're currently limited to Short.MAX_VALUE because we don't know how to do relative row numbers. We should figure this out at some point.
We do absolute and relative row numbers in formulas. Some work is probably required in Names as well. What else do u mean here?
I believe you can actually have more then UnsignedShort.MAX_VAL rows in excel. However the row number is stored as an Unsigned Short in RowRecord. So there is some manner Excel uses to identify "relative" row numbers. This probably involves the IndexRecord (which we currently don't write because its another upstream pointer to downstream things). However that's just a guess.
Nope, excel cant have more than 65K rows. Well excel 12 can but that a whole different story...... Closing as INVALID. Jason