Public Beta 11 (rev 3803) continues the blended roll-out of major spreadsheet functionalities and unique interoperability features together. The notable new features are:

• [#3947] Freeze pane
• [#4614] Recalculate all formulae
• [#5080] Web fetch — fetch content from a given URL (accessible at the Remote Data toolbox), automatically updated every 30 minutes
• [#5054] My data format — allow user-defined file extensions through XSLT (accessible at Sheet Properties > My Data Format)

Also deployed since this release is the French version. Congratulations to all contributors to the French translation spreadsheet, as part of the EditGrid Localisation Project (currently offline - 2008-03-13).

Other new features include:

• [#3852] List recently modified spreadsheets on home page
• [#5146] Menu item for cell/range lock
• [#4893] Range level deep permalink (in the form of http://www.editgrid.com/user/a_user/a_spreadsheet/Sheet1!A1:C5) with parameters column-delimiter (default=,), row-delimiter (default=\r\n), quote (default=”) and escape (default=”)
• [#5154] Parameter to export style in XML export (?with-style=1)
• [#5073] JavaScript permalink for returning cell value (http://www.editgrid.com/user/a_user/a_spreadsheet/Sheet1!B3?type=js)
• [#5107] Allow passing XSL parameters (eg http://…/foo.xml?xsl=http://…/bar.xsl&_a=1&_b=2 would pass $a=1 and $b=2 into the XSL)
• Option to show menu bar in post-to-blog
• [#4977] Option to allow organisation users to turn off SSL (accessible at the extra menu at top-right-hand corner)
• [#5051] Allow specifying content type in XML export and XSLT output (?content-type=text/plain)
• [#5090] Integration with Netvibes
• [#5067] Display result of NOW() and TODAY() in grid owner’s timezone
• [#4917] Insert re-direction page upon successful login from a login page

Also fixed in this release are:

• [#5103] Re-upload on an unnamed spreadsheet
• [#5110] White background applied upon exporting
• [#4997] Import row/column size
• [#4975] Show locked region inconsistent behaviour
• [#4874] Guard against exceeding cell number limit for importing
• [#5139] Timezone sorting
• [#5092] Tweaking of home page to fit multiple languages
• [#4922] Hid warning for no action to undo
• [#4432] Warning against deletion of all rows/columns
• [#5104] XSS vulnerability in revision description
• [#5024] Apply number formatting immediately
• [#4722][#4850] Reduced default cell size while retaining dimensions on old spreadsheets
• [#5078] Fixed text formatting persistence
• [#5041] Fixed New York timezone off-by-one error

Public Beta 10.1 (rev 3717)

• Security fix on sheet clone operation

Let’s demonstrate how to use the Grid2Map Add-on. A picture is worth a thousand words.

Step 1: Put the addresses in a spreadsheet

Step 2: My Workspace → Add-ons → Grid2Map

Step 3: Addresses on the map

Addresses have become much more meaningful!

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

  • 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)

  • combination of the above using &

  More information on this, as well as sample uses, to follow.

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

EditGrid add-ons finally go live! This is another milestone that EditGrid has stepped ahead, we’ve put forward our vision that EditGrid is not only an online spreadsheet, by riding on the generic nature of spreadsheet, EditGrid could also be a platform for applications to build on!

To Users:

Now you not only have an online spreadsheet to use with, you will find out more and more possibilities with EditGrid. The usages you ever think of with a spreadsheet may be realized by someone else anytime!

To Developers:

Spreadsheet, with its intrinsic user-friendliness and powerful calculation capability, is another dimension of data source that your application can build on. Feel free to take a look at EditGrid Labs. As a heavy open source user, we, EditGrid team, would also like to contribute to the community, so all these Add-ons are released as an open source project. Later on you can build your own add-ons and load it to your EditGrid workspace.

We have 5 add-ons released in this round:

EditGrid Sync

Since the release of EditGrid, we’ve received lots of comments from user concerning their data, and therefore, the birth of EditGrid Sync. Now, you can set a schedule to backup your data daily at a designated time. Not only as a backup tool, EditGrid Sync also allows you to upload/download your spreadsheet right away from your Desktop without opening your browser.

Grid Translate

Ever find out a spreadsheet with data you want but in a language you can hardly understand? Grid Translate can give you a hand. Grid Translate help you translate a spreadsheet into another language with options to translate only a particular column instead of the whole spreadsheet. You may even try using it to do localisation of your software’s system strings.

Grid2Calendar

Your schedule can now reside in a spreadsheet and view in your favorite calender application supporting ical format. (e.g. Google Calendar, iCal). You can build your organisation’s calendar in a spreadsheet then feed it to others.

Grid2Map

One of our vision is to get our user closer to the established technology. With Grid-to-Map, you can mash-up Google Map, too! You can also post the resulting Google Map in your blog!

Search2Grid

Ever want to know how a search keyword performs in Yahoo!, Google and MSN, Search-to-Grid provides a useful tool for your to compare right in your spreadsheet!

All add-ons are still infants - they will keep improving. Got ideas for us? We’re waiting you here.

Public Beta 9.5 (rev 3539)

• Open links in HTML export in new window
• Decreased file size of HTML exporting
• Fixed bug where cell content is not shown completely in HTML export

Tonight was so excited. I think I don’t have to write too much. See below a screen capture from the development version I’m currently working on:

But we can’t be TOO excited at the moment, coz we still have quite a lot of functions to build before the feature is of production grade.

Trust me, we’ll work very very hard on it.

Public Beta 9.4 (rev 3529)

• [#5038] Static link to localised home pages
• [#4707] More robust HTML exporting
• [#4993] Support character ‘/’ in deep permalink
• [#4922] [#4773] Disable hotkeys for undo/redo when there is no action in queue
• Fixed bug in importing where the first sheet has no style but subsequent sheets have