Google spreadsheet widget formatting

Comments

11 comments

  • Avatar
    Blake Freeman
    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.
    0
    Comment actions Permalink
  • Avatar
    Tony Sehy
    Is there a plan to allow spreadsheet to take advantage of the already great conditional formatting features that Google has built into it?  
    0
    Comment actions Permalink
  • Avatar
    Blake Freeman
    tony,

    I know discussions about the spreadsheet widget are currently on the table. I'll pass this request along.
    0
    Comment actions Permalink
  • Avatar
    Tony Sehy
    Thank you again.  As Rise continues to improve so does Google Docs.  Allowing them to do their thing can be a powerful combination.  
    0
    Comment actions Permalink
  • Avatar
    Blake Freeman
    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.
    0
    Comment actions Permalink
  • Avatar
    Tony Sehy
    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.  
    0
    Comment actions Permalink
  • Avatar
    Les Earwood
    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
    0
    Comment actions Permalink
  • Avatar
    Robb Price
    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!
    0
    Comment actions Permalink
  • Avatar
    Matthew Trigg
    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....
    0
    Comment actions Permalink
  • Avatar
    Westernstates4480

    Is there any plan to pass through formatting? If so, when is that expected?

    If not, then every time the google sheet is updated you need to reformat the document using the widget?

    0
    Comment actions Permalink
  • Avatar
    Robb Price

    Hi there,

     

    There are no plans at this time, but we will let everyone know if that changes anytime in the future. 

     

    Thanks!

    0
    Comment actions Permalink

Please sign in to leave a comment.