Hi, The test sheet cells were still formatted as text. I switched the cells that contain numbers back to a number format (currency) and you can see that cells that contain text now do not show up anymore.
All the best Mario On Monday, October 28, 2013 2:25:30 PM UTC+1, asgallant wrote: > > I opened the spreadsheet and ran the query, and the results came back as > expected, no missing values. > > On Monday, October 28, 2013 7:19:00 AM UTC-4, Mario Colombo wrote: >> >> I have prepared a test spreadsheet, please see the unexpected behaviour >> here: >> >> Table Query: >> https://docs.google.com/a/webrepublic.ch/spreadsheet/tq?key=0AoaBYlIzWjk2dHNyZndoTW1oZzN4WTBOamZMTEVONXc&transpose=0&headers=0&gid=0&tqx=out:html >> >> Spreadsheet: >> https://docs.google.com/a/webrepublic.ch/spreadsheet/ccc?key=0AoaBYlIzWjk2dHNyZndoTW1oZzN4WTBOamZMTEVONXc#gid=0 >> >> >> It seems that for columns that contain text and number formatted content, >> the text content is stripped. >> >> Why is that? >> >> All the best >> >> Mario >> > -- 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/groups/opt_out.
