Feedback regarding the Spreadsheet Widgets

  • 3
  • Idea
  • Updated 4 years ago
  • Implemented
We are looking to see how much interest there is in regards to custom layouts in the Spreadsheet Widget.  Are custom layouts something that you use frequently in your Presentations?

If you're interested in seeing this added to the Widget, can you please like this topic?

Thanks.
Photo of Neal

Neal

  • 61,252 Points 50k badge 2x thumb

Posted 4 years ago

  • 3
Photo of Matthew

Matthew

  • 970 Points 500 badge 2x thumb
To begin with, the continuous scrolling feature doesn't exactly continuously scroll anymore.
It resets and transitions at the end of the list over and over and over which looks quite terrible especially if you have a list/column that has maybe 2 or 3 extra rows in it.

The custom CSS is not accessible through the widget.
This is an absolute MUST HAVE feature, especially if you expect anyone to pay for it in the near future. (which seems to be the business model supported by your company,  starting completely free, rapidly increasing your customer base and building a product that people enjoy using then once they're hooked, gradually charging for feature after feature until there are only a few limited free items or trials to use)

Custom CSS is useful in a lot of ways, like embedding font styles, font shadows, etc...

Column Padding is gone... This helped out occasionally and would be nice to see this again.

Decimal Place option would be nice as well.

Honestly I can't think of a single feature on the previous version that doesn't need to be included in the new one. Including custom layouts. I never took advantage of this feature, but I planned on trying it out in the future and I can see its usefulness.
Photo of Blake Freeman

Blake Freeman, Official Rep

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

Thanks for your in depth response, we appreciate you spending your time explaining your position to us.

All of your issues will be brought up with development and considered. However I would like to state at this time that the spreadsheet widget is not just free, it's open source. The source code is available to the public. There are no plans to make this a paid widget.
Photo of Matthew

Matthew

  • 970 Points 500 badge 2x thumb
What about keeping the old spreadsheet widget hosted? Or is it considered a Gadget? I've downloaded the source code to possibly host it myself, but there are a lot of external dependencies in just about every file that have some wild paths. And I haven't had the time to learn how to integrate the widget into Rise yet...
Photo of Blake Freeman

Blake Freeman, Official Rep

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

You can certainly host the old spreadsheet gadget yourself, however Google is in the process of converting their old spreadsheets to a new format. This new format has considerable issues with the old spreadsheet gadget.

Stay tuned for a community announcement on the new google sheets format soon.
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Thanks for this very helpful feedback Matt. 

Regarding Decimals, in the section "Columns", if you select the Number Column, one of the options available is to add the amount of decimals you want to show in the Widget. Is that not working for you?
Photo of Matthew

Matthew

  • 970 Points 500 badge 2x thumb
I did a brief overview of the comparison side by side to see any missing features. I did not however see this option but I could have easily overlooked it.

For the time being we are just copying previous presentations that already have the old Google Spreadsheet widget to keep our customization, but they tend to have issues with Google Drive's new spreadsheets which are officially being phased out.

The biggest problem for us (and this is not related to the feature list necessarily) is that we sometimes embed the share link inside of another third-party digital signage software as an HTML component, using Rise as a widget itself. HTML component refuses to function properly inside of an Adobe AIR environment using the built in Adobe Flex browser. However, the previous version of the Google Spreadsheet Widget/Gadget/WhatChaMaCallit had no problems. I downloaded a test environment for Adobe Flex and replicated the issue. I've scoured the source code for potential issues, but the possibilities are almost endless. It could be a Javascript incompatibility most likely. But using HTML5test.com I was able to dicate about a 400 point different between Chrome and Adobe Flex browser capabilities. Since we cannot use the new version of the widget inside of this software we are required to backtrack to the older version to continue using the spreadsheet functionality.
Photo of Kevin

Kevin

  • 390 Points 250 badge 2x thumb
How can we do customized CSS in the new widget? I used to set up gradient fades for rows and can no longer do so. 

Is there an easy way to use gradients or background images in the tables for Google Spreadsheets?
Photo of Blake Freeman

Blake Freeman, Official Rep

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

I believe this will have to be done using a custom layout. You can find that documentation here.
Photo of Matthew

Matthew

  • 970 Points 500 badge 2x thumb
This is highly inconvenient. The customization should be easily accessible as in the previous widget. Why can this not be? Sure a simply form field and a few lines of php to inject the code in the proper place and a lot of your customers would be much happier with their experience that seems to continuously degrade over time through these "upgrades" and "updates" that just make the product less usable. Trying to put people in a small box. Something you might expect if Steve Jobs were the executive of your company.