Plugin Author
Meitar
(@meitar)
Use the datatables_scroll_x attribute:
[gdoc key=”ABCDEFG” datatables_scroll_x=”true”
wow, I appreciate the quick response thanks!
It now flips over to the other side of the spreadsheet and I can’t see any way to scroll it back.
my code is:
[gdoc key="https://docs.google.com/spreadsheets/load of numbers/edit?usp=sharing" datatables_scroll_x="true"]
ohhhh! I’ve just seen what it is doing! if you click on the green button next to the membership number it gives you more details! So we don’t need a sideways scroll.
Genius! lovely lovely plugin – can I donate somewhere?
Plugin Author
Meitar
(@meitar)
ohhhh! I’ve just seen what it is doing! if you click on the green button next to the membership number it gives you more details! So we don’t need a sideways scroll.
FYI, you can also disable the green button by adding the no-responsive keyword to the class attribute in your shortcode, so that’s one reason why it might make sense to use datatables_scroll_x:
[gdoc key="ABCDEFG" class="no-responsive" datatables_scroll_x="true"]
That way, you have a horizontally-scrolling table without the green button. But the default, as you noticed, is to have the green disclosure button and no horizontal scroll.
All of this and more is explained in quite a bit of detail if you read the user guide near the top of the plugin’s readme file and there’s even more detailed documentation at the plugin’s “Other Notes” section, in case you’re curious to learn more about what this plugin can do.
lovely plugin – can I donate somewhere?
🙂 Of course. Go to the plugin’s homepage here on WordPress and click on the “Donate to this plugin” link in the sidebar, or click on the “Donate” link for this plugin from inside your WordPress Admin Plugins screen. Donations are what make it possible for me to prioritize support requests on these forums. 🙂
My spread sheet is too wide and overlaps my sidebar. I would like to fix its width and do sideway scrolling
Plugin Author
Meitar
(@meitar)
ollewis, did you read this thread? The answer is in a previous post on this page.
Yes, read it, but it didnt work.
I got the table still with green circles.
However now, I dont even ger a table, I get an error. This is what it shows:
Get stuff done with Google Drive
Apps in Google Drive make it easy to create, store and share online documents, spreadsheets, presentations and more.
Learn more at drive.google.com/start/apps.
The statement I used is:
[gdoc key=”docs.google.com/spreadsheets/d/1JHK_N-Wkr_kXukuEaD_mL1UaDm938LCwYXj0dnj2rr8/edit?usp=sharing” class=”no-responsive” datatables_scroll_x=”true”]
Site is: http://www.work-feels-like-home.com/bunn-mcu-coffee-maker/
Plugin Author
Meitar
(@meitar)
The statement I used is:
[gdoc key=”docs.google.com/spreadsheets/d/1JHK_N-Wkr_kXukuEaD_mL1UaDm938LCwYXj0dnj2rr8/edit?usp=sharing” class=”no-responsive” datatables_scroll_x=”true”]
That’s not a valid URL. Use the full address, with https:// in the front:
[gdoc key="https://docs.google.com/spreadsheets/d/1JHK_N-Wkr_kXukuEaD_mL1UaDm938LCwYXj0dnj2rr8/edit?usp=sharing" class="no-responsive" datatables_scroll_x="true"]
Thank’s Metiar. It works perfect for me.
Finally got what you ment. Reading instructies first, helps!
Just one thing, (of course)
when I use the Column visibility button on a mobile phone, the buttons just stay there and i can not return to the page on the background.
Any idea?
Or how to remove just the Column visability button as I don’t realy need it now the sheet can be scrolled. This is what I have left:
{
“dom”: “B<‘clear’>lfrtip”,
“buttons”: [
“colvis”
]
}
Plugin Author
Meitar
(@meitar)
Or how to remove just the Column visability button
To remove a button, erase the line that names that button from the DataTables defaults object setting.
In your case, since you removed all the other buttons, you can enter:
{
"dom": "lfrtip"
}
This will remove all buttons.
hmm, i tried that before,
but it also takes away the search field and the entries button (which i both would like to keep). and the sheet stopped scrolling.
I tried several options but i’m not choosing the right one.
please? 🙂
what to put there to keep only the search field and the entries button?
Plugin Author
Meitar
(@meitar)
hmm, i tried that before,
but it also takes away the search field and the entries button (which i both would like to keep). and the sheet stopped scrolling.
That’s a bug. Update to 0.9.13, it should be fixed and
{
"dom": "lfrtip"
}
should work.
Thank’s Meitar. it worked!
