Hey Webster, You can use OAuth in Gadgets to access the Spreadsheets API. An example for the Contacts API is here, but is directly applicable to the Spreadsheets API: http://code.google.com/apis/gadgets/docs/oauth.html
I'll look into how to avoid reloading the gadget. Thanks, -Vic On Sat, Jan 8, 2011 at 12:43 PM, Webster West <[email protected]> wrote: > I am having a few issues with developing spreadsheet gadgets. > > First, I would like to have my gadget use all of the spreadsheet data > without having a range selection requirement. In fact, I would like > to avoid using the data visualization api for loading the data within > the gadget. This visualization api is too stringent for my needs in > defining a column to be of a certain type (e.g. numeric). Suppose I > have the values 1,2,3,a,b,c in a spreadsheet column. Then the > visualization api thinks the entire column is numeric and returns > empty values for the last three letters in the gadget. I would prefer > to get the url of the spreadsheet and change the output option to csv > manually. Note, I understand how to hard code the correct spreadsheet > url into the gadget, but here I am describing loading the gadget using > the Insert > Gadget menu from within the spreadsheet itself. Does > anyone know how to do this? > > Secondly, how can we avoid the reloading of the gadget when its > display is resized within the spreadsheet. This is very annoying in > that if a user is working in the gadget and they then resize it, the > gadget then reloads and the user loses all of their work. Is there a > workaround for this? > > Many thanks for any help, > > WW >
