Public Beta 10
Public Beta 10 (rev 3604) is a major release that sees the incorporation of a number of new, unique and exciting interoperability features. These include:
- EditGrid API official launch. After nearly two months of trial run at
EditGrid Labs Sandbox, the EditGrid SOAP API is now official launched and incorporated onto the main site. Users may now write their own program to access data on EditGrid spreadsheets with the right AppUserKey for authentication. - EditGrid Add-ons. With the advent of EditGrid API comes the opportunity for users to submit their own applications on top of EditGrid spreadsheets. Developers in the EditGrid interop team have taken the lead and implemented a number of add-ons that mash up the Google services. These include:
- Grid Translate — translate part or whole of a spreadsheet using Google Translate
- Grid2Calendar — convert a schedule on EditGrid into data feeds that can then be subscribed and displayed using Google Calendar
- Grid2Map — mark points on a spreadsheet on Google Maps
- Search2Grid — analyse search engine results on a spreadsheet
- Submission and publication of user-written add-ons will be supported in a subsequent release. For more information on the Google add-ons, please refer to Reggie’s post on the EditGrid Blog.
- EditGrid Sync. Another graduate of EditGrid Labs, this desktop application for MS Windows 2000/XP allows users to synchronise spreadsheets on EditGrid with the counterparts on desktop.
- XML export. A simple presentation of the spreadsheet data in XML format as obtained by appending .xml to a spreadsheet’s permalink. Advanced uses include:
- specify a remote XML stylesheet right at the URL to produce the desired XSLT, in this manner:
- http://www.editgrid.com/user/a_user/a_spreadsheet.xml
?xsl=http://my.ho.st/my.xsl
- http://www.editgrid.com/user/a_user/a_spreadsheet.xml
- specify content type of the exported xml, in this manner:
- http://www.editgrid.com/user/a_user/a_spreadsheet.xml
?content-type=application/vnd.google-earth.kml+xml
(NB: the same method also works for cell-level permalink, in this manner: - http://www.editgrid.com/user/a_user/a_spreadsheet/Sheet1!A1
?content-type=application/vnd.google-earth.kml+xml)
- http://www.editgrid.com/user/a_user/a_spreadsheet.xml
- combination of the above using &
- More information on this, as well as sample uses, to follow.
- specify a remote XML stylesheet right at the URL to produce the desired XSLT, in this manner:
Also deployed since this release is the Japanese version. Congratulations to all contributors to the Japanese translation spreadsheet, as part of the EditGrid Localisation Project (currently offline - 2008-03-13).
Fixed in this release:
- [#5046] Fixed bug where email addresses are not recognised properly
There are also new functionalities supported by API since this release. These include:
- Methods for row/column insertion/deletion
- ClearCells method

