I'm working on a spreadsheet gadget that will take some standard text in a spreadsheet, format it and wrap it around a data chart. I'm planning to use this on a blog (and make it available to others for their blogs) and I think the easiest way to go is to create Google Docs spreadsheets in a standard format, create my special gadget on the spreadsheet, then get the publish script to embed it elsewhere. By using createQueryFromPrefs I hope to avoid having to reference the spreadsheet key explicitly in the XML, thereby avoiding having to clone the XML for each distinct spreadsheet.
Here's the rub: it seems that the table I get from getDataTable starts with the first numeric row of the table, skipping all the text rows above it. I can't even get my header row, which is Years, unless I format it as a number (which puts a , in the year, like 2,007). The Range defined in the Edit section when I set up the gadget clearly specifies A1:W20, but what I get back is A7:W20, where my actual data starts (or if I make row 7 plain text, like I want to, I only get A8:W20). Interestingly, I do get any text-only rows *after* the data rows (so I could move my text rows lower, I assume, but that still doesn't help the Year header row problem). Is this a special feature of the GadgetHelper, to assist the visualization code? Is there some way to turn it off, or at least ask for one text row before the numeric rows? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en -~----------~----~----~----~------~----~------~--~---
