Hi, yes, this is also what I am doing now.
I am also organising my table queries so they don't contain multiple types
or even <empty> per column.
All the best
Mario
On Thursday, November 21, 2013 5:32:07 PM UTC+1, asgallant wrote:
>
> I have not found a work-around for this. There probably isn't anything
> you can do on the javascript end of things to fix it. On the spreadsheet
> end, if you can force the column to use text-values instead of numbers,
> that would probably solve the problem.
>
> On Thursday, November 21, 2013 11:24:55 AM UTC-5, jmarcus wrote:
>>
>> 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/d/optout.
