Cloud // Software as a Service
News
4/14/2010
09:48 AM
Connect Directly
Facebook
Google+
LinkedIn
Twitter
RSS
E-Mail
50%
50%

Google Spreadsheets Revs Desktop Features, Performance

Video shows how more muscle for scrolling and moving or freezing rows and columns highlight Google's updated Spreadsheets app.

For example, for anyone who has tried to move a row or column in Google Spreadsheets before, the process was incredibly laborious. It involved selecting the column and then using the menus to move the column one notch at a time. Then, if you wanted to move the column any further, it had to be re-selected again, and moved another notch. Now, the columns behave much more like those of a desktop spreadsheet where you can grab them with the mouse and move them as many notches to the right or left as you need.

Additionally, as can be seen in the video, freezing rows and columns is much easier and the art of constructing a formula has been greatly improved through the deployment of an experimental feature called “formula highlighting." Now, when assembling a formula that references other cells or ranges in a spreadsheet, matching colors are applied to each reference (in the formula) and the border of the cell or range it applies to. This feature is harder to describe than to see (be sure to check out the video).

Google Spreadhsheets also received a performance boost in its scrolling ability through large spreadsheets. As Ho describes it in the video, users on the old version of Google Spreadsheets would sometimes notice what he called the blue screen of slowness. This is where attempts to scroll large numbers of rows at a time resulted in a blank blue screen while the browser, the network, and the back end of Google Spreadsheets caught up. This typically doesn't happen with desktop spreadsheets. In the video, Ho shows what the blue screen of slowness looks like in the old version and then how the lag time was eliminated in the new version.

One other little bit of icing on the cake that Ho says users asked for: autocomplete. The old version didn't have it. The new version does. You can see it, too, in action in the video below.


Previous
2 of 2
Next
Comment  | 
Print  | 
More Insights
8 Steps to Modern Service Management
8 Steps to Modern Service Management
ITSM as we know it is dead. SaaS helped kill it, and CIOs should be thankful. Hereís what comes next.
Register for InformationWeek Newsletters
White Papers
Current Issue
InformationWeek Tech Digest - August 27, 2014
Who wins in cloud price wars? Short answer: not IT. Enterprises don't want bare-bones IaaS. Providers must focus on support, not undercutting rivals.
Flash Poll
Video
Slideshows
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Howard Marks talks about steps to take in choosing the right cloud storage solutions for your IT problems
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.