Set Show Number of Record default to own number

I’m sorry, I don’t understand the question. Are you asking if it’s possible not to display an entire spreadsheet, only part of one, or are you asking if it’s possible to change the pagination number for long tables?

If the former, no, but you can simply create a new sheet in your Google Spreadsheet document that automatically copies some subset of rows, and then use that sheet for display on your website through this plugin.

If the latter, yes, if you can access the JavaScript of your page. Look into the DataTables usage options described here: https://datatables.net/usage/options

Good luck.

Thanks,
It was the latter. Specifically, where at the top left, it says Show [10/25/50/100] entries, can you set the default a different number and/or set “All” as an option.
I’m pretty much clued out when it comes to modifying javascript. Happy to leave as is so was just asking. Works great and fits a very specific need.

Ah, yes. You can change that, but you cannot do so in the shortcode. You’ll need to modify your theme’s JavaScript as described in the DataTables usage option examples for that.

Glad the plugin fits the need you have. ?? Thank you for using and supporting it.