XF 2.2 Embedded Spreadsheet

[Joan1211]

Hello,
How can I embed a spreadsheet?
I have tried many tutorials, using BBCode and Import Media, but they don't seem to work. I might not be executing the steps correctly.


Here is the code I receive when I click on "publish on the web":

Embaded code:

<iframe src="https://docs.google.com/spreadsheets/d/e/2PACX-1vS0dpVO92b1_4CUjFNd-fyOGPkXcmk2C3B5SPs-foxlwDoKNwfwW-q1qxIGy2xzO5rHf7kMyUu8NZfa/pubhtml?gid=0&amp;single=true&amp;widget=true&amp;headers=false"></iframe>

Link:

https://docs.google.com/spreadsheets/d/e/2PACX-1vS0dpVO92b1_4CUjFNd-fyOGPkXcmk2C3B5SPs-foxlwDoKNwfwW-q1qxIGy2xzO5rHf7kMyUu8NZfa/pubhtml?gid=0&single=true

Thank you.

 

[Joan1211]

Xenforo support informed me that i need to create a custom BBcode.

I have tried this option before, but this did not work. The tutorial i found are propably too old.

Anyone can help with this?

Thanks.

 

[Paul B]

Note that anyone who knows the tag will be able to embed this in any post.

 

[Joan1211]

Thank you, this works perfectly!

 

[Alan_SP]

It may be better to use variable parameter, so you can embed different spreadsheets? Of course, if you want to do that.

In HTML replacement part put this:

<iframe src="https://docs.google.com/spreadsheets/d/e/{text}>/pubhtml?gid=0&amp;single=true&amp;widget=true&amp;headers=false"></iframe>

And within new BBcode you put variable part, in your case it's this:

2PACX-1vS0dpVO92b1_4CUjFNd-fyOGPkXcmk2C3B5SPs-foxlwDoKNwfwW-q1qxIGy2xzO5rHf7kMyUu8NZfa

In above's example it would be:

<spr1>2PACX-1vS0dpVO92b1_4CUjFNd-fyOGPkXcmk2C3B5SPs-foxlwDoKNwfwW-q1qxIGy2xzO5rHf7kMyUu8NZfa</spr1>

It would work for all different spreadsheets.

 

[Joan1211]

Thank you.
One small correction:

<iframe src="https://docs.google.com/spreadsheets/d/e/{text}>/pubhtml?gid=0&amp;single=true&amp;widget=true&amp;headers=false"></iframe>

for it to work there is no

>

before

/pubhtml?

This code is great for variable spreadsheet. However this mean that all the spreadsheet will have the same displayed size.I configured mine to have 3000px, therefore all the spreadsheet will have 3000 px.

i tried to remove the size from the HTML replacement and to insert it here:

[spr1 width="100%" height="3300px"]spreadsheetID[/spr1]

But this did not work.

 

[Alan_SP]

Yeah, I somehow made error in copying. Who knows how that happened.

And, from original code, I don't see info on width and height, so I'm not sure where and how you're inserting it. You should find it first in original Google insert code, to know where they expect it to see that information.