Spreadsheet
-
I’m trying to embed a Google sheet into my blog, but the formatting is all wrong on the resulting page. Cells are merged for one. In one row I have a cell with data and nothing in the adjoining cells and they get merged. On another row the same setup, yet they aren’t merged.
If you go to my blog (still in its infancy…) and look at the ‘List’ menu, you will see what I mean. The source document appears fine.
I even tried saving my Google Sheet as an Excel file and it doesn’t merge the cells.
Not sure what to do here…
The blog I need help with is: (visible only to logged in users)
-
Hi there,
Can you give a link to the post/page where this is happening?
We have very little control over content that gets embedded from other services. When you paste an embed link in a post, we send a request to Google for the data at that link, and they send us back, essentially a mini website in its own little frame. What appears in that frame is entirely controlled by Google. We can control the frame itself, e.g. the size at which it appears on your site, and how it’s positioned, but not what’s inside it.
So while I’m happy to take a look at this for you, if this is how the data is being sent across from Google, there’s not really anything we can do.
-
That is kind of odd, I’m not sure where that could be coming from. To be clear very little happens on our end with this embed, we basically just display what Google tells us to, just like embedding a YouTube video.
We do control the width of the embed, based on the theme, but that should just result in the document scrolling horizontally (which it does), not in full formatting changes like cells being merged and borders being lost.
Are you able to test embedding this spreadsheet anywhere else?
-
Not at the moment. I used to dabble in webpages years ago, but it’s a lot different now in some respects. Not sure where I could test an embed elsewhere. I remember being able to host it on my local PC to test before publishing it. Just can’t remember the software to do that.
I did just test it on the MS Edge browser with the same results along with the Silk browser on my Kindle and my phone which uses Chrome. I’m pretty sure Firefox would do the same. Chrome is my main browser on my PC.
Any suggestions on places I could test embedding my spreadsheet?
-
Hi there,
You can install WordPress locally on your computer and test how that sheet is embedding. Here’s a guide on how to do that:
- The topic ‘Spreadsheet’ is closed to new replies.
WordPress.com Forums 