The spreadsheet is probably doing some type detection on each column, and
in the numeric columns, it is only returning data when there is a numeric
value. As far as I am aware, there is no way to override that behavior and
force it to return a cell in the format {"v":null,"f":"text value"}.
On Monday, October 28, 2013 9:32:39 AM UTC-4, Mario Colombo wrote:
>
> 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.
