rufuspollock-okfn / recline.backend.gdocs

Javascript library for accessing Google Docs Spreadsheet - and also functions as a Recline backend!
14 stars 6 forks source link

Worksheet index is wrong for new style spreadsheet urls #10

Closed rufuspollock closed 10 years ago

rufuspollock commented 10 years ago

Worksheet index should be 1 in default case and turns out we can't use the gid reliably in non-default case.

e.g. see this worksheet https://docs.google.com/a/okfn.org/spreadsheets/d/1S8NhNf6KsrAzdaY_epSlyc2pHXRLV-z6Ty2jL9hM5A4/edit#gid=406828788

gid are large numbers but for actual access use worksheet index 1 and 2 ... https://spreadsheets.google.com/feeds/list/1S8NhNf6KsrAzdaY_epSlyc2pHXRLV-z6Ty2jL9hM5A4/2/public/values?alt=json

answer here is that clients will always have to explicitly set worksheet index if they want anything other than first sheet