Hi Mario and asgallant,
I'm running into the same exact problem with one of my spreadsheets and
before trying to reinvent the wheel, figured I would check in to see if you
either of you had come up with a solution since your last post(s).
Thanks!
Jessica
On Monday, October 28, 2013 8:53:44 AM UTC-5, asgallant wrote:
>
> 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.
