Post by Admin on Oct 2, 2017 14:30:37 GMT -8
Click for this week's:
The following is me trying to imbed a google sheet published link into this forum.
Looks like issue is: If the Google shared key contains underscores, will not display in forum.
If anyone has any ideas, please post in the Comments Thread - Thanks...Fanny
Info on gsheet plugin here and here
WORKS:
These are examples from one of the gsheet Help Forums:
YES [gsheet]0ArvN5KxFV56ndEZMYjRzUHh1Z0t3cV9DS0xvMGwyYVE[/gsheet]
YES [gsheet width=500 height=300]0ArvN5KxFV56ndEZMYjRzUHh1Z0t3cV9DS0xvMGwyYVE[/gsheet]
My Sheet:
Display Sheet
docs.google.com/spreadsheets/d/e/2PACX-1vQ7Mmt-uU1GRwYJJU1477RFjgS7q4Wz7Hh_wWcI1FyOV-DmsTjWLzxVKHqTw6CAd-QfptnVzt9vEKD4/pubhtml?gid=837651059&single=true
All Sheets does not work either
The underscores are probably messing this up.
TRY:
YES [gsheet width=500 height=300]0ArvN5KxFV56ndEZMYjRzUHh1Z0t3cV9DS0xvMGwyYVE[/gsheet]
NO [gsheet width=500 height=300]e/2PACX-1vQ7Mmt-uU1GRwYJJU1477RFjgS7q4Wz7Hh_wWcI1FyOV-DmsTjWLzxVKHqTw6CAd-QfptnVzt9vEKD4[/gsheet]
NO [gsheet width=500 height=300]2PACX-1vQ7Mmt-uU1GRwYJJU1477RFjgS7q4Wz7Hh_wWcI1FyOV-DmsTjWLzxVKHqTw6CAd-QfptnVzt9vEKD4[/gsheet]
*******
Try:
NO
NO
NO https://docs.google.com/spreadsheets/d/e/2PACX-1vQ7Mmt-uU1GRwYJJU1477RFjgS7q4Wz7Hh_wWcI1FyOV-DmsTjWLzxVKHqTw6CAd-QfptnVzt9vEKD4/pubhtml
*****
docs.google.com/spreadsheets/d/e/2PACX-1vQ7Mmt-uU1GRwYJJU1477RFjgS7q4Wz7Hh_wWcI1FyOV-DmsTjWLzxVKHqTw6CAd-QfptnVzt9vEKD4/pubhtml?gid=837651059&single=true
docs.google.com/spreadsheet/pub?key= GKEY &output=html&widget=true
*****
convert gsheet tags in posts.
use the GKEY in a link like:
docs.google.com/spreadsheet/pub?key= GKEY &output=html&widget=true
and add into a post with:
[gsheet]GKEY[/gsheet]
you can add extra style inline like
[gsheet width="500" height="500" style="background-color:#000000"]GKEY[/gsheet]
The following is me trying to imbed a google sheet published link into this forum.
Looks like issue is: If the Google shared key contains underscores, will not display in forum.
If anyone has any ideas, please post in the Comments Thread - Thanks...Fanny
Info on gsheet plugin here and here
WORKS:
These are examples from one of the gsheet Help Forums:
YES [gsheet]0ArvN5KxFV56ndEZMYjRzUHh1Z0t3cV9DS0xvMGwyYVE[/gsheet]
YES [gsheet width=500 height=300]0ArvN5KxFV56ndEZMYjRzUHh1Z0t3cV9DS0xvMGwyYVE[/gsheet]
My Sheet:
Display Sheet
docs.google.com/spreadsheets/d/e/2PACX-1vQ7Mmt-uU1GRwYJJU1477RFjgS7q4Wz7Hh_wWcI1FyOV-DmsTjWLzxVKHqTw6CAd-QfptnVzt9vEKD4/pubhtml?gid=837651059&single=true
All Sheets does not work either
The underscores are probably messing this up.
TRY:
YES [gsheet width=500 height=300]0ArvN5KxFV56ndEZMYjRzUHh1Z0t3cV9DS0xvMGwyYVE[/gsheet]
NO [gsheet width=500 height=300]e/2PACX-1vQ7Mmt-uU1GRwYJJU1477RFjgS7q4Wz7Hh_wWcI1FyOV-DmsTjWLzxVKHqTw6CAd-QfptnVzt9vEKD4[/gsheet]
NO [gsheet width=500 height=300]2PACX-1vQ7Mmt-uU1GRwYJJU1477RFjgS7q4Wz7Hh_wWcI1FyOV-DmsTjWLzxVKHqTw6CAd-QfptnVzt9vEKD4[/gsheet]
*******
Try:
NO
<iframe width='500' height='' frameborder='0'src='http:// spreadsheets.google.com/pub?key=pPwo7--7PfjIRdqjkoYfiIQ&output=html&widget=true'></iframe>NO
<iframe width='500' height='' frameborder='0'src='http:// spreadsheets.google.com/pub?key=2PACX-1vQ7Mmt-uU1GRwYJJU1477RFjgS7q4Wz7Hh_wWcI1FyOV-DmsTjWLzxVKHqTw6CAd-QfptnVzt9vEKD4&output=html&widget=true'></iframe>NO https://docs.google.com/spreadsheets/d/e/2PACX-1vQ7Mmt-uU1GRwYJJU1477RFjgS7q4Wz7Hh_wWcI1FyOV-DmsTjWLzxVKHqTw6CAd-QfptnVzt9vEKD4/pubhtml
*****
docs.google.com/spreadsheets/d/e/2PACX-1vQ7Mmt-uU1GRwYJJU1477RFjgS7q4Wz7Hh_wWcI1FyOV-DmsTjWLzxVKHqTw6CAd-QfptnVzt9vEKD4/pubhtml?gid=837651059&single=true
docs.google.com/spreadsheet/pub?key= GKEY &output=html&widget=true
*****
convert gsheet tags in posts.
use the GKEY in a link like:
docs.google.com/spreadsheet/pub?key= GKEY &output=html&widget=true
and add into a post with:
[gsheet]GKEY[/gsheet]
you can add extra style inline like
[gsheet width="500" height="500" style="background-color:#000000"]GKEY[/gsheet]
