google spreadsheet missing columns

  • 2
  • Problem
  • Updated 4 years ago
  • Not a Problem
Hello -

I am trying to use the google spreadsheet gadget. I am currently having 2 problems

1. I am missing columns from sheet in columns to format dropdown
2. I can't see my gadget on the display only in preview. (It is set to public on sheet)
Photo of ZygoSoundDSM .

ZygoSoundDSM .

  • 130 Points 100 badge 2x thumb
  • frusterated

Posted 4 years ago

  • 2
Photo of Blake Freeman

Blake Freeman, Official Rep

  • 36,116 Points 20k badge 2x thumb
ZygoSound,

Could you please give me the presentation ID so I can take a look?
Photo of ZygoSoundDSM .

ZygoSoundDSM .

  • 130 Points 100 badge 2x thumb
72bb02cc-d4d8-4351-b146-b6b5d00c4465
Photo of Blake Freeman

Blake Freeman, Official Rep

  • 36,116 Points 20k badge 2x thumb
ZygoSound,

It doesn't look like your spreadsheet is public, or published to the web. I cannot access the specific spreadsheet in question without requesting access. Can you please double check this documentation and verify that you have the correct permissions set?

Thanks!
Photo of ZygoSoundDSM .

ZygoSoundDSM .

  • 130 Points 100 badge 2x thumb
the permissions match what they should be. 
Photo of ZygoSoundDSM .

ZygoSoundDSM .

  • 130 Points 100 badge 2x thumb
It seems to be working now however i am still unable to configure all the columns
Photo of Blake Freeman

Blake Freeman, Official Rep

  • 36,116 Points 20k badge 2x thumb
ZygoSound,

It looks like adding a value to the first cells of each column below the headers it will allow me to format these columns.

This looks like a bug that I will be logging for our new release of this widget.
(Edited)
Photo of ZygoSoundDSM .

ZygoSoundDSM .

  • 130 Points 100 badge 2x thumb
This seems to fix my column issue. I still cannot get the data text color format to change though. When I configure it to be white but it still shows up black. as well as an image I have as a background will show in preview but not on my displays. It is direct link from dropbox. 
Photo of ZygoSoundDSM .

ZygoSoundDSM .

  • 130 Points 100 badge 2x thumb
ID: 72bb02cc-d4d8-4351-b146-b6b5d00c44654Y2B
Photo of Blake Freeman

Blake Freeman, Official Rep

  • 36,116 Points 20k badge 2x thumb
ZygoSound,

The current iteration of the spreadsheet widget does not support custom font colors in cells. You may want to check out the documentation for our spreadsheet widget feating custom layouts that is currently in beta.

For your background, when I copy the dropbox URL into a web browser I am getting a file not found error. You need to generate a valid link to the image for it to display as a background.