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
