Where can I access the Google spreadsheet gadget default layout xml?

  • 1
  • Question
  • Updated 4 years ago
  • Answered
I have checked code.google and checked out the subversion repository however was unable to find the default table xml anywhere (although I did find old files which may have used to have been the default xml).

I need to make a one line css change to this file for one of my displays and hope that a swift response from you will help me avoid having to rewrite the entire layout.

Thank you
Photo of Techwise

Techwise

  • 762 Points 500 badge 2x thumb

Posted 5 years ago

  • 1
Photo of Neal

Neal

  • 61,252 Points 50k badge 2x thumb
You can find the table xml at https://s3.amazonaws.com/Gadget-Sprea... and the css for it at https://s3.amazonaws.com/Gadget-Sprea...

Hopefully this was fast enough for you.

Thanks!
Photo of Techwise

Techwise

  • 762 Points 500 badge 2x thumb
Hi Neal

This is also the xml which I was attempting to use.

Unfortunately there is a big difference in the output when I supply this xml as the layout vs when I click the use default layout button.

If at all possible we would like to see the layout so we can easily make this small change, alternatively we will look at recreating with a custom style.

Thank you
Photo of Donna Peplinskie

Donna Peplinskie

  • 7,142 Points 5k badge 2x thumb
Hi Techwise,

There isn't actually a default layout that the Gadget uses. When Use Default Layout is checked, the Gadget programmatically builds a table based on the data that is in the spreadsheet. The XML that you downloaded is just an example layout. It's not actually used by the Gadget in any capacity, and you don't actually need the CSS file. The CSS is already embedded in the XML.

Have you seen our Developer documentation on the Google Spreadsheet Gadget? There is an entire section there on creating a custom layout. In particular, if you want to use the sample table layout, you'll need to customize it to match the number of columns in your spreadsheet.
Photo of Techwise

Techwise

  • 762 Points 500 badge 2x thumb
Thanks Donna.

Basically we just want to add a single css line to the layout which is used when no layout xml is provided. Is this at all possible?
Photo of Donna Peplinskie

Donna Peplinskie

  • 7,142 Points 5k badge 2x thumb
You'll either have to create a custom layout as per the above instructions, or modify the CSS file you downloaded earlier, host it somewhere, and then create a custom version of the Gadget that points to that new CSS file when a default layout is used. The link to the CSS file is specified directly in the Gadget's code and is not surfaced as a setting, so that would be the only other way you could do it.

Thx.
Photo of roda signage

roda signage

  • 214 Points 100 badge 2x thumb
Be also aware that some css declarations are overwritten by the configuration of the spreadsheet if you change fields there !  So the CSS is leading for some but not all configuration settings.