Title: plugin loads blank rows
Last modified: September 5, 2018

---

# plugin loads blank rows

 *  Resolved [mahadavid](https://wordpress.org/support/users/mahadavid/)
 * (@mahadavid)
 * [7 years, 9 months ago](https://wordpress.org/support/topic/plugin-loads-blank-rows/)
 * Hi –
 * Thanks again for all the work on the project.
 * It’s almost working, but I currently have 44 lines of data on one of the sheets,
   and it loads another 56 lines of blank data, then says “loading”.
 * I’m using this shortcode:
    [gdoc key=”[https://docs.google.com/spreadsheets/d/1jIsxT6-opTMUK3SL1llLFW6fyjkXsVNqaq9Wf5cXl6Y&#8221](https://docs.google.com/spreadsheets/d/1jIsxT6-opTMUK3SL1llLFW6fyjkXsVNqaq9Wf5cXl6Y&#8221);]
 * In order to only select rows that have content, I tried to add in query=”select*
   where A=’African American'” yet that appears to be completely ignored, unless
   I add “edit” to the end of the sheet key: “[http://…%5Bkey%5D/edit&#8221](http://…%5Bkey%5D/edit&#8221);,
   with the side effect of killing all the formatting from the google doc, and puts
   little green plusses in instead of showing the whole row.
 * Perhaps that’s by design?
 * As a test that wouldn’t work with an active spreadsheet, At the time of this 
   posting I deleted the other 56 rows, and now it loads the 44 active rows and 
   still says “loading” at the bottom even though there’s nothing more to load…
 * Is this by design?
 * For more background,
 * This is part of a workaround of a previous question I couldn’t figure out detailed
   here: [https://wordpress.org/support/topic/only-first-100-rows-load/](https://wordpress.org/support/topic/only-first-100-rows-load/)
 * In the currently active scenario, I created separate spreadsheets each querying
   one of the possible answers for the first column so that none of the sheets would
   exceed 100 rows.
 * Thanks in advance for your insight.
 * David
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fplugin-loads-blank-rows%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [7 years, 9 months ago](https://wordpress.org/support/topic/plugin-loads-blank-rows/#post-10670461)
 * If you see blank rows in the output of the plugin it means you have blank rows
   in the output of the data source.
 * Formatting is not retained in any situation; the plugin only deals with sheet
   data.
 * Little green plus buttons are added by the Responsive extention for DataTables.
   Use `class="no-responsive"` to disable it.

Viewing 1 replies (of 1 total)

The topic ‘plugin loads blank rows’ 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/)

## Tags

 * [Blank](https://wordpress.org/support/topic-tag/blank/)
 * [query](https://wordpress.org/support/topic-tag/query/)
 * [select](https://wordpress.org/support/topic-tag/select/)
 * [spinning](https://wordpress.org/support/topic-tag/spinning/)

 * 1 reply
 * 2 participants
 * Last reply from: [Meitar](https://wordpress.org/support/users/meitar/)
 * Last activity: [7 years, 9 months ago](https://wordpress.org/support/topic/plugin-loads-blank-rows/#post-10670461)
 * Status: resolved