I had this problem as well. I just wanted to mention that there are a couple of work arounds until they get it fixed.
Personally, I was playing with the new candlestick chart based on the new stock quote speadsheet function. ironically the speadsheet function and the candlestick chart have different default ordering of the open, high, low, close quotes. Looking at my spreadsheet, the quote function appears to be in the usual order. To get the chart going, it was pretty easy to create a new view and select the columns that I needed in the order that the candlestick chart expects: low, open, high, close. I think this is the right reference: https://developers.google.com/chart/interactive/docs/reference#DataView_setColumns The other option that I found, is that there is a join function that works on the DataTables and maybe DataViews as well. you can find it listed under Data Manipulation Methods as part of the larger Visualization API. https://developers.google.com/chart/interactive/docs/reference#google_visualization_data So maybe that can meet some people's needs until they get it fixed. I would assume most people posting would already know that, but sometimes a little reminder is helpful. jon On Tuesday, January 28, 2014 8:24:53 AM UTC-8, Romain Vialard wrote: > > I thought it was working but the method setQuery() doesn't seem to work > with the new version of Sheets. > -- 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.
