Google spreadsheet widget formatting

  • 3
  • Question
  • Updated 1 year ago
  • Answered
I have a question.  Why does the Google spreadsheet widget not allow pass though formatting?  There are several things that can be done that are actually very cool in the way of conditional formatting in the Google spreadsheet and we've found none of them can be used with this widget.  I was just curious if there was a specific reason for that.  
Photo of tony

tony

  • 11,670 Points 10k badge 2x thumb

Posted 3 years ago

  • 3
Photo of Blake Freeman

Blake Freeman, Official Rep

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

We created the spreadsheet widget as an easy base for future releases. We've updated it since the initial release with the addition of using custom layouts, and more improvements are on the way.
Photo of tony

tony

  • 11,670 Points 10k badge 2x thumb
Is there a plan to allow spreadsheet to take advantage of the already great conditional formatting features that Google has built into it?  
Photo of Blake Freeman

Blake Freeman, Official Rep

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

I know discussions about the spreadsheet widget are currently on the table. I'll pass this request along.
Photo of tony

tony

  • 11,670 Points 10k badge 2x thumb
Thank you again.  As Rise continues to improve so does Google Docs.  Allowing them to do their thing can be a powerful combination.  
Photo of Blake Freeman

Blake Freeman, Official Rep

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

I have spoken with our developer for this widget. It's unclear if there were changes to Google's visualization API, or to the new sheets format, but currently requests to Google Sheets for style properties are coming back empty. It's something that we're looking into, however I have no timeframe or guarantees that this will change.
(Edited)
Photo of tony

tony

  • 11,670 Points 10k badge 2x thumb
Yes.  We are working on a project that is using a lot of the capabilities of the Google spreadsheet itself.  We are using the Web Page widget rather than the spreadsheet widget because it allows the full use of the spreadsheet features.  This is a strong tool when the signage is targeted in more data driven industries as opposed to visual signage for marketing and entertainment.  
Photo of Clefhanger

Clefhanger

  • 120 Points 100 badge 2x thumb
Has development on this stalled or is google limiting access to style properties? Virtually none of the formatting in a google sheets gets passed on to the display via the google sheet widget. Alignment, line breaks, color fills, column widths. I'm having to virtually recreate the spread sheet within RiseVision through trial and error. i.e... lets try a column width of 50px... oops, not enough, try 100... oops, too much, try 80... infinitum ad nauseum. So, unless I'm missing the forest for the trees, (which is entirely possible) the time I have to spend re-editing the format of the spreadsheet via RiseVision makes it inefficient and useless. Thanks in advance for any help
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Hi there Clefhanger,

None of the formatting from a Google Sheet is carried over, so you would need to rely on the formatting settings from the Widget settings itself.

I hope that helps!
Photo of Matthew

Matthew

  • 970 Points 500 badge 2x thumb
You CAN use HTML <tags> to format your text in certain cases. It always breaks the headers, but you are able to bold certain things, insert images with <img> HTML items etc... Its very limited but it works in dire circumstances... Especially to differentiate individual items in a large group of data and make them stand out....