QUERY determines source data types based on column contents. There are very simple cases where the data type is incorrectly assumed. As a result simple query operations return unexpected results.
See "Test Query" in https://docs.google.com/spreadsheets/d/1tQLM36K_7VyfzzZLeqLS9Z4tWtAT08OHSMcAcfNCgGA/edit?usp=sharing Has anyone found a solution/workaround for this? -- This email and any attachments to it may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of The OT Centre. We do not accept any responsibility for viruses and it is your responsibility to scan attachments (if any). *Emails from The OT Centre are DKIM signed. If you ever receive an email which appears to come from us but does not have a matching DKIM signature, please call us.* If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this email in error. -- 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 https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/2ae05866-8a9f-407a-b385-e8f90da276df%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
