Support » Plugin: Inline Google Spreadsheet Viewer » Missing data in table

  • dkshyrion

    (@dkshyrion)


    Hello,

    I am using Inline Google Spreadsheet Viewer for quite some time and like it really much.
    My shortcode looks like this: [gdoc key="URL" use_cache="no" class="no-datatables" query="select A,B,C,D,E,F where A = 'Example'"]

    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:
    X X _ _
    X X X X
    X _ _ _
    All 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 as proposed here: Link

    But this doesn’t work for me. I noticed that removing query="select ... solves the problem, but I need this feature as my table is very big.

    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?
    Thank you.

    • This topic was modified 5 months ago by dkshyrion.
Viewing 1 replies (of 1 total)
  • gskensho2jp

    (@gskensho2jp)

    hi

    >But this doesn’t work for me. I noticed that removing query=”select … solves the problem, but I need this feature as my table is very big.

    →Is it possible for you to make a new worksheet on googlespreadsheet and use “Query” in order to choose nessesary data from your big table?
    and, you can write the URL of new worksheet in shortcode.
    Is it good for you?

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.