Follow Us

We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message

Google bolsters spreadsheet app; adds first offline mode

Big step forward for users

Article comments

Google has rolled out an overhauled version of its Sheets spreadsheet app, bringing more capabilities and offline mode to its suite of cloud-based productivity tools.

Some limits that were in place in the earlier version including a cap on the number of cells that could be copied and pasted, as well as a limit to the total number of cells possible in a given sheet have now been either removed or made less strict, according to an official blog post.

Google also brought expanded function help for mathematics, including error highlighting and example functions. Code tweaks have been included to make calculations, scrolling and loading data much speedier than before, and other little improvements like automatic text wrapping for lengthy sentences have been added as well.

But the biggest change may be the inclusion of offline mode, which allows users to edit a spreadsheet without an Internet connection. Previously and unlike its Google Drive stable mates Docs and Slides Sheets couldn't be used without Internet access. Now, however, edits to Sheets made while offline can simply be synched automatically when the connection is restored. That's an important addition for users who need to be able to work while in transit, and could strengthen the case for using Google Drive in the enterprise.

The offline feature, however, won't work with spreadsheets created before you switch to the new version of Sheets, according to TIME tech blogger Harry McCracken, so those will have to be re-created after opting in via Drive settings.

Additionally, users who require protected sheets and ranges, *.ods import and export, some Apps Script functions and Gdata API support should hold off on trying out the new version of Sheets, as those are not yet enabled. Google says they're on the way, however.

Email Jon Gold at and follow him on Twitter at @NWWJonGold.


More from Techworld

More relevant IT news


Send to a friend

Email this article to a friend or colleague:

PLEASE NOTE: Your name is used only to let the recipient know who sent the story, and in case of transmission error. Both your name and the recipient's name and address will not be used for any other purpose.

Techworld White Papers

Choose – and Choose Wisely – the Right MSP for Your SMB

End users need a technology partner that provides transparency, enables productivity, delivers...

Download Whitepaper

10 Effective Habits of Indispensable IT Departments

It’s no secret that responsibilities are growing while budgets continue to shrink. Download this...

Download Whitepaper

Gartner Magic Quadrant for Enterprise Information Archiving

Enterprise information archiving is contributing to organisational needs for e-discovery and...

Download Whitepaper

Advancing the state of virtualised backups

Dell Software’s vRanger is a veteran of the virtualisation specific backup market. It was the...

Download Whitepaper

Techworld UK - Technology - Business

Innovation, productivity, agility and profit

Watch this on demand webinar which explores IT innovation, managed print services and business agility.

Techworld Mobile Site

Access Techworld's content on the move

Get the latest news, product reviews and downloads on your mobile device with Techworld's mobile site.

Find out more...

From Wow to How : Making mobile and cloud work for you

On demand Biztech Briefing - Learn how to effectively deliver mobile work styles and cloud services together.

Watch now...

Site Map

* *