Gsheet Plugin

[Wormopolis]

is the video size code public? the problem with making the generic selector there is it encompasses ALL iframes in a post. let me try something...

[M³]

The code is nothing more than: 






<style type="text/css">
.posts .post .message iframe { width: 720px; height: 434px; }
</style>

Ok, I'll wait for ya

[Wormopolis]

grab it from the dropbox again. see if that works with your video css

[M³]

The previous version worked after taking out my video size code .... I did upload the new one thinking that it would allow my code and ability to size the sheet accordingly, but didn't. No worries, though. I got it to work, regardless. I think I may just remove the video code as the video size is adequate enough. I DO appreciate your help, Worm. I'm really glad we got this to work. It is better than the previous way I embedded the code which was in my H&F's.

Thanks, again!

[Wormopolis]

you can do this:

[gsheet style="width:500px; height:300px"]

[toosk3tchy]

Wormopolis

forzatimeattack.proboards.com/thread/35/tuning

Hey mate,

Ive gone so far with embedding a table but heres a few problems i have that i wondered if you knew how to resolve.

1. I want users to be able to input values and the table actually work.
2. Id love to get rid of the grey stuff like title around the outside, any ideas.

Thanks
S

[Wormopolis]

I dont think google sheets allows you to do either of those things actually. all this plugin could do was embed it into a post

[toosk3tchy]

Thanks Worm,

In the end I decided to go with using Excel Online through MS Onedrive + the admin HTML plugin. It works brilliantly and Excel Online gives you all the options when embedding to make it editable without saving plus showing a specific cell range etc. I have leaderboards that I wanted to be view only and tuning calculators that need to be interactive. The only thing that I would say about excel online is that its not as easy to protect the cells.

Thanks
S

[Wormopolis]

Yeah you run the risk of people messing things up if they have access to edit it. gsheet was simply written to display a spreadsheet already screted online into a post. I never figured it could get fancy.

[cromcruach]

Hi I've been trying to get this plugin to work but can't.

I've tested a few diffrent strings but only get a blank white page:(added a * so it wouldn't display the page here)

Test line 1
*[gsheet width=904 height=1100 style="background-color:#FFFFFF"]1ANFTf9Eq8hqJr_Pb1rtN7VVkdHnNqNxZWrsn8XSA1bE/edit?usp=sharing[/gsheet]

Test line 2
*[gsheet width=904 height=1100 style="background-color:#FFFFFF"] 1ANFTf9Eq8hqJr_Pb1rtN7VVkdHnNqNxZWrsn8XSA1bE [/gsheet]

Test line 3
*[gsheet width=904 height=1100 style="background-color:#FFFFFF"]1ANFTf9Eq8hqJr_Pb1rtN7VVkdHnNqNxZWrsn8XSA1bE[/gsheet]

Test line 4

*[gsheet width=904 height=1100 style="background-color:#FFFFFF"]https://docs.google.com/a/korpskugga.se/spreadsheets/d/1ANFTf9Eq8hqJr_Pb1rtN7VVkdHnNqNxZWrsn8XSA1bE/edit?usp=sharing[/gsheet]

Test line 5

*[gsheet width=904 height=1100 style="background-color:#FFFFFF"]https://docs.google.com/a/korpskugga.se/spreadsheets/d/1ANFTf9Eq8hqJr_Pb1rtN7VVkdHnNqNxZWrsn8XSA1bE[/gsheet]

[cromcruach]

I just get a big white box with the background color

[Wormopolis]

You sure the key is correct?

[cromcruach]

This is a page I've shared to the public:

docs.google.com/spreadsheets/d/1ANFTf9Eq8hqJr_Pb1rtN7VVkdHnNqNxZWrsn8XSA1bE/edit?usp=sharing

and this is how the string looks:

[gsheet style="width:904px; height:1100px; background-color: #FFFFFF;"]1ANFTf9Eq8hqJr_Pb1rtN7VVkdHnNqNxZWrsn8XSA1bE[/gsheet]

[Wormopolis]

Jun 1, 2013 18:50:57 GMT -8 Wormopolis said:

whatever the key is to the hosted document. so a link similar to

https://docs.google.com/spreadsheet/pub?key=GKEY&output=html&widget=true

[ardodd]

@wormopolis,

I just downloaded the .pbp file and tried to open it and it would not open as it said the path was incorrect or the file was corrupt.

Any solutions to that problem?