API version 3.0, Java client library version 1.41.1 (according to javadocs linked from current Google API reference page).
The row and column count given in a worksheet entry generally seems to be arbitrarily larger than the actual data bounds in the spreadsheet. For example, I have a spreadsheet with 32 data columns and 23 data rows (none blank, data starts at A1) but the reported column count is 68 and row count is 122. Retrieving a cell list feed with empty cells enabled yields 36 blank columns on the right and 99 blank rows on the bottom. I have another test spreadsheet with 5 columns and 8 rows (one blank row, data starts at A1) and this reports 12 columns and 8 rows. Version 2.0 of the API has the same behavior (observed via PHP Zend client library). Why is the row and column count incorrect and how do I retrieve the actual data bounds without examining the data? Thanks, Jason
