I have tried to make a new Google Sheet document from scratch:
https://docs.google.com/spreadsheets/d/1kwS31ZLWSOye4UoSZwxsEGDasqiuv2SLoXlxfXhB9NY/pubhtml?gid=1245776838&single=true
Still the same issue (tested on another webpage of my site):
Web page: http://lvts.fr/teams/team-2/
Shortcode: [gdoc key="https://docs.google.com/spreadsheets/d/1kwS31ZLWSOye4UoSZwxsEGDasqiuv2SLoXlxfXhB9NY/pubhtml?gid=1245776838&single=true" output="html" widget="true" class="hover compact" ]
Now, I am lost…???
Plugin Author
Meitar
(@meitar)
The tables show up fine when I looked at your pages.
You might want to read this plugin’s description; neither output nor widget are valid attributes.
First, sorry for the confusion because after posting here, I have changed the code of the pages that I was pointing at. What I change in the code is to use this type shortcode (something like the one recommended for old Googledocs):
[gdoc key=”1cT4wfBu1VvpBfK32yeWinmRXklqTSRNcTt9ZWgYDByQ” gid=”2073341341″ output=”html” widget=”true” class=”hover compact”]
You can see on these two pages that it may look ok but…
http://lvts.fr/teams/team-3/
Shordcode: [gdoc key=”1cT4wfBu1VvpBfK32yeWinmRXklqTSRNcTt9ZWgYDByQ” gid=”2073341341″ output=”html” widget=”true” class=”hover compact”]
http://lvts.fr/teams/team-4/
Shortcode: [gdoc key=”1cT4wfBu1VvpBfK32yeWinmRXklqTSRNcTt9ZWgYDByQ” gid=”914906280″ output=”html” widget=”true” class=”hover compact”]
…it is not ok!! Indeed, in my Googlesheet, I have several sheets: one with an exhaustive listing and a listing restricted to each team. In the two pages above, we should have 2 distinct listings but instead, the full listing is displayed on both pages.
If I use the ‘official’ short code, I have the Google login window as shown on these two pages:
http://lvts.fr/teams/team-1/
Shortcode: [gdoc key=”https://docs.google.com/spreadsheets/d/1kwS31ZLWSOye4UoSZwxsEGDasqiuv2SLoXlxfXhB9NY/pubhtml?gid=1529834953&single=true”%5D
http://lvts.fr/teams/team-2/
shortcake: [gdoc key=”https://docs.google.com/spreadsheets/d/1kwS31ZLWSOye4UoSZwxsEGDasqiuv2SLoXlxfXhB9NY/pubhtml?gid=1245776838&single=true”%5D
Once again sorry for the confusion. I hope that now my problem is clear enough…
Thank you in advance for your help!!
Plugin Author
Meitar
(@meitar)
Thank you! I read the IGSV’s doc months ago, when I have set up my pages and did look at it again quickly when my problems appeared. I should have read it more carefully…
So now that I have my google sheet are “Public on the web”, the listing is displayed but this is the full listing. My 2 pages of team 1 (http://lvts.fr/teams/team-1/) and team 2 (http://lvts.fr/teams/team-2/) should display 2 distinct listings. Instead, both display the full listing. Why is it so?
As an additional problem, the table does not look as before (as in Team 3 for instance: http://lvts.fr/teams/team-3; I’d like to remove the ‘+’ sign and have a compact design).
Thank you again!!
Plugin Author
Meitar
(@meitar)
So now that I have my google sheet are “Public on the web”, the listing is displayed but this is the full listing. My 2 pages of team 1 (http://lvts.fr/teams/team-1/) and team 2 (http://lvts.fr/teams/team-2/) should display 2 distinct listings. Instead, both display the full listing. Why is it so?
For your “team 2” sheet, you should be using this shortcode:
[gdoc key="https://docs.google.com/spreadsheets/d/1kwS31ZLWSOye4UoSZwxsEGDasqiuv2SLoXlxfXhB9NY/edit?pli=1#gid=1245776838"]
The value of the key here is simply the URL of the sheet when viewed from the Sheets interface copied and pasted into the shortcode.
As an additional problem, the table do not look as before (as in Team 3 for instance: http://lvts.fr/teams/team-3/). (I like to remove the ‘+’ sign and have a compact design (as in the team 3 table).
The + symbol is automatically added by the code in the DataTables Responsive extension when the width of your table exceeds the width of its parent container. You can turn this feature off by using the special class no-responsive, as documented here.
Thanks! My tables are back as wanted! The ‘/edit?pli=1#gid=’ did the trick, even if it is not clear to me why it should be coded like this…
Best regards and thank you for your great plugins!
