class="no-datatables"

[gdoc key="ABCDEFG" class="no-datatables"]

Learn more about WordPress shortcodes.

I apologize for not my ignorance… but I don’t understand where to put it… not what to put. Do I put it in the text section of the post before the sheet link.. do I put it in the plugin code.. if so where? Thanks

What are you trying to do?

If you are trying to make a spreadsheet appear in your post, you put the above shortcode into your post as part of the text.

We have a “total” row and it obviously cannot be sorted with the rest of the data. So we want to display the data as formatted on the sheet. If there is not a way to have a “total” row and still have the sorting options for the data sets, then the above option will have to do. Thanks!

We have a “total” row and it obviously cannot be sorted with the rest of the data.

Why not? Calculating totals is what spreadsheets were designed for.

If there is not a way to have a “total” row and still have the sorting options for the data sets, then the above option will have to do. Thanks!

You can split a Google Sheet into two spreadsheets by using the query attribute to select only those rows that you want to retrieve with the limit and offset query language clauses.

For example, if your spreadsheet has 100 rows, then this shortcode will retrieve and display the first 50:

[gdoc key="ABCDEFG" query="select * limit 50"]

and this one will display the next 50:

[gdoc key="ABCDEFG" query="select * limit 50 offset 50"]

That way, you can choose to display a portion of your sheet differently than another portion of your sheet (perhaps by using class="no-datatables" on the first but not the second shortcode).

Ok. We will give that a try. I am just worried it will get too busy with multiple charts for the same data. We have about 25 rows max right now. First row headers, last row totals… will have to play around with it. It may also look strange to have the sorting and downloading options for one portion of the sheet and not the other….

I am just worried it will get too busy with multiple charts for the same data.

I would use multiple sheets for different data sets.

It sounds like you have some architectural issues with your spreadsheet. I’d suggest working through the free spreadsheet training videos provided by ExcelShir.com. He talks about Microsoft Excel but all the principles apply equally well to Google Spreadsheets.

Good luck!