Title: Inline Google Spreadsheet Viewer
Last modified: August 22, 2016

---

# Inline Google Spreadsheet Viewer

 *  Resolved [manishbuchasiacs](https://wordpress.org/support/users/manishbuchasiacs/)
 * (@manishbuchasiacs)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer/)
 * I want Default Value Show Entry 100 Instead of 10
    plz guide thanks in advance
 * [http://buchasia.com/careers/vacancy/](http://buchasia.com/careers/vacancy/)
 * [https://wordpress.org/plugins/inline-google-spreadsheet-viewer/](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/)

Viewing 13 replies - 1 through 13 (of 13 total)

 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer/#post-5860214)
 * Okay, I can guide you: consider reading [the plugin’s FAQ](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/faq/).
   😉
 *  [mcmasterp](https://wordpress.org/support/users/mcmasterp/)
 * (@mcmasterp)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer/#post-5860474)
 * Hello and thank you for this amazing plugin. I read the faq but I’m missing where
   to set default entries per page. I know it’s my mistake but where is the info?
 * many thanks
 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer/#post-5860475)
 * Copied from the FAQ:
 * > **How do I change the default settings, like can I turn paging off? Can I change
   > the page length? Can I change the sort order?**
   > If you’re able to add JavaScript to your theme, you can do all of these things,
   > and more. Any and all DataTables-enhanced tables can be modified by using the
   > [DataTables API](https://datatables.net/api).
   > For instance, to disable paging, add a JavaScript to your theme that looks 
   > like this:
   >     ```
   >     jQuery(window).load(function () {
   >         jQuery('#igsv-MY_TABLE_KEY').dataTable().api().page.len(-1).draw();
   >     });
   >     ```
   > 
 *  [mcmasterp](https://wordpress.org/support/users/mcmasterp/)
 * (@mcmasterp)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer/#post-5860476)
 * Oh I see. I didn’t think that section was it because it talks about removing 
   paging and I was looking for a section on changing the default number of entries.
 * Thank you very much for helping, I’ll try it out
 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer/#post-5860477)
 * > I didn’t think that section was it because it talks about removing paging and
   > I was looking for a section on changing the default number of entries.
 * Just change the `-1` to whatever page length you want; `5` gives you five rows
   per page, `40` gives you forty rows per page, and so on. 🙂
 *  [mcmasterp](https://wordpress.org/support/users/mcmasterp/)
 * (@mcmasterp)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer/#post-5860478)
 * Ok i think I have got it down. my theme has a script addon section to make it
   update proof which is nice. the only issue I see is that I have dozens of spreadsheets
   so adding the key into the script is a problem. Is there any way to still do 
   it?
 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer/#post-5860479)
 * > I have dozens of spreadsheets so adding the key into the script is a problem.
   > Is there any way to still do it?
 * Sure there is, but that’s a matter of customizing your script, and I don’t offer
   arbitrary programming help on these forums. Good luck. 🙂
 *  [mcmasterp](https://wordpress.org/support/users/mcmasterp/)
 * (@mcmasterp)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer/#post-5860480)
 * Ok. I’ll see if i can figure it out. if I can’t get it, where to ask for programming
   help?
 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer/#post-5860481)
 * > where to ask for programming help?
 * StackOverflow.com is generally useful for that.
 *  [mcmasterp](https://wordpress.org/support/users/mcmasterp/)
 * (@mcmasterp)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer/#post-5860482)
 * Thats a good idea. I did some searching on SO and looked at the jQuery attributes
   contains selector page and came up with this:
 *     ```
       <script type="text/javascript" >jQuery(window).load(function () { jQuery( 'div[id*="igsv-"]' ).dataTable().api().page.len(-1).draw();
       });</script>
       ```
   
 * as far as I can tell this should be working but doesn’t, any suggestions?
 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer/#post-5860483)
 * If you’re just looking to apply the same functions to every instance of a table
   produced by this plugin, you should select the `igsv-table` class, not individual
   IDs.
 *  [mcmasterp](https://wordpress.org/support/users/mcmasterp/)
 * (@mcmasterp)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer/#post-5860484)
 * Yup that was the trick! thank you. so the final solution was:
 *     ```
       <script type="text/javascript" >jQuery(window).load(function () { jQuery( ".igsv-table").dataTable().api().page.len(-1).draw();
       });</script>
       ```
   
 * Thanks again for the slick plugin. I donated what little pitiful amount I could
   earlier then needed support and you’ve been incredibly helpful with amazing response
   time.
 * I highly encourage every user of this plugin to donate to the author. check out
   maymay.net for ways to support him!
 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer/#post-5860485)
 * Thanks for the support. 🙂

Viewing 13 replies - 1 through 13 (of 13 total)

The topic ‘Inline Google Spreadsheet Viewer’ 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/)

 * 13 replies
 * 3 participants
 * Last reply from: [Meitar](https://wordpress.org/support/users/meitar/)
 * Last activity: [11 years, 1 month ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer/#post-5860485)
 * Status: resolved