Google Spreadsheets Revs Desktop Features, Performance - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Cloud // Software as a Service
09:48 AM
Connect Directly

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.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
2 of 2
Comment  | 
Print  | 
More Insights
How to Create a Successful AI Program
Jessica Davis, Senior Editor, Enterprise Apps,  10/14/2020
Think Like a Chief Innovation Officer and Get Work Done
Joao-Pierre S. Ruth, Senior Writer,  10/13/2020
10 Trends Accelerating Edge Computing
Cynthia Harvey, Freelance Journalist, InformationWeek,  10/8/2020
White Papers
Register for InformationWeek Newsletters
Current Issue
[Special Report] Edge Computing: An IT Platform for the New Enterprise
Edge computing is poised to make a major splash within the next generation of corporate IT architectures. Here's what you need to know!
Flash Poll