The problem is in the types. In Google Spreadsheets, cells have no type, but for the API we have to set them with types (number, date, date+time, ...). We do it by some heuristics on the data. In this case, you have a mix of date and date+time cells in the same column. Since most of the cells are date only, we ignore the date+time cells. Note that if most of them were date+time, you had the opposite problem.
We will improve our logic to convert date+time into date (and vice versa) in these cases, but it still a real data issue. You have to decide what type of data you want this column to have, if you want to use a typed api like the visualization api. Regards, VizGuy On Fri, Dec 26, 2008 at 9:48 AM, Andrey <[email protected]> wrote: > > Hi, > > a) Here is my spreadsheet I'm trying to show as html table: > http://spreadsheets.google.com/ccc?key=pTSZ7bTknTaeiR_JJrmx2SA > > b) Then, I followed this example to create a visualization > http://code.google.com/apis/visualization/documentation/dev/index.html > > but instead of creating DataTable manually within html file, I read it > from my spreadsheet above. > But the datetime elements that iclude both date and none zero time are > not shown?!! > Please advise > > <html> > <head> > <script type="text/javascript" src="http://www.google.com/jsapi";></ > script> > <script type="text/javascript" src="mytablevis.js"></script> > <script type="text/javascript"> > > google.load("visualization", "1", {packages:["table"]}); > > // Set callback to run when API is loaded > google.setOnLoadCallback(drawVisualization); > > // Called when the Visualization API is loaded. > function drawVisualization() { > > var query = new google.visualization.Query('http:// > spreadsheets.google.com/ccc?key=pTSZ7bTknTaeiR_JJrmx2SA'<http://spreadsheets.google.com/ccc?key=pTSZ7bTknTaeiR_JJrmx2SA%27> > ); > query.send(handleQueryResponse); > } > > > function handleQueryResponse(response) { > if (response.isError()) { > alert('Error in query: ' + response.getMessage() + ' ' + > response.getDetailedMessage()); > return; } > > var data = response.getDataTable(); > var vis = new google.visualization.Table(document.getElementById > ('mydiv')); > vis.draw(data, {showRowNumber: true}); > } > </script> > <title></title></head> > <body> > <div id="mydiv"></div> > <p>Test example.</p> > </body> > </html> > > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
