Is this option available yet for the spreadsheet control as it is with the Grid? I'm having issues getting data to display when I have more than 500 rows of data. Though it could have something to do with the generic data class I'm using which is over 250 columns. I'm also using dynamic columns.
Currently there are no restrictions on rows and columns count. By default the SpreadSheet rows are set to 200 and the columns to 50, so it might be the case that you are hitting the rows limitation. You can try setting the rows and column properties to the maximum that you are expecting.