The visualization API supports tables where all columns have the same
type, number, date, string etc.
In a spreadsheet, there is no such limit.
There are good reasons for both: spearsheet need to provide the
maximal flexibility, while the Visualization API needs balance ease of
use for developers.
As a result, spreadsheet cells that do not match the column's data
type, are set to null.
On Mar 22, 6:34 pm, gj <gsgm...@gmail.com> wrote:
After a little more testing, it appears that cells (and sometimes
rows) aren't displayed in the example gadget only when there are type
inconsistencies (e.g., some cells are numbers and some cells are
strings) within a column of the spreadsheet.
For example, the example gadget displays my test spreadsheet as
expected if the cells are transposed so that 'DOG' and 'CAT' are in
the same column.
Best regards,
Greg
On Mar 22, 10:08 am, gj <gsgm...@gmail.com> wrote:
I tried running the 'Simple Table Gadget' source given at
and setup to display the spreadsheet at
which contains a simple 3x3 table:
COL T1 COL T2
ROW T1 DOG CAT
ROW T2 1 2
For some reason, the row with 'DOG' and 'CAT' is not getting displayed
in the gadget. If I change 'DOG' and 'CAT' to numbers, the table gets
displayed as expected in the gadget. What is preventing the cells
containing text from being displayed in Google's gadget extension
example?
3 messages in com.googlegroups.google-visualization-apiRe: gadget extension example not disp...