Hi, this is a known issue with the new sheets. There is an external issue relating to this that you can star <https://code.google.com/p/google-visualization-api-issues/issues/detail?id=1596> to be kept up to date. The Docs team is aware of this and is working on a fix. In the meantime, you can use the Table Visualization <https://developers.google.com/chart/interactive/docs/gallery/table>.
On Tue Jun 17 2014 at 12:57:23 PM, Jian Sun <[email protected]> wrote: > > Hi, Sergey, > > When I click your example query link, I saw the following in the browser > window. I was expecting to see a HTML page like we saw with the old > spreadsheet version(for example > https://spreadsheets.google.com/tq?tqx=out:html&tq=select+D,F,count(C)+where+(B+contains+'Agoulnik')+group+by+D,F&key=0AqAPbBT_k2VUdEtXYXdLdjM0TXY1YUVhMk9jeUQ0NkE > ) > > google.visualization.Query.setResponse({"version":"0.6","reqId":"0","status":"ok","sig":"1579047909","table":{"cols":[{"id":"A","label":"","type":"datetime","pattern":"M/d/yyyy > H:mm:ss"},{"id":"B","label":"","type":"string"},{"id":"E","label":"","type":"number","pattern":"0"}],"rows":[{"c":[{"v":new > Date(2014,2,30,12,25,49),"f":"3/30/2014 12:25:49"},{"v":" > [email protected]"},{"v":5.0,"f":"5"}]},{"c":[{"v":new > Date(2014,2,30,12,14,5),"f":"3/30/2014 12:14:05"},{"v":" > [email protected]"},{"v":6.0,"f":"6"}]}]}}); > > I tried > https://docs.google.com/a/google.com/spreadsheets/d/1EbXvQW2IQ3QCoeXj-1tt0Ed_VwULk-YJZ7373MBG8PQ/gviz/tq?tqx=out:html&tq=SELECT%20A,B,E%20WHERE%20E%3E4 > but it does not work. > > Could you please provide an example on how to export a html page through > the query? > > Thank you. > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to > [email protected]. > Visit this group at > http://groups.google.com/group/google-visualization-api. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
