Hide Columns

  • Resolved nimeck

    (@nimeck)


    6 years, 9 months ago

    ** Apologies if this has been answered, I can’t find it **

    I’m tryin to hide all my columns past a certain column. For example, in my sheet, I want to only show columns A, B, C, D.

    I’ve tried the query string tool, no change to my results. My String does not read any updates.

    [gdoc key="https://docs.google.com/spreadsheets/d/1JHLRJ5chfl7W5fw7djDrfPojuKriPifHuigG15UduF4/edit?usp=sharing/gviz/tq?tq=select%20A%2C%20select%20B%2C%20select%20C%2C%20select%20D" datatables_page_length="13" datatables_searching="false" datatables_paging="false" datatables_dom=“rt”?]

    Am I missing anything? Is there an easier way of doing this I just haven’t been able to find? Any help would be appreciated.

    Thank you.

    • This topic was modified 6 years, 9 months ago by nimeck.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Meitar

    (@meitar)

    Use the query attribute for queries:

    [gdoc key="ABCDEFG" query="select A"]
    Thread Starter nimeck

    (@nimeck)

    Thank you! I was able to get it working now. My error was adding a comma (,) to the end of my query string. Removing it worked.

    However, I still seem to be having an issue with the green (+) button. My string below is what I am using, but the last column is hidden by the button. Am I missing something here? There should be enough room to host the final column.

    [gdoc key="https://docs.google.com/spreadsheets/d/1JHLRJ5chfl7W5fw7djDrfPojuKriPifHuigG15UduF4/edit?usp=sharing/" query="select A, B, C, D" datatables_page_length="13" datatables_searching="false" datatables_paging="false" datatables_dom=“rt”?]

    Screen Shot: See Screen Shot

    Thread Starter nimeck

    (@nimeck)

    Added:

    class="no-datatables"

    Seems to have solved the issue. Thank you.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Hide Columns’ is closed to new replies.