Sounds like filing a bug might be in order.
On Mar 6, 2:17 am, Jason Cipriani <[email protected]> wrote: > 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
