November 2008 Release (rev 24787)

The following features were added to this month’s release:

• Dashboard view - Adds a new level of social interaction to your EditGrid spreadsheet experience. View EditGrid users’ profiles and explore all the publicly accessible spreadsheets in EditGrid
• Auto filter - Our auto filter functions the same way a desktop spreadsheet does and you’ll find it to be more complete than our competitors. Located in Data > Add auto filter menu
• Show/hide worksheet - Allow users to hide and protect sheets so as to limit what read-only users can view. Right click on a worksheet tab and choose hide/unhide sheet. Spreadsheet owners can view and edit their hidden sheets by using the View > Show/Hide hidden sheets menu
• Macro library - Users can now use EditGrid macros created by the EditGrid team and our users. Users can also create their own and publish it to the library and share with other users. Located in Macro > Macro library menu

And some major bug fixes:

• Fixed grid lines to appear when inserting new sheet (#6077)
• Fixed cell locks to reject any change on locked area even on the user interface (#6809)
• Fixed find and replace to exclude find in formula (#7150)
• Fixed format painter to work on first attempt (#8698)

October 2008 Release (rev 24198)

We have made the following enhancements for the month of October:

• Unique e-mail address - We have implemented a unique email address system into EditGrid. Unlike previous registration where you can register multiple accounts with a single email address, you are now require to have a unique email address with each account you create on EditGrid. Existing users will be required to update their accounts with different email addresses, if they haven’t done so already.
• Internal hyperlink enhancement (#8231, #7610) - You have the option of easily linking to other worksheets in a workbook from our Insert > Hyperlink option. It also allows you to link to a cell/range of any worksheets in your workbook

And some major bug fixes:

• Fixed grid lines to appear when inserting new sheet (#8747)
• Fixed unhide so row 1 and column 1 will appear when Unhide is chosen(#8756)
• Fixed font color picker and background color picker to co-exist (#8761)
• Fixed cell comment from disappearing after undoing data pasted onto the cell with cell comments (#8770)
• Optimized Cell Comment Indicator (#8755)
• Fixed range lock to be in sync after deleting data range (#8771)
• Fixed word wrap and row height auto adjustment (#8671)
• Fixed disconnect error (red bar) when attempting to resize rows beyond cell 65536 (#8758)
• Fixed vertical align buttons to appear in toolbar after it is enabled (#8674)

September 2008 Release (rev 23382)

The most notable new feature in this release is:

• Show/Hide Rows and Columns - The ability to show and hide your rows and columns is here.

Enhancements:

• Color picker enhancement (#6051)- Specify your own colors by specifying a hex value
• Show/Hide grid lines (#6460) - slight improvement in scrolling performance when grid lines are hidden in Firefox browsers
• Advanced paste option (#4433)
• Keyboard hotkey for Edit | Paste Special, CTRL+ALT+V (#7553)
• Advanced cell border formatting (#5574)

And some major bug fixes:

• Fixed Labels/legend to appear in Pie charts (#8725)
• Fixed hyperlink() error on copie linked sheet (#7445)
• Fixed “Chart Properties” dialog box size in Safari (#8613)
• Fixed pasting issues with remote image (#8578)
• Improved presentation for relative named expressions (#8614)
• Fixed incorrect font size for vertical aligned cell text (#8671)
• Include support for Ctrl+C/Ctrl+V keyboard shortcut in Safari (#8689)
• Fixed chart dialog input boxes cannot be filled by mouse (#8701)
• Detects duplicate names when renaming a spreadsheet (#8662)
• Fixed Edit and Hybrid mode in iPhone version (#8624)
• Fixed Macro editor to work in Google Chrome (#8677)

August 2008 Release (rev 22131)

The most notable new features in this release are:

• Macro (beta)
  We are excited to announce our very own macro. But unlike the standard macros written in VB, our macro is based on Javascript, an updated and capable programming platform compared to VB in today’s web. EditGrid Macro will allow you to insert code to customize and add features to the Grid as well as create mashups and deploy instantly to your collaborative spreadsheet without additional deployment effort. Below are some macro examples:

  - Deduplication
  - Table Formatting
  - Date Range Picker

• Named Ranges
• Array Formula
• Duplicate Sheet
• Vertical Alignment
• Book Comments

Enhancements:

• New crosshair view enable users to easily locate
• Improved copy and paste of sheet object, i.e. charts and images
• Workspace Enhancements
  - Pagination
  - Feature Spreadsheets
  - Inbox - displays the latest spreadsheets shared to you
  - Additional preferences/options
• New Data Packs for Zillow, Trulia and Google
  ZILLOW_SEARCH()
  ZILLOW_ZESTIMATE()
  ZILLOW_UPDATEDDETAILS()
  ZILLOW_CHART()
  TRULIA_GET_CITIES_IN_STATE()
  TRULIA_GET_COUNTIES_IN_STATE()
  TRULIA_GET_NEIGHBORHOODS_IN_CITY()
  TRULIA_GET_ZIPCODES_IN_STATE()
  TRULIA_CITY_STATS()
  TRULIA_COUNTY_STATS()
  TRULIA_NEIGHBORHOOD_STATS()
  TRULIA_STATE_STATS()
  TRULIA_ZIPCODE_STATS()
  GDEFINE()
  GWEATHER()
  GPATENT()
  GAREACODE()
• Remote data now allows users the option to click and expand large data sets
• Organisation admin has the ability to switch on page header

And some major bug fixes:

• Increased scrolling performance for scrolling an entire merged column (#8382)
• Fixed mouse to not capture shift+enter, shift+tab (#8132)
• Fixed checkbox so it cannot be toggled in a linked sheet (#7971)
• Fixed PageUp key function to page up one page. (#8501)
• Fixed cell to allow checkbox insertion with boolean expression (#8507)
• Fixed incorrect code snippet output for Calculator publishing widget (#8600)

July 2008 Release (rev 20652)

The most notable new features in this release are:

• Revamped Workspace
  The new workspace allow users to access their spreadsheets more quickly and efficiently than before. We’ve used more AJAX to handle the actions which means we have eliminated a number of page loads necessary in previous workspace, saving you time. There is a new tags-list and owners-list that allows for much easier locate your book by tags or owner. And the addition of a filter function will let you find your books quickly by spreadsheet names
• Optimized Grid - Improved response time when performing the following:
  - Opening smaller sized sheets
  - Resizing columns/rows
  - Navigating between sheets
  - Resizing browser window
  - Scrolling (most significant in IE6 and noticeable in FF2, IE7)
  - Cursor movements
• Additional Data Packs
  Search by product keywords and look up product details from Amazon and eBay
  AMAZON_LOOKUP(): =amazon_lookup(code [,field])
  AMAZON_SEARCH(): =amazon_search(keywords, searchindex[ ,field])
  EBAY_LOOKUP(): =ebay_lookup(ID [,field])
  EBAY_SEARCH(): =ebay_search(keywords [ ,field])

Enhancements:

• Show pixel value when resizing columns/rows (#3916)

And some major bug fixes:

• Enter edit mode on sheet with freeze pane malfunction(#6762)
• Fixed cursor focus when calling Replace dialog (#8351)
• Fixed email address recognition in grid (#7977)
• Cell resize toolbar/menu button (#4140)
• Fixed column header misalignment (#6434)
• Fixed grid from scrolling to the far right end when extending a row selection by keyboard (#7451)
• Fixed SE pane offset to restore appropriately when unfreezing an offsetted pane (#8203)
• Fixed =hyperlink() function to not show up as HTML on linked sheet (#7969)
• Fixed grid image to not select the cell behind it when clicked (#7853)

June 2008 Release (rev 19034)

The most notable enhancement in this release is:

On Demand Remote Data - 41 new data functions in 7 categories

Economy
cia_factbook() - world economic data
strikeiron_census() - US census data

And some major bug fixes:

• Fixed auto characters encoding for second parameter to HYPERLINK function (#8141)
• Fixed cell anchor hyperlink cell to hyperlink correctly in cell properties (#7614)
• Fixed linked sheet with sheet names in Japanese to correctly store and display in IE (#7457)
• Fixed hyperlink() function to not display HTML in linked sheets (#7969 )
• Fixed Share to Email feature to work with email addresses with underscores (#6933)

May 2008 Release (rev 17656)

The most notable enhancement in this release are:

• Remote Data - Fetch data from within a cell by using our new remote data functions. Learn more.
  
  - YSTOCK(): =YSTOCK(symbol[,field])
  ex. =YSTOCK(”YHOO”,”price”)
  - YCURRENCY(): =YCURRENCY(to,from)
  ex. e=YCURRENCY(”USD”,”JPY”)
  - WEB(): =web(website,regex), =web(”editgrid_cell_permalink”)
  ex. =web(”http://www.editgrid.com/user/username/bookname/Sheet1!B5″)
  - ALEXA(): =ALEXA(website[,field])
  ex. =ALEXA(”editgrid.com”,”rank”)
  - COMPETE(): =COMPETE(website[,field])
  ex. =COMPETE(”editgrid.com”,”rank”)

And some major bug fixes:

• Fixed Replace All function (#8041)
• Fixed cursor focus when using Share to Email function (#8043)
• Fixed text selection in Internet Explorer (#8042)
• Fixed auto fill right and down and to not overwrite existing data ((#7609)
• Fixed =hyperlink() function to not show up as HTML in linked sheet (#7969)
• Fixed Javascript Error On Cell Comment RTU (#8080)
• Fixed Grid UI malfunction in 800×600 screen resolution (#7893)
• Added auto line break in edit mode for when entering long text that runs beyond the screen (#7680)
• Fixed double-click action in Internet Explorer to not erroneously hightlight textarea (#7899)
• Fixed widget to work with Internet Explorer 6 without causing it to hang (#8039)
• Fixed widget auto filter to allow first column to filter when row header is enabled (#8908)

March 2008 Release (rev 16661)

The most notable new features in this release are:

• Featured Spreadsheet - Check out what users are doing with EditGrid and submit yours to have it featured. We will be linking to your spreadsheet and/or your website from EditGrid’s homepage.
• Grid API - Our API are revamped and extended. The new Grid API (javascript) allow you to do much more interesting thing.
• EditGrid Widgets (via menu > Publish > Widgets)
  
  - Calculator: allow editing your spreadsheets in your blog/website without saving changes to the original.
  - Mini-EditGrid: a dynamic grid also receiving real-time updates from EditGrid
  - HTML Table: a static view which is faster to load and update on reload

Enhancements:

• Usability improvements for EditGrid’s sharing, publishing and collaboration features and menu - the must-haves for online spreadsheets.
• Quick sort view
• Quick auto-filter view

And some major bug fixes:

• Fixed toolbox from opening two instances of toolbox windows (#8036)
• Fixed arrow key behavior in edit mode in Safari 3.1 (#8033)
• Fixed cannot open grid On IE6 When the sheetview does not intersect any east sheet pane (#8032)
• Fixed copy-and-paste into a read-only book produce a “Fail to save the latest change” error (#8010)
• Fixed internal linked sheets to recognize sheet names with spaces (#7965)
• Fixed bug that caused text selection when dragging sheet tabs in IE7 (#7953)
• Fixed script error when inserting buttons into small cell (#7940)
• Fixed internal hyperlink to work with Chinese sheet name (#7933)
• Fixed RTU to not affect edit mode (#7444)
• Fixed cell formatting of previously edited cell to not tamper with current edit mode (#7926)
• FF 2.0 spellchecker works in cell editor(#5647)

February 2008 Release (rev 15198)

The most notable new features in this release are:

• Spreadsheet Analytics - Spreadsheet analytics is to make the traffic information available for monetizing opportunity evaluation. Live example.
• Mashup functions
  - Google Charts, googlechart()
  - Yahoo! Finance, yfinancechart()
  - Reuters, reuterschart()
  - Alexa, alexachart()
  - Compete, competechart()
• Template Library - We are introducing a template library. Now you can create new spreadsheets based on our standard templates or submit your own and share with others.
• ExcelPlus plugin - Public beta released
  - Offline access of EditGrid spreadsheets
  - Subscribe to real-time updates from EditGrid.
  - Publish data to EditGrid
  - Synchroize data two-way for a pre-defined region of cells
• Cell Widget: Checkbox

Enhancements:

• Grid Tips
• Webclip bookmark for iPhone (#7425)

And some major bug fixes:

• New cell comments overwrites cell content fixed (#7785)
• Fixed ntext function returns correct value (#7793)
• Fixed hyperlinks to work within a locked cell (#6544)
• Fixed remote data window from going blank when referencing a cell with URL(#7786)
• Fixed F9 hotkey to perform recalculation(#7452)
• Fixed editing actions while using keyboard navigation in long merged cell(#7836)
• Fixed red alert message bar to display properly on Internet Explorer(#7858)
• Unlock button will be displayed in the Mini-Grid (#7727)
• Fixed grid user interface in 800×600 display (#7893)
• Right click in edit mode will display native browser menu(#7894)

January 2008 Release (rev 13651)

This release is to celebrate EditGrid being nominated as one of the finalists of the inaugural 2007 Crunchies Awards - Best Enterprise Startup Award.

The most notable new features in this release are:

• Mashup Function: IMAGE(), The “Image()” function fetches live images/charts from other web services into a spreadsheet cell. See this spreadsheet to explore its possibilities:
  http://www.editgrid.com/tnc/david/Magical_Image_Functions.new
• Merge Cells, finally. Our merge cell function supports both horizontal and vertical merge cells, better than other similar services.

There are 2 new integrations coming live with this release:

• EditGrid Plugin for Confluence - EditGrid partners with Atlassian (another Crunchies finalist) to offer EditGrid as the default plugin for Confluence hosted customers.
  http://blogs.atlassian.com/news/2008/01/hosted_customer.html
• EditGrid App for Facebook - EditGrid app is available on Facebook, see our elegant integration here:
  http://www.facebook.com/apps/application.php?id=2407333014

Enhancements:

• Invite your friends to try EditGrid
• New EditGrid menu item “Interesting!”

And some major bug fixes:

• Fixed keyboard shortcut keys, < Ctrl + A > and < Ctrl + Z > to function correctly in edit mode(#7417)
• Fixed editing box to remain in grid view when editing large amount of text in IE (#7681)
• Fixed Formula Dialog to successfully load help (#7720)
• Fixed remote data web fetch (#7576, #5950)
• Fixed rollback function error (#7567)
• Chart location will now render correctly (#7686)
• Fixed javascript errors for drop down menus in French UI (#7624)
• Viewport is able to scroll up or left for multiple selection by keyboard (#7591)
• Viewport is able to scroll leftwards or upwards following the leftward or upward bound of the multiple selection. (#7744)
• Fixed cell permalink in third party websites to reference back to EditGrid domain (#7769)

December 2007 Release (rev 12629)

The most notable new features in this release are:

• JSONP support
• Justified text alignment in cells
• Hyperlink enhancements - Along with adding external links in cells, now there is a dialog where you can specify to add a web link, email link and an internal link. You can use the internal link to link to another cell/sheet in the same book.
• Advertise on your spreadsheet with Image URL - if your spreadsheet is highly popular, such as this one, you can now place banner ad on your spreadsheet to monetize your content.

Enhancements:

• Ability to specify column width/row height

And some major bug fixes:

• Eliminated formula bar from flashing with multiple cell selection (#5157)
• Ability to copy-and-paste formula to a range of cells (#6433)
• Inputting Chinese/Japanese character will not disconnect link in a linked cell (#7093)
• Cursor is visible while editing cell comment in Firefox (#7373)
• Ctrl+` (Toggle formula mode) works with JP IME (#7426)
• Value will not be applied to another sheet when switching sheets in Edit Mode (#7430)
• Word wrap button on toolbar toggles (#7438)
• Arrow key correctly triggers cursor movement on Mac Safari (#7455)
• Spreadsheet and cell last modified record not updated for changes published from Excel to EditGrid (#7533)
• Remote data updates cell number in dialog box automatically based on grid location (#7542)
• Word wrapping a cell and extending row height will not lead to permanently dangling edit mode (#7543)
• Exit from multiple selection using keyboard arrow keys is compliant with Excel (#7566)
• Share-to-Email now supports many forms of multiple addresses input, including comma, space, semicolon separated, and also “NAME ” form of addresses too (#7287)

November 2007 Release (rev 11917)

Our monthly release is out and we have included October’s changes into this release.

The most notable new features in this release are:

• Format Painter (#6458) - We’ve continue to improve EditGrid to match the experience you get from the desktop spreadsheet programs. With our new Format Painter, you can now save time by using this feature to copy all of the cell(s) format attributes.
• Paste special options (#7507) - Just like the Format Painter, we’ve also added the Paste Special menu item in the Grid menu and expanded paste options to allow you to paste Content, Comment or Format.
• Improved Cursor - When you select a range, you can now use [ < shift > + ] < enter > or [ < shift > + ] < tab > command to navigate within the selected range.

Enhancements:

• Improved layout in organization tab
• Extended workspace layout
• Support Apple shortcut keys (#7255)
• Clear all formatting (< Ctrl >+< Shift >+< Delete >) (#5389)
• Autofill shortcut keys < Ctrl > + d & < Ctrl > + r (#7032)
• Improved interactivity with grid menu
• Improved hotkey support of copy-and-paste in different browser and platform
• Insert hot-keys: - Current Date ( Ctrl+;), Current Time ( Ctrl+:), Current Date and Time ( Ctrl+.)

And some major bug fixes:

• Enabled Brazil stock market from remote data UI (#4734)
• Cmd+key in FF for Mac OS X wrongly captured (#5040)
• Stop formula bar flashing during multiple selection (#5157)
• Read-only when users switched to a linked sheet (#5764)
• in formula bar not working when find box is active (#5840)
• Hotkey for navigating across menus in menu bar (#6016)
• Copy and paste encoding issue for certain unicode characters (#6199)
• Repeated code captured when key in chinese in Safari (#6309)
• Can’t hide row header in post-to-blog mini-grid in WebKit (#6317)
• Escape from find toolbox partially steal focus from grid (#6557)
• Find dialogue text displayed on top left corner of screen (#6662)
• Fail to trigger context menu by hotkey in Webkit (#6723)
• F2 in Opera occasionally captured by browser (#6927)
• Grid steal focus from toolbox on ctrl+/ (#6948)
• Abnormal advanced border non-overlapping behavior (#7001)
• on formula bar chops input (#7122)
• Opera arrow key malfunction (#7401)
• Content cleared on Cmd+X and Ctrl+X on Formula Bar (#7383)
• Typing spreadsheet name for new book will enter edit mode (#7372)
• Check box cannot be check by clicking label in “Post to Blog” page (#7295)

As with any updates or releases, we’d love to hear what you think. If you have encountered any issues or bugs with this month’s release or with our service in general, please send an email to us at cs@editgrid.com along with the issues you are having or report your bug at our support forums.

September 2007 Release (rev 10297)

The most notable new features in this release are:

• HTML Export - With HTML export, you can now publish a multi-page spreadsheet online with ease - You can export a multi-page spreadsheet ,switch between sheets using tabs and perform sorting and auto-filtering for your published tables or lists.

• iPhone Edition Beta - Being compatible with Safari, iPhone’s default browser, EditGrid iPhone Edition beta offers you an extended scrolling capability by scrolling your spreadsheet and the option menu with two fingers. You can open your spreadsheet in Edit mode, View Mode and Hybrid Mode according to the size of the spreadsheet. Visit (http://www.editgrid.com/site/news/iphone_launch) with iPhone to feel the unique collaboration experience on the go!

Enhancements:

• Increase upload size to 2MB (Personal account) and 8MB (Organisational account) respectively
• Multiple column resize can be restored by a single undo command (#6301)
• Allow user to choose which workspace to save a new spreadsheet or import a spreadsheet (#6847 & #7106)
• Improved workspace loading speed

And some major bug fixes:

• Recover formula bar at IE6 and IE7 (#7144)
• Html export distorts symbols [&], ['], ["], [<] and [>] on renamed sheet name tab (#7263)
• Fixed Auto-fill malfunction on IE6 (#7264)
• Add share-to-Email warning for empty user/workspace name instead (#7170)
• Fixed frozen grid upon exporting on IE6 (#7268)

August 2007 Release (rev 9580)

The most notable new features in this release are:

• Share-to-Email - Having enjoyed sharing your spreadsheet with other users seamlessly in EditGrid? From now on, you can also share your spreadsheet to those who does NOT have an EditGrid account in just a few clicks! Let’s invite your friends to edit together by going to “Share > Share with others > Add Emails” now!
• Spreadsheet Redirection - You can share your spreadsheet with others in EditGrid without the hassle of e-mailing the document again-and-again, but do you need to notify your friends of the spreadsheet’s link being changed when you rename your spreadsheet? Inspired by MediaWiki, we’ve avoided the hassle by supporting spreadsheet redirection after renaming/changing of ownership! Simply select “Create a new redirection” when you rename the spreadsheet/change the ownership, the old permalink will be redirected to the new permalink!
• Find-and-replace - We never forget to make EditGrid closer to your Excel experience. You can now replace the phrase in your spreadsheet in EditGrid as you usually do in Excel. Go to “Edit > Replace” or simply click the short-cut “Ctrl+h” to open the find-and-replace dialog and start replacing!

Enhancements:

• Skip request for page/static/tt/grid/widget/sort at grid loading (#6426)
• More user configurable workspace listing (#6421)
• Clones remote data when copying a book (#6891)
• Initialise mark revision text box with old description (#5284)
• Allow user to choose which workspace to save for new spreadsheet (#6847)
• Improved cloning performance
• Allow user to choose which workspace to store the newly imported spreadsheet. (#7106)
• More efficient workspace loading

And some major bug fixes:

• Allow add and remove remote data on a writeable spreadsheet opened in read-only mode (#6963)
• Better escaping for web fetch (#6964)
• Import of lotus 1-2-3 file types (#6960)
• Select area where input is unchanged during undo/redo operation (#7003)
• Auto-expand after double-clicking a cell (#7096)

July 2007 Release (rev 9188)

Congratulations to the developers for fixing a total of 120 bugs throughout the EditGrid Big Bugs Hunt for this release. However, this release is much more than bug fixing!

The most notable new features in this release are:

• Dynamic Images, you can now play mash-up with the image URLs. See the demo spreadsheets Weatherholic and Stockaholic to see how it works. - feature sponsored by .
• Direct support of IME input of multibyte characters on IE/FF, without needing to press F2 first (#5313) - feature sponsored by .
• Official Safari 3 support - Safari is the fastest browser for running EditGrid! (note: EditGrid on iPhone not far away!)

Enhancements:

• New preference to set the default workspace filtering between “all”, “active” and “last filtering”
• New preference for organisation user to enable/disable SSL permanently
• Support formula building through keyboard’s arrow keys (#4595)
• Allow copy, cut, paste directly from system clipboard with CTRL+C/CTRL+X/CTRL+V in IE/FF/Opera
• Menu item to auto fill cells (Main menu > Edit > Autofill) (#6986)
• Highlight affected cell upon undo/redo (#6025)
• Added context menu item to spreadsheet images to trigger a force reload (#6796)
• Added “Get Cell Permalink” to cell’s context menu (#6852)
• Detect client locale automatically on the first visit (#5959)
• Allow login using the orgname/username format in organisation login page (#6760)
• Allow unmarking/deleting multiple revisions at history
• New “rename spreadsheet” link on sheet property summary page (#4313)
• Improved chat performance for spreadsheet with a lot of chat users (#6179)
• Added “select all” button on spreadsheet sharing page (#6773)
• Added captcha to prevent spamming on spreadsheet properties and email spamming (#6790, #6792)

And some major bug fixes:

• Fixed scrolling problem on chat box user list
• Allow paste from system clipboard directly under edit mode (#4900)
• Fixed workspace sort order preference malfunctioning for “sort by owner” (#6786)
• Switch to default workspace if the current workspace is unavailable (#6841)
• Fixed organisation master failed to unlock locked cells in admin mode (#6453)
• Fixed security warning when bringing up context menu by right-clicking on IE7 (#6156)
• Fixed language preference not applied with auto-login (through “remember me”) (#6840)
• Fixed invalid sheet object ordering after a spreadsheet is reopened (#6811)
• Prevent access to an inactivated user’s spreadsheet and public spreadsheet list (#6812)
• Fixed “Newly shared” workspace message nuisance (#6775)
• More meaningful error message for oooc failure (#6246, #6247)
• Fixed wrong revision marked “rolled back” upon roll back (#5939)
• Fixed initial version not included in revision history (#5277)
• Password should not be stored in password field after login failed (#6917)
• Show a dummy “failed to load” image if sheet image can’t be imported (#6928)

June 2007 Release (rev 8534)

The most notable new features in this release is:

• Insert Image on Spreadsheet - from the menu bar, click Insert > Image …, and give a URL to insert an image. (#5109)
• EditGrid Status and Availability History - now available at status.editgrid.com - a dedicated website to track EditGrid’s system status in real-time and maintain an availability history for future reference. (#6217)

Enhancements:

• Improved performance for Live Chat, when a large number of users are chatting simultaneously.
• Improved performance when doing column/row operations in spreadsheets with freeze pane enabled. (#6787)
• Better navigation after purging or restoring a spreadsheet from the organisation admin interface. (#6269, #6280)

Also fixed in this release are:

• “Remember me” not working when logged in from /home. (#6696)
• Problem scrolling with mouse wheel in Opera 9.20 or above.
• Fixed spreadsheet not loading in Safari.
• Various minor bugs in Remote Data and Sheet Objects.

May 2007 Release (rev 8298)

The most notable new features in this release is:

• Shared Workspace, allow groups of people to work together in a common environment. Spreadsheets in a shared workspace are co-owned by all the workspace members. (#4028)
• New spreadsheet sharing interface. The previous three paged “Share to Public”, “Share with Password” and “Share to Users” interface are combined into one with a more intuitive workflow. (#6481)
• More scalable backend architecture. We can now handle a lot more concurrent users with more predictable response time.

Other new features include:

• Support fetching data from a password protected spreadsheet web fetch through web-fetch (see the forum discussion) (#6674)
• A new “remove all” button in remote data dialog (#6747)
• Added hyperlink function “=hyperlink(href,text)” (#6652)
• A tooltip to notify users of new features. You should have noticed that we’re using it to promote our Shared Workspace feature already. (#5974)

Also fixed in this release are:

• Freeze-pane not properly exported in XLS format (#5204)
• Phantom editing of unauthorized sheets (#5901, #6661)
• Cell comment rendering problems (#6609, #6635, #6657)
• Properly handle permalinks of spreadsheets with a trailing dot (#5937)

Other enhancements:

• More prominent unlock button for password-protected sheets (#4822)
• Optimization of the Chat protocol - now consume less bandwidth

April 2007 Update 3 (rev 7780)

• [#6508] Share with user and public toolbox regression in admin mode

April 2007 Update 2 (rev 7699)

• Insert comment on menu bar
• Close comment toolbox using Ctrl+Enter

April 2007 Update 1 (rev 7668)

• [#6611] Email recognition of MAILTO: hyperlinks in grid regression
• [#6612] Email recognition of MAILTO: hyperlinks in HTML export regression

April 2007 Release (rev 7610)

The most notable new features in this release is:

• [#3683] Cell comment — right-click a cell and choose “Edit Cell Comment”.

Other new features include:

• [#5900] Import formatting from linked sheet
• [#6462] Add category “All” in function selector

Also fixed in this release are:

• [#6534] Handle unicode characters in outgoing emails
• [#6228] Same-spreadsheet copy-and-paste optimisation
• [#6507] Content images display regression
• [#6541] Access by API would be treated as opening a spreadsheet for Workspace filtering

March 2007 Update 11 (rev 7418)

• [#6547] Fixed issue in IE where focus on grid is lost upon entry

March 2007 Update 10 (rev 7380)

• Added support for custom menu bar using Partner API
• Added support for custom language using Partner API

March 2007 Update 9 (rev 7370)

• API HTML redirect optimisation

March 2007 Update 8 (rev 7366)

• Update all linked sheets stability enhancement

March 2007 Update 7 (rev 7329)

• [#6538] Show invoice status on invoice list
• API method getBookRevId
• Support for sheet-level CSV export
• Added waiting message for update all linked sheets
• Update all linked sheet stability enhancement

March 2007 Update 6 (rev 7260)

• [#6525] Free-trial period expiry notice

March 2007 Update 5 (rev 7247)

• [#6522] Added reminder to edit contact information upon upgrade from free trial
• [#6523] Added contact information in organisation settings
• [#6511] Memory optimisation for IE
• Updated unsupported browser message
• Payment status callback regression

March 2007 Update 4 (rev 7217)

• [#6502] More robust failure handling of remote data web fetch regular expression

March 2007 Update 3 (rev 7165)

• Email address validation for free-trial reminder email
• More proper payment details verification

March 2007 Update 2 (rev 7152)

• [#6367] Set charset to UTF-8 properly in XML export
• Fixed “owned by” localisation key

March 2007 Update 1 (rev 7141)

• [#6474] Disabled insert/delete row/column from toolbar in read-only privilege
• [#6472] Password protected spreadsheet post-to-blog regression

March 2007 Release (rev 7116)

The most notable new features in this release are:

• [#4297] Mass importing
• [#6289] Auto fit selection

New subscription features and patches rolled out in this release include:

• [#6299] Email reminder towards the end of free-trial period
• [#6212] [#6213] Separate organisation administrator mode with ordinary mode in grid and in sheet property
• [#6277] Usability enhancement on subscription page upon redirection from PayPal

New interoperability features and patches rolled out in this release include:

• [#6437] Fixed outdated upload link on Netvibes

Other new features include:

• [#6428] User preference for default Finder scope
• [#6420] Accept cell range in Go To toolbox
• [#5280] Option to show header bars at HTML export

Also fixed in this release are:

• [#6210] Default to match multi-line at web fetch remote data regular expression
• [#6408] White background for textarea in copy to clipboard toolbox
• [#6452] Fixed bug where listing trash with workspace sorted by user name gives error
• [#6430] Restored robots.txt
• [#6405] Fixed bug where grid menubar hotkey (Ctrl+/) would steal focus
• [#6360] Transparent background to “Online Spreadsheet by…” in post to blog code
• [#6409] Fixed bug where applying a pre-set custom display would add duplicate entry to custom format list
• [#5842] Show organisation name in email for password recovery

February 2007 Update 5 (rev 7076)

• [#6440] Fixed bug where URL with UTF-8 character returns error 404

February 2007 Update 4 (rev 7035)

• Fixed bug where sharing to a user may give permission to a deleted namesake
• Better null handling in remote data web fetch
• [#5952] Removed dangling remote data entries from back-end
• [#6357] Sign-up page enhancement

February 2007 Update 3 (rev 6973)

• Aligned API upload file size limit with main site’s
• Optimisation in remote data web fetch: execute EditGrid web fetch separate from non-EditGrid web fetch

February 2007 Update 2 (rev 6967)

• [#6389] Cookie disabled warning on sign-up page
• [#6397] Fixed focus in copy-to-clipboard toolbox
• Remote data web fetch regression

February 2007 Update 1 (rev 6958)

• [#6381] URL parameter ?nocache=1 to force reload
• [#6382] Sign-up page wordings clarification

February 2007 Release (rev 6933)

On St. Valentine’s Day 2007 the EditGrid Team presents February 2007 Release — the first release without the “Beta” tag, signifying that EditGrid is now official out-of-beta.

Celebrating the first full release post beta are the following notable new features:

• [#5932] EditGrid Subscription Service, now officially rolled out.
• [#6203] Raised spreadsheet upload limit to 2MB, or 60,000 cells, per spreadsheet. More to come in subsequent releases.
• Overhauled caching mechanism.

New subscription features and patches rolled out in this release include:

• [#6106] Organisation administrator privilege to set a spreadsheet as template and vice-versa
• [#6105] Organisation administrator privilege to purge a spreadsheet
• [#6104] Organisation administrator privilege to rename a spreadsheet
• [#6276] Acknowledgement of new organisation member
• [#6207] [#6241] Intelligent logout re-direction
• [#6159] Sort by owner at workspace
• [#6347] Organisation portal compatibility issue with Opera 9.0
• [#6271] Organisation login page formatting
• [#6236] Delete user usability enhancement
• [#6234] Fixed bug in organisation administrator’s sharing privilege
• [#6233] Integrity checking in spreadsheet ownership transfer
• [#6160] Fixed XSS in organisation login page

New interoperability features and patches rolled out in this release include:

• WSDL compliance with specification
• Fixed bug in API method doExport

Other new features include:

• [#6061] Non-persistent storage of custom number format for re-use
• [#5940] Menu item to update all linked sheets
• [#6164] Menu item to update a linked sheet
• [#3962] Auto fit row/column size by double clicking at border row/column index
• [#5279] Option to enable grid line in HTML export
• [#6249] Inhibit insert/delete all rows/columns
• [#5537] Support If-Modified-Since in HTML export
• [#6205] .new permalink — URL scheme to create new untitled spreadsheet from an existing one
• [#5799] New chat message notification
• [#5267] Include charts in HTML export

Also fixed in this release are:

• [#6367] Append UTF-8 encoding specification in MDF output
• [#6351] Enhanced on-demand loading indicator in grid
• [#6072] Remote data toolbox URL and regular expression line wrap
• [#6366] Fixed bug in remote data where data type is wrongly recognised
• [#4604] Disabled drag-and-fill effect on read-only spreadsheet
• [#6331] Fixed bug where auto save fails to preserve cell last modification record
• [#6354] Fixed XSS in remote data toolbox
• [#5996] [#6376] Fixed bug in HTML export on default background
• [#6345] Fixed bug in RTU on default background
• [#6343] Fixed bug where chart may become invisible upon sheet switching
• [#5982] Grid context menu size detection code malfunction
• [#5906] Fixed bug in inserting linked sheet after current sheet
• [#6155] Fixed bug where date object in imported spreadsheet is not recognised properly
• [#6221] Removed “Public Spreadsheets” button in workspace table header
• [#5419] Inhibited deleted spreadsheets on workspace RSS feed
• [#6230] More descriptive error page for export error
• [#6222] Fixed bug in importing spreadsheet as public user
• [#6194] Chat stability enhancement
• [#5635] Ctrl+left-click fails to honour multiple selection
• [#5924] Consistent ordering of tags
• [#6172] Import page outlook enhancement
• [#6190] Generated thumbnail properly for charts in extreme dimensions
• [#6185] Fixed bug in deleting multiple spreadsheets of which some are incoming
• [#6192] Fixed bug in toolbox where dragging would reset scrollbar position
• [#6102] Default Content-Type to text/plain for cell/range permalink
• [#5796] Fixed live chat message history auto scroll to bottom malfunction
• [#5095] Fixed bug in GridSearch where an empty result set would give exception

Public Beta 18.7 (rev 6825)

• More graceful chart action RTU

Public Beta 18.6 (rev 6742)

• More live chat optimisation

Public Beta 18.5 (rev 6596)

• Minor live chat optimisation
• Fixed region integrity check in sorting

Public Beta 18.4 (rev 6526)

• Optimised image loading speed
• [#6216] Fixed Strikethrough persistence malfunctioning
• Fixed URL in email
• [#6206] Fixed bug in trackback UTF8 recognition

Public Beta 18.3 (rev 6494)

• Fixed bug where site header would occasional disappear
• Fixed bug in removing/rejecting an incoming spreadsheet in workspace menu

Public Beta 18.2 (rev 6421)

• [#6163] Improved workspace button rendering in IE

Public Beta 18.1 (rev 6374)

• Support sheet navigation in Safari
• [#6178] Fixed find malfunction past the last occurrence
• Fixed bug in spreadsheet copy-and-paste
• Fixed bug in sorting toolbox where selected columns fail to be loaded
• Excluded search queries in trackback
• [#6176] Fixed error in remove spreadsheet dialogue
• [#6162] Fixed encoding issue in trackback

Public Beta 18 (rev 6354)

The most notable new features in this release are:

• Revamped |Workspace| — feature sponsored by .
• [#6015] Streamlined sharing mechanism — feature sponsored by .
• [#4981] Salesforce.com AppExchange — officially rolled out on 12th January and now available at Salesforce.com AppExchange.
• Better Safari support. For better behaviour, use the latest development version of Apple Webkit.
• Enhanced grid performance using viewport — on-demand loading of grid data.
• Partner API — easier integration with your killer app. An integration guide is available on EditGrid Wiki. Your service can be the next one — contact us for enquiry.
• [#5723] EditGrid Trackback — see how users use EditGrid on the web.

New organisation features rolled out in this release include:

• [#5665] Spreadsheets tab — see all spreadsheets in the organisation
• [#4029][#5485][#6101] Organisation administrator granted full privilege to manage spreadsheets in the organisation
• [#5484] Organisation administrator granted read/write access to spreadsheets in the organisation
• [#4233] Re-design the inactivate and delete user use-cases
• [#5595] Custom login page for organisation account

Other new features include:

• [#5516] API methods to return revision history
• [#5232] Strikethrough formatting
• [#5681] Enhanced toolbox loading
• [#4910] Named expression — formula evaluation, import and export
• [#5282] Visually focus on selected chart
• [#6013] Rename sheet by double-clicking
• [#5641] Supported more browsers for event-driven RTU and chatting — including Opera 9.0+ and K-Meleon
• RSS feed for finder results
• [#5640] More menu bar items

Also fixed in this release are:

• [#5314] Inadvertent copy of data across sheets
• [#6086] Truncated long tags in |Workspace|
• [#6009] Handled name clash in transfer of sheet ownership
• Cell limit for HTML export
• Better handling of null characters in remote data web fetch

Public Beta 17.6 (rev 5963)

• Fixed bug in sheet deletion authorisation
• Official announcement of Salesforce AppExchange integration

Public Beta 17.5 (rev 5852)

• Limited tag to 32 characters of length
• [#6069] Fixed chart properties toolbox malfunction

Public Beta 17.4 (rev 5761)

• [#6042] Fixed toolbox dragging malfunction
• [#5765] Advanced colour picker
• [#5327] Advanced function selector
• [#5994] Fixed find empty string malfunction

EditGrid migrated to North America. Resumed normal traffic to the level before the Boxing Day earthquake and the subsequent interruption of Internet connectivity. Users may experience faster access to EditGrid than before, depending on location.

Public Beta 17.3 (rev 5657)

• Fixed API session creation malfunction

Public Beta 17.2 (rev 5593)

• API method cloneBook now accepts empty bookName and bookRevId parameters
• API method getBookRevList now allow users with read permission to obtain revision list
• Added new API methodsetBookRevNote
• Fixed missing response of API method privGridSession

Public Beta 17.1 (rev 5508)

• Added API methods cloneBook, privGridSession and other BookRev related methods
• [#6012] Insert sheet at menubar malfunction

Public Beta 17 (rev 5490)

The most notable new features in this release are:

• [#5487] [#5488] [#5489] Enhanced reporting for organisation account management — organisation administrators can now view Recently Logged-in Users, Recently Modified Spreadsheets and Active Spreadsheets.

New organisation features and patches rolled out in this release include:

• [#4085] Track creation of organisation user
• [#6004] Organisation administrator can’t update own email at user management
• [#5980] Card view shows wrong spreadsheet count per user

Other new features include:

• Various menu bar enhancements: [#5701] enabled hotkey Ctrl+/ to access menu bar directly, added [#5307] File | Save As… and [#5435] Data | My Data Format…
• [#4235] Transfer spreadsheet ownership — accessible at sheet property
• [#5784] Option to display tags as list or cloud in public spreadsheet lists and workspace
• [#4866] Sorting without having to select
• [#5637] Make toolbox draggable everywhere
• [#5873] Create/upload my template at “My Templates”
• [#5474] Added item “upload new version” to workspace action menu
• [#5838] Alert confirmation box enhancement
• [#5766] Help page at http://www.editgrid.com/article/help
• [#5363] Enabled Ctrl+Enter to insert line break in cell in IE7

Also fixed in this release are:

• [#5992] Escaped character # in sheet name on finder search result screen
• [#5988] “Descending” mis-spelt in Grid interface
• [#5968] Beginning space missing upon word-wrap
• [#5915] Chart fails to update after resize
• [#5902] Reduce length of horizontal scroll bar
• [#5925] Disable watermark on images
• [#5897] Open in read-only mode allows editing upon switching sheet
• [#5788] Toolbox’s draggable area should not be allowed to moved out of viewport

Public Beta 16.5 (rev 5348)

• Option to disable live chat
• Home page stability enhancement
• [#5813] In grid mode, show license info in pop-up

Public Beta 16.4 (rev 5319)

• [#5294] Move chart after insert/delete row/column
• [#5425] Save chart properly after insert/delete row/column
• [#5942] Fixed JavaScript error in IE
• [#5807] Revamped EditGrid Tour at http://www.editgrid.com/article/tour
• Stability enhancement on OOo and PDF formats exporter
• Less frequent timeout error

Public Beta 16.3 (rev 5242)

• Linked sheet optimisation
• [#5763] Clear data on update linked sheet
• [#5897] Fixed bug where editing is allowed on spreadsheets opened in read-only mode upon switching sheet
• [#5867] Further randomised random charts and public listings

Public Beta 16.2 (rev 5214)

• Tag casing regression
• [#5883] Fixed bug where “1″ is appended to spreadsheet name in incoming spreadsheet invitation
• [#4821] Tag name validation regression
• [#5891] Set permission correctly on upload
• [#5823] Create template in Workspace and option to save as template on untitled spreadsheet
• [Close] button revamp
• [#5888] Handle underscore in original filename properly on upload
• Fixed bug where full file path is retained on upload

Public Beta 16.1 (rev 5175)

• [#5374] Fixed bug where Finder find deleted spreadsheets
• Fixed API bug on doImportReplace
• [#5847] Fixed bug where one tag by two users gives two entries on public listings
• [#5852] Show last modified user on public listings if it is not owner
• Home page loading time optimisation

Public Beta 16 (rev 5148)

The most notable new features in this release are:

• [#5508] [#4590] [#5753] Portal home page — revamped to facilitate users discover the many resources out there on EditGrid; include popular spreadsheets (RSS), templates (RSS), charts and a tag cloud.
• [#4048] User templates — save spreadsheets as templates and share it with others.
• [#5644] Linked sheet — link two spreadsheets in one and connect data using ordinary cross-sheet formulae! A great step forward towards inter-spreadsheet dependency (IBD).
• [#5676] OpenSearch plugin for FireFox 2.0 and IE 7 — perform spreadsheet search at browser’s search bar!
• [#4311] View count for spreadsheets and copy count for templates.

Starting from this release we are accepting free registration of organisation accounts for free trial. New organisation features rolled out in this release include:

• [#5657] Organisation account registration — register one at https://www.editgrid.com/register/ now!
• [#5664] Card view user listing

Other new features include:

• [#5767] Specify additional license terms on spreadsheets
• [#5735] Sheet properties (accessible at sheet context menu)
• [#5780] |My Workspace| revamp to accommodate templates, tags and resources
• [#5768] [#5769] Open spreadsheets from public discovery in read-only mode
• [#5776] [#5787] Allow public discovery per spreadsheet (and user preference for default value)
• [#5794] Show license icons in grid view
• [#5770] Set default privilege to private when cloning other people’s spreadsheets
• [#4704] Smarter menu items at |My Workspace|
• [#5057] Assign name before import
• [#5387] Spreadsheet archive at |My Workspace|
• [#5360] “Generated in real time by EditGrid” watermark on charts when viewed from 3rd-party sites
• [#5454] Cell border in HTML export

Also fixed in this release are:

• [#5724] Fixed bug in IE where toolbox fails to cover windowed control
• [#4662] Support Brazil market in stock quote remote data
• [#5778] [#5655] Improved OpenOffice.org and PDF formats exporter stability
• [#5693] SSL encrypted traffic for EditGrid add-ons
• [#5656] Preserves post-to-blog integrity upon uploading new version for matched sheet name
• [#5477] Fixed localisation problem in Finder search result page

Public Beta 15.8 (rev 4929)

• [#5323] Fixed email address recognition in HTML export

Public Beta 15.7 (rev 4890)

• [#5702] Safeguard for loading non-existent spreadsheet
• Improved sorting handling mechanism
• Merged style history
• Fixed invalid wrapping of permission icons

Public Beta 15.6 (rev 4845)

• Reduced false positive in detection of connection error
• Caching in back-end server to improve performance

Public Beta 15.5 (rev 4816)

• [#5680] Suppressed security warning on registration page
• Fixed bug where access denial is not handled properly in live chat

Public Beta 15.4 (rev 4801)

• [#5651] Fixed cell border malfunction in post-to-blog

Public Beta 15.3 (rev 4792)

• Fixed bug in Opera where key ‘Q’ is wrongly captured as F2

Public Beta 15.2 (rev 4785)

• Support border export
• [#5645] Recognise hyperlinks and email addresses in chat message history
• [#5643] Fixed bug in re-searching on Finder result screen
• [#5557] Fixed bug in Japanese characters in permalink
• [#5382] Optimisation in row/column operation

Public Beta 15.1 (rev 4750)

• [#4276] More memory optimisation for IE in case page reloads while executing XMLHttpRequest
• [#5613] Fixed bug in Opera where right arrow navigation results in incorrect display
• [#5615] Fixed random gridline snippets on grid loading splash screen
• [#5565] Upload new version regression
• Minor memory optimisation for IE

Public Beta 15 (rev 4717)

The most notable new features in this release are:

• [#3563] Live chat — chat with colleagues and friends while collaborating on a spreadsheet. Activate chat box at status bar below grid.
• [#5206] Official Opera 9.0+ support — Opera users have been using EditGrid fine without major problems, but it’s now official and the incompatible browser warning message won’t show up again for Opera 9.0 users.
• [#5342] Cell properties — track a cell’s last update user and time, and more. Accessible at context menu.
• [#5245] Sort order under |My Workspace| — now default to sort by last modification time, and configurable at Preferences.

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

Other new features include:

• [#5633] Hotkey Ctrl+M to toggle on/off chat box
• [#5593] Publish RSS for EditGrid Forum — recent topics and recent posts
• [#5418] Grid loading splash screen revamp
• [#5106] Allow more options when cloning a spreadsheet
• [#4944] Ctrl+left-click invokes context menu where browser fails to handle right-click properly (includes Opera, Galeon, Epiphany)

Also fixed in this release are:

• [#5478] Refrain from storing invalid Remote Data entries into persistent storage
• [#5584] Revision history data format integrity check
• [#5432] Fixed bug where unlocked cell/range lock is automatically restored
• [#5440] Fixed bug where uploading new version on new spreadsheet goes to home page
• [#5558] Fixed bug in Opera in capturing keyboard input
• [#5292] Fixed bug in Camino where chart captures Ctrl+left-click but not genuine right-click
• [#5507] Fixed bug in Opera where keyboard input is not captured sequentially
• [#3903] Fixed bug where upward/leftward selection by mouse drag does not scroll viewport

Public Beta 14.5 (rev 4625)

• Various stability and performance improvements

Public Beta 14.4 (rev 4579)

• [#5087] Fixed critical bug where rapid mouse scroll crashes FireFox

Public Beta 14.3 (rev 4570)

• [#5548] Fixed bug on sheet object creation
• [#5538] Fixed bug where public user cloning a spreadsheet with MDF generates exception

Public Beta 14.2 (rev 4559)

• Sheet object caching
• Fixed back-end memory leak
• [#5228] Fixed bug where HTML publishing cache is not up-to-date

Public Beta 14.1 (rev 4525)

• [#5408] Google Personalized Homepage integration — add EditGrid to your Google Personalized Homepage now
• [#5091] Pageflakes integration — add EditGrid to Pageflakes now
• HTML export and post-to-blog regression
• border redraw optimisation

Public Beta 14 (rev 4446)

The most notable new features in this release are:

• [#5299] Event-driven RTU — EditGrid users have grown accustomed to the RTU feature, whereby co-editors can see each other’s changes in 5 seconds. This re-written version of RTU now goes one step further — changes made by others are instantly updated on your spreadsheet subject to network latency. This will allow even greater responsiveness, and reduce risks of conflict. Currently available to personal users only.
• [#3913] Cell border — yet another frequently requested spreadsheet functionality now available.
• [#5276] IE performance enhancement — fixed a bunch of memory leaks in IE when using EditGrid.

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

Other new features include:

• [#5356] Support If-Modified-Since header for exports and chart images
• [#5226] Allow password recovery by email address alone
• [#5308] Recent charts list — available at http://www.editgrid.com/recent/charts/
• [#5339] Enabling word wrap would automatically expand row height if necessary

Also fixed in this release are:

• [#5444] Prohibit login with underscore for organisation
• [#5407] Enable text overflow for new spreadsheet by default
• [#5297] Can’t export past revision
• [#5405] Paste cross-sheet formula across spreadsheet appears to work but doesn’t persist
• [#5110] White cell background applied upon exporting
• [#5409] Search2Grid regression
• [#5310] Fixed bug where chart can’t show Simplified Chinese characters
• [#5401] Grid2Map regression

Public Beta 13.7 (rev 4335)

• Accept multiple row/column operation commands in API
• Fixed bug in default font colour
• [#4430] Allow readers of password-protected read-only spreadsheets to view sheet property
• [#5416] Disable My Workspace search scope in EditGrid Finder for public users
• [#5421] Centre-align EditGrid Finder and View in IE