Hello,<\/p>\n
I am using Inline Google Spreadsheet Viewer for quite some time and like it really much. The problem is that the content of some cells are missing. For example if you imagine a fully filled 3×4 table in Google sheets, the result looks like this on the website: But this doesn’t work for me. I noticed that removing Do you have any ideas? In the thread linked above, it was proposed to format the Google Sheets cells as Data. How can I do this?
\nMy shortcode looks like this: [gdoc key="URL" use_cache="no" class="no-datatables" query="select A,B,C,D,E,F where A = 'Example'"]<\/code><\/p>\n
\nX X _ _
\nX X X X
\nX _ _ _
\nAll rows are displayed. I figured out that changing the format in Google sheets sometimes helps, e.g. when I change the format to “Date” the value in the cell appears on the WordPress site, when it actually includes a date, but not every data is a date. I tried out to include csv_headers=1<\/code> as proposed here: Link<\/a><\/p>\nquery="select ...<\/code> solves the problem, but I need this feature as my table is very big. <\/p>\n
\nThank you.<\/p>\n","protected":false},"template":"","class_list":["post-15326159","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/15326159","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":1,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/15326159\/revisions"}],"predecessor-version":[{"id":15326162,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/15326159\/revisions\/15326162"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=15326159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}