Title: Header Issues Last modified: August 30, 2018 --- # Header Issues * Resolved [bohcurtis](https://wordpress.org/support/users/bohcurtis/) * (@bohcurtis) * [7 years, 9 months ago](https://wordpress.org/support/topic/header-issues-35/) * As you can see, the header of the spreadsheet is showing the first three rows instead of only the first row. I tried manually setting header_rows to 1. This is also an issue on many other pages, not just on this one page. Any suggestions are welcome. * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fheader-issues-35%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 4 replies - 1 through 4 (of 4 total) * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [7 years, 9 months ago](https://wordpress.org/support/topic/header-issues-35/#post-10679128) * > As you can see, the header of the spreadsheet is showing the first three rows > instead of only the first row. * That simply isn’t true; the HTML source of the page you linked shows the following for the `` element of the table: * ```
Last Name Abbott Adams
First Name Nathan Rebecca
Position Custodian Grade 4 Teacher
Email Address nabbott@rsu3.org radams@rsu3.org
``` * As you can see, there is only one `` (“table row”) element in the `< thead>` (“table header”) element. * As is stated numerous times on this support forum, the visual appearance of the table is up to your WordPress Theme. The plugin is correctly producing only _one_ table row in the header in its output. If it looks like there are more rows in the header, that’s a sign that your Theme (or some other code on your site) is doing what you told it to do, but not what you _meant_ for it to do. And since that’s a mismatch in something I can’t fix, I don’t (and won’t) try. * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [7 years, 9 months ago](https://wordpress.org/support/topic/header-issues-35/#post-10679159) * Ah, hang on, I see now that I misunderstood your original issue: the _data_ in the header _cells_ are the data in the first three rows of the Google Sheet. * That is…definitely bizarre. Unfortunately, I can’t replicate the issue. A shortcode like this: * ``` [gdoc key="https://docs.google.com/spreadsheets/d/1bPJak06G00iD6sycGE-3G9ojwGGyTU1w3bXOc75ouTI/edit"] ``` * works exactly as intended in my test environment; the name “Abott Adams” (for example) appears as the second row, beneath the “Last Name” and “First Name” column headings. To me, this still indicates something awry in your WordPress environment, though possibly (probably?) not something related to visual styling. * Unfortunately, this is also not something I offer support for. Your WordPress environment is your own responsibility. If it works in my test environments ( and there are _many_), then the issue is not with this plugin, as is evidenced by the fact that this symptom is only experienced by a small subset of users ( whose WordPress sites, I must assume, are somehow broken). * Thread Starter [bohcurtis](https://wordpress.org/support/users/bohcurtis/) * (@bohcurtis) * [7 years, 9 months ago](https://wordpress.org/support/topic/header-issues-35/#post-10681057) * On a separate testing server, I was able to have it work with the code you gave. However, using the code from the main server, it gives the same issue. Can you see any issues with the code used? `[gdoc key="https://docs.google.com/spreadsheets/ d/1bPJak06G00iD6sycGE-3G9ojwGGyTU1w3bXOc75ouTI/edit" datatables_page_length=" 100" query="select A,B,C,D where E contains 'MVE' " http_opts='{}']` * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [7 years, 9 months ago](https://wordpress.org/support/topic/header-issues-35/#post-10681265) * > Can you see any issues with the code used? * No. Your shortcode looks fine. * Try unfreezing the frozen first row from your Google Sheet. I seem to vaguely recall some weird bug in Google where it munged rows together if there is a frozen row or column in a sheet and the data is accessed with a query, though I might be misremembering that. * In any event, you can confirm the plugin is working as expected by accessing the data via its Google URL endpoint manually: * [https://docs.google.com/spreadsheets/d/1bPJak06G00iD6sycGE-3G9ojwGGyTU1w3bXOc75ouTI/gviz/tq?tqx=out:csv&tq=select%20A%2CB%2CC%2CD%20where%20E%20contains%20’MVE’](https://docs.google.com/spreadsheets/d/1bPJak06G00iD6sycGE-3G9ojwGGyTU1w3bXOc75ouTI/gviz/tq?tqx=out:csv&tq=select%20A%2CB%2CC%2CD%20where%20E%20contains%20’MVE’); * As you can see, Google returns the data you see in your table, i.e., it is Google, not this plugin, that is placing the later rows into the first one. You could raise an issue with Google if you want, but this plugin is working as expected. Viewing 4 replies - 1 through 4 (of 4 total) The topic ‘Header Issues’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/inline-google-spreadsheet-viewer. svg) * [Inline Google Spreadsheet Viewer](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/) * [Frequently Asked Questions](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/#faq) * [Support Threads](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/) * [Active Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/unresolved/) * [Reviews](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/reviews/) * 4 replies * 2 participants * Last reply from: [Meitar](https://wordpress.org/support/users/meitar/) * Last activity: [7 years, 9 months ago](https://wordpress.org/support/topic/header-issues-35/#post-10681265) * Status: resolved