Some Cells Blank? Loading csv file from other than google docs

Update for #1 above – It looks like the ‘year’ is not displaying whenever it is not showing a 4 digit number. They will show if it says, say, 1989 but not 1989-90 or ????. Why would this be?

Update for #2 above – the data still does not show, but now it does not show any error after restarting my browser.

I guess I’m not going to worry about retrieving a sheet not in google docs. if you wouldn’t mind letting me know about why the cells are blank for me when i don’t just have a 4 digit number though, it would be greatly appreciated.

It looks like the ‘year’ is not displaying whenever it is not showing a 4 digit number. They will show if it says, say, 1989 but not 1989-90 or ????. Why would this be?

Because “1989” is a number but “????” is a string. When returned from a query, Google returns data of the first type, in this case number, and since “????” is not a number, it gets cast to null. See the GQL documentation:

Supported data types are string, number, boolean, date, datetime and timeofday. All values of a column will have a data type that matches the column type, or a null value.

You also asked:

It just says “[gdoc Error requesting data: Operation timed out after 5 seconds with 0 bytes received]” What am I doing wrong?

You may be trying to load more data than your server can load within the default 5 second timeout. To increase the timeout, use http_opts and pass in a JSON object that increases the timeout value. For instance, to 20 seconds:

[gdoc key="ABCDEFG" http_opts='{"timeout":20}']

Thanks so much for your response. So I guess my real question is, how do I get all the cells to display then?

how do I get all the cells to display then?

Don’t mix types. Either treat all the cells as numbers or treat them all as strings.

Forgive my ignorance on this – how do I treat them all as strings? I’d be happy to, but I guess I’m not sure how treat them as all strings. For instance, in my csv here is an example of each in my csv:

x,????,Broder The Press Box #20
x,1993,Red Foley Stickers #16

What would I do differently?

Thanks again

Replace all occurrences of ???? with a number, like 0.