sheetchecker hitting 1MB fetch limit, due to gdata formatting of cells output

[GoogleCodeExporter]

http://spreadsheets.google.com/feeds/cells/rG5zKJf7iRGOSxNrwdnYPYg/1/public/basi
c
is returning 2MB for ~400 records, blowing over the 1MB fetch limit.

http://spreadsheets.google.com/feeds/list/rG5zKJf7iRGOSxNrwdnYPYg/1/public/basic
is returning wacky formatting that doesn't match the docs:
<entry>
<id>http://spreadsheets.google.com/feeds/list/rG5zKJf7iRGOSxNrwdnYPYg/1/public/b
asic/chk2m</id>
<updated>2009-07-01T15:51:22.938Z</updated>
<category scheme='http://schemas.google.com/spreadsheets/2006'
term='http://schemas.google.com/spreadsheets/2006#list'/>
<title type='text'>Row: 5</title>
<content type='text'>opportunitytitle: Alcoholic Anonymous (English &amp;
Spanish Volunteers), sponsoringorganization: Department Of Correction,
description: Old Colony Correctional Center, a high-tech medium security
facility and the Old Colony Correctional Center Minimum Unit are located on
thirty acres of land at the Bridgewater Correctional Complex, along with
Bridgewater State Hospital, Massachusetts Alcohol and Substance Abuse
Center, and the Treatment Center. Since Old Colony is not a committing
institution, inmates are transferred ..., locationnumberstreet: P. O. Box
351, locationcity: Framingham, locationstateprovince: MA,
locationzippostalcode: 1704, startdate: 39902, enddate: 40267, contactname:
Bill Milhomme, contacte-mail: wtmilhomme@doc.state.ma.us,
contactphonenumber: (508) 620-6437 x104, howoftendoeseventhappen: Weekly;
Monthly</content>
<link rel='self' type='application/atom+xml'
href='http://spreadsheets.google.com/feeds/list/rG5zKJf7iRGOSxNrwdnYPYg/1/public
/basic/chk2m'/>
</entry>

i.e. unclear what happens with data containing colons...

Original issue reported on code.google.com by adam.sah on 1 Jul 2009 at 8:01

[GoogleCodeExporter]

to repro:
http://www.allforgood.org/sheetchecker/check?url=http%3A%2F%2Fspreadsheets.googl
e.com%2Fccc%3Fkey%3Druf-EiPPXbfqaI2la41sBWQ

a copy of their sheet: 
https://spreadsheets.google.com/ccc?key=rG5zKJf7iRGOSxNrwdnYPYg

Original comment by adam.sah on 1 Jul 2009 at 8:18

• Changed title: sheetchecker hitting 1MB fetch limit, due to gdata formatting of cells output

[GoogleCodeExporter]

ran by hand, not too many errors.  moving to roadmap for now.

Original comment by adam.sah on 2 Jul 2009 at 6:48

• Added labels: Milestone-Roadmap
• Removed labels: Milestone-Release1.6

[GoogleCodeExporter]

Same issue with this spreadsheet:
http://spreadsheets.google.com/pub?key=ttFmhFUcMf9-Zu6pibN3zhw&output=html

(checker link)
http://www.allforgood.org/sheetchecker/check?url=http%3A%2F%2Fspreadsheets.googl
e.com%2Fpub%3Fkey%3DttFmhFUcMf9-Zu6pibN3zhw%26output%3Dhtml

Original comment by LeonP...@gmail.com on 17 Aug 2009 at 2:49