Google Spreadsheets Macros and List Mode Editing

Google Spreadsheets Macros and List Mode Editing
By Tony Ruscoe

It seems a bunch of new functionality might be coming to the Google Docs spreadsheets application. By accessing one of Google's experimental sites (like the one where I found offline access would be coming to Google Docs) I was able to get a sneaky look at some of this functionality, including the ability to record, edit and run macros, edit a shared spreadsheet in something called "List mode" and a few new functions for use in spreadsheet formulas.

Macros

For those unfamiliar with advanced features offered by desktop office applications, a macro is a set of instructions that can be used to automate a series of actions in a program. You can usually record the actions as you carry them out in real-time or edit the macro code directly. Here's a screenshot showing what macro recording in Google Spreadsheets currently looks like:

Since I've opted to display the macro code being created, anyone who knows a bit of JavaScript should be able to work out that I've basically highlighted a column, made the contents bold and set the background color to green. For more advanced users, there's the option to edit the code for all the macros directly, giving each one a different function name:

Once again, it's quite obvious that this functionality is still in the very early stages of development. During my tests, I was unable to actually get any of my saved macros to run! (Each time I selected "Run Macro..." from the menu, I got a "macroNameNotFound" error popping up.)

List mode editing