Google updated spreadsheets this weekend with some new features across the board. While they are all useful, it is particularly nice to be able to edit spreadsheets on my iPhone.
- A mobile-friendly view with filtering, sorting and row-by-row editing
While this works in other mobile devices (Android, Symbian, etc), I've tested it on the iPhone and it works fairly well. You aren't going to be building complex spreadsheets on your iPhone anytime soon, but it is easy and straightforward to edit existing spreadsheets or even create a new one from scratch.
The interface has been updated and can be used in portrait or landscape mode. Take a look at the screenshots.
Once you click Edit, you are given fields to edit. Very simple and straightforward.
Google also improved a few other spreadsheet functions in this update. Among them: The ability to define attributes of a cell and require that input meets those datavalidation rules.
- A form summary page with information about completed responses
To use data validation, select a cell from your spreadsheet, click 'Tools' from the menu bar and choose 'Data validation'. Enter your attributes and click 'Save'.
To view the form summary page, click 'Form' from the spreadsheet menu bar and choose 'Show summary'.
For more information, check out the Google Docs Blog.
This story, "Edit Spreadsheets on Your iPhone" was originally published by Computerworld.