Just use my original code with the &single=true removed.

Thank you! Why don't make it default than?

Just did. :)

Been using this mod for a while but all of a sudden the spreadsheets dont appear anymore, no changes have been made tried other sheets as well but to no avail

Any ideas?

The spreadsheets still work on the demo page: http://www.qapla.com/mods/showthread...eets-and-Forms

So I don't think Google changed anything...

Can you post an example of one of yours that isn't working as well as copy the replacement code from the bbcode into a [code] box here?

Here is our main sheet on our site.
http://www.xboxplayers.co.uk/site/sh...2012-Standings

this is the bb code it has always had
this is the original document
https://docs.google.com/spreadsheet/...6b0FXV0E#gid=7

This is the replacement code
Thanks for your help

I don't know why you can't open it but my suggestion is to download a copy, reupload it, publish the new copy to the web and get the new code and use that- it worked for me.

You can edit your post with the new bbcode code.

Doesn't work for me under 4.2. Always there are now Spreedshet. It's says "Sorry, it's not public now"

It works on my 4.2.0 forum. Are you sure the documents are still public?

Demo: http://www.qapla.com/mods/showthread...eets-and-Forms

Your spreedsheet example is not showing on your site right now, sames as what we get, just blank space.

Resolved the above- it was a browser issuer.

I keep getting an error to it saying that the key is incorrect.
I followed the guidelines, can anyone help me out ?

Can you pste a key and document type here? Like spreadsheet 3ff456d75g5ge3wsdghjh?

so it loads up for me fine with the code but it keeps telling me sorry the file you requested is unavailable. Any thoughts?

edited NM i hade the code wrong I changed a ' to " originally before html in the code. I changed it back to a ' and it works great!!! Thank you for the mod

It looks like the share code for google spreadsheets has changed now. Trying to use it again but it just shows blank.

Looking at a link last month and the new share link the ccc?key= is now /d/

Last month link:

https://docs.google.com/spreadsheet/...UE&usp=sharing

Latest link:

https://docs.google.com/spreadsheets...it?usp=sharing

I am also getting a blank page. Your sample code works perfect. here is what I am using.

Just blank frame.

Just surfing on google and found this: https://support.google.com/drive/answer/3541068

"Starting in March and April 2014, Google Sheets users creating new spreadsheets will be automatically directed to the new Sheets. All previously created spreadsheets will remain in the older version of Sheets for now. If you need to create a spreadsheet using the old Sheets, you can do so at g.co/oldsheets"

Oops - just noticed you had this mod in the 4.x area. Pretty cool, thx! Like some users above, , I removed the "single=true" portion of the GS tag so that users could click multiple sheets.

Any hints on how to do a google chart? I see the publish code on a chart is a bit different than the docs/spreadsheets.

Thx!

Google docs also has a PDF viewer.
How do we get this to display? Do we click share and take the link, change who has access to 'public on the web'?

Sorry, new to google docs but I have some PDF's that may well prove useful.

Ta...

OK - so for Google charts, we are a bit stuck because ideally we would have 4 {param}'s available. As it stands now, we have two:
{param}
{option}

So I've set option = google charts "oid", and param = google charts chart number. I've hard coded the width to 800 and height to 600, and let users know they need to size their published charts to this size. Shy of installing a mod allowing multiple {param}'s, this is where we are. But it works well.
:)

Title: Google Chart
BB Code Tag Name: BB Code Tag Name
Replacement:

Example:
Description:
Use {option}: yes
Button Image (Optional): -- create an image if you desire --
Remove Tag If Empty: yes
All other Disable options: yes

Feel free to clean it up more, but that gets it going at least. :)

Thanks; this made my day!

Hmm, I tried messing around with it but can't seem to get it to work. The new spreadsheet link that is.

Anyone else get it working?

Key= has been replaced with /d/ now


Edit: I think I fixed it. Not positive. But here is the new code.

I replaced the /Key= part with /d/{param}/edit#gid=0 in both html lines, and it worked for me.

Edit 2:when it loads the spreadsheet it sends you to the top of the page. also if you click in the spreadsheet after clicking out of it, it will send you to top of the page. No idea how to stop that.

Can anyone assist with this? After the changes were made by Google, I use the /d/ now and it loads the spreadsheet just fine, but now instead of just the cells appearing, I get the entire Spreadsheet including the Tools at the top.

For example:

I'm looking to see just this:

https://vborg.vbsupport.ru/external/2014/10/9.png

What I'm actually seeing:

https://vborg.vbsupport.ru/external/2014/10/10.png

Any way to clean this up that anyone knows about?

Does the same for me shows everything, guess will stick to using the iframe code they give for the embed share link.

Ok tried for about 3 weeks to get google spreadsheets working on vb 5.2.6 then on vb 5.3.0 alpha as it is something i really needed the way i was getting them to display the sheet was to embed it with iframe and to do this i had to enable html which is not a good idea so it was left to me do update the sheets.
I finally got it working the solution was staring me in the face i got the google docs working no problem but the spreadsheet would not so i compared the 2 sets of replacement code the spreadsheet code used single qoute ' instead of double qoute " so this is the amended code i am using now and works a treat

Many thanks for this.
Regards Willie

Here is a quick and easy way to install these bbcodes it can be done in admincp or in phpmyadmin simply run the sql query below i have tested this method on all versions of vbulletin from vb3.6.8 through 5.3.0 and it works on all versions though you may need to edit 1 word depending if you set a prefix for db tables the simply put the prefix in front of bbcode example is vbbbcode

VB 5.x doesn't have a plugin system to which this code would be compatible, FYI.

It is actually running on my main site which can be seen @ this post https://cometbar.co.uk/forum/darts/4...pionship-stats

also have it installed on various versions of vb

My bad I thought you were supplying plugin code. Your code makes direct alterations to the BBCode table. Guess I should have looked closer.

I would still advise caution, there are reasons manual edits to database tables are last resorts. People shouldn't get in the habit of inserting BB Codes via direct queries. One mistake/typo and you can screw up your site.

I do agree there if you are not comfortable altering the database then leave it alone this is why i always use one of my my testing sites on my laptop before i put anything on my live site also i backup the database beforehand.

i am curious of this too....the extra header can be a security concern would be nice to hide it....also it now added a chat as well, which we dont really want....i tried hiding them by css, even tho its loading the main sheet from google, but fail...not sure what else to even try...

also have got errors loading spreadsheets like this:


be nice to clean it up and secure it a little better but seems to basically work..vb4.2.5 php 5.6


oh and btw, that is result by using this replacement code which is the one that seemed to work for me

Add to your bbcode remove the toolbars.

Eg:

that works perfectly thank you....i tried the same however for the google docs and didnt seem to work..is it slightly different there? i know that first part at least is the same with the updated "htt ps://docs.google.co m/document/d/{param}" format but the after part i tried matching your ss code then a few other ways and still failed..

Try this for a Google Doc.

works if you take the /e out thanks

Someone PMed me this question-

There was a screenshot.

Unfortunately I do not know of any fix. It was never intended for mobile devices, sorry.

If anyone finds a mobile friendly bbcode feel free to release it here or as your own mod, no permission needed.

Thanks for taking the time to respond, BOP.

All I know is the problem seems to stem from something vB's default directives are controlling. This seems so because I can alter the replacement code parameters in a multitude of ways but the footer bar & tab across the content area issue persists no matter what changes I make. I should also note that it's the 'height' aspect that's compressed and frozen when a sheet is viewed on a narrow, mobile screen. That results in the footer bar and the sheet tab perpetually obstructing the sheet's content. They remain there even when using Google's own generated embedment code, and even with the widget directive set to false (which should toggle off the sheet tab that appears on the overlapping footer bar). Also, when the mobile style is viewed on a larger screen, all aspects become rendered correctly (i.e., the footer bar, the sheet tab, etc. are each in place). So it seems vB is restricting the height of the display area for embedded documents on the mobile style. As such, if I could learn how to get my vB4 to allow mobile style height flexibility I'm guessing it would fix the problem. Someone smarter then I would have to determine how that might be done, though.

Edit: Just some further information. The scope of this problem is somewhat different from my initial assumption. I've tested the issue on two Samsung mobile devices. As it turns out, when in vB full desktop version mode the iframed sheets display in the identically compressed and distorted state that I'm seeing in vB mobile mode. Oh, and the issue is browser independent as well... at least among the three mobile browser versions I have tested (i.e., Google Chrome, Firefox, and the browser that comes pre-loaded on Samsung devices). So to summarize, the iframed Google sheets simply will not render properly on these mobile devices - through iframes on vBulletin forum sites at least. But they render amazingly well with full synch'ing/linking control and visibility on my desktop and laptop computers. They even present quite well in vB mobile mode on those computers. Therefore, the screen dimensions on my phone are obviously not the issue. I can't imagine what it would take to get this working on these phones.

Edit2: I've been able to get it to display on my mobile device without the obstructive sheet tab bar blocking the sheet's content on the phones. However, sheet cells are not editable under the required configuration. It is thus exclusive to displaying the sheet's data. So for editing the sheets, I've employed a workaround by adding another bbcode item that can quickly and easily be toggled and saved through a post edit, then switched back to the frozen data display mode using the original bbcode tags, allowing the data to again be seen on mobile devices. I can also add some buttons to the editor, making it even a bit more convenient.

https://vborg.vbsupport.ru/external/2018/10/5.png

I have not been able to get this to work with the original code nor the code provided by others. Does anyone have this working or know how to? The Google Docs is my primary need.

Try this: