Google Spreadsheet Gadget Problems (Formatting and Saving)

  • 1
  • Problem
  • Updated 4 years ago
  • Not a Problem
Yesterday I had some troubles formatting my Google Spreadsheet Gadget in my presentation. I have a Spreadsheet with several worksheets worth of information I wish to format in the gadget, but whenever I try to display the information, the column descriptions sometimes disappear. This problem is not specific to any one worksheet, but it seems different worksheets have different problems, and some work perfectly fine. 

Today I was attempting to work around this and find out what was causing the formatting issue, but now I cannot save any changes to a Google Spreadsheet Gadget at all. I click the Save button after making changes, but nothing happens. Occasionally, I will also get an error stating that the Spreadsheet cannot be read and to make sure it is published to the web. I have also done this multiple times, both with the actual link and with selecting it via Google Drive. 

System Information:
OS X 10.8.5
2.5 GHz Intel Core i5
4 GB RAM
Google Chrome 38.0.2125.104
Photo of Colin Quinn

Colin Quinn

  • 300 Points 250 badge 2x thumb

Posted 4 years ago

  • 1
Photo of Neal

Neal

  • 61,252 Points 50k badge 2x thumb
Hi Colin,

Can you confirm that the spreadsheet you are using has been published? The only time I've come across that message is when the spreadsheet I selected via Google Drive wasn't published to the web already.

Thanks.
Photo of Colin Quinn

Colin Quinn

  • 300 Points 250 badge 2x thumb
Thanks for your reply, Neal. Yes, I have confirmed that the spreadsheet is published. When I choose it from the Google Sheets menu I get a small message of "This document is published to the web."

EDIT: So I deleted the Spreadsheet placeholder and made a new one from scratch, and now it is working again. I am, however, still having the formatting issue as detailed in my first post. Is there any way to make the header two rows instead of one? I have a title for the worksheet and titles for each column.
(Edited)
Photo of Neal

Neal

  • 61,252 Points 50k badge 2x thumb
In the Spreadsheet Gadget settings, you can set the Number of Header Rows to 2 (or more).


This will allow the 1st and 2nd rows in the spreadsheet to be used for headers.

Thanks.
Photo of Colin Quinn

Colin Quinn

  • 300 Points 250 badge 2x thumb
I did do this, but instead of having two rows of headers, it combines the two rows into one and just sticks them next to each other. 



It should have Boys Soccer Records and Awards as the title, and then below have Event, followed by each title afterwards. Is this possible?
Photo of Neal

Neal

  • 61,252 Points 50k badge 2x thumb
Are any of the cells merged? I only ask because the Spreadsheet Gadget doesn't handle merged cells.

You may need to utilize a custom layout to get the look you want.  You can find out more regarding custom layouts for the Spreadsheet Gadget here.

You may also consider combining the Text Item for showing just the title, and then the Spreadsheet Gadget for the rest of the items. This would involve removing the title from the first row in the spreadsheet since the Text Item will be doing that. Then just have the one header row in the settings.
Photo of Colin Quinn

Colin Quinn

  • 300 Points 250 badge 2x thumb
Thanks for your continued replies, Neal.

I tried your workaround with using a Text Item for the title and that works, but I'm curious. The custom layouts page doesn't speak very much about how the Heading part of the gadget actually works, is there a way to use a custom layout to have two Heading rows, instead of just one?
Photo of Neal

Neal

  • 61,252 Points 50k badge 2x thumb
Colin,

Did some further digging.  It doesn't appear that a custom layout will work in this case. It appears that the contents of the rows are merged and treated as one.

Utilizing the Text Item and Spreadsheet Gadget combo seems like the best alternative.

Thanks.