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

Public Beta 13.6 (rev 4288)

• [#5415] Workaround for index out of bound exception in EditGrid Finder

Public Beta 13.5 (rev 4267)

• [#5414] Fixed bug where RTU fails on charts with cross-sheet reference of degree >= 2
• [#5406] Fixed bug where wrapped overflow text does not get trimmed

Public Beta 13.4 (rev 4245)

• Show 10 rows in finder result
• [#5333] Support graphic objects as on imported spreadsheets
• Optimisation on chart rollback

Public Beta 13.3 (rev 4231)

• [#5254] [#5344] EditGrid Bookmarklet — refer to http://www.editgrid.com/article/tools#bookmarklet for instruction of use
• Multiple row/column selection regression

Public Beta 13.2 (rev 4196)

• [#4424] Fixed wording for default formatting option for foreground colour
• [#5379] Upload new version regression
• [#5364] Fixed bug where text overflow and freeze pane cause grid error
• [#4946] Fixed bug where insert formula would insert a wrongly formatted formula in Opera
• [#4818] Visible key to enter edit mode in Opera
• [#4941] Partial support of hotkeys in Opera
• [#4951] Partial support of mouse wheel in Opera

Public Beta 13.1 (rev 4173)

• Show last modified time in Finder result
• [#5371] Finder excludes deleted spreadsheets
• [#5374] Finder excludes past revisions
• [#5372] Fixed bug where setting foreground colour would set background colour as well

Public Beta 13 (rev 4166) is the last of a series of releases in the current phase of development, where commonly used spreadsheet functionalities have been gradually rolled out, with the goal of developing a usable and basic spreadsheet online, alongside unique online spreadsheet features. With Public Beta 13 the EditGrid team is satisfied that most general-user functionalities as well as some of the most fundamental expert-user functionalities are completed, and that EditGrid is ready for most general-purpose usages. The remainder spreadsheet functionalities will be implemented as need arises in the next phase of development.

The most notable new features in this release are:

• [#5153] Finder — use the new Finder button at the top navigation bar to conduct contextual search on all public available spreadsheets, or just your own.
• [#5127] [#5128] Import/export in OpenDocument 1.0 (.ods) and OpenOffice Calc 1.* (.sxc) format
• [#5055] Export to PDF
• [#4128] Overflow text to adjacent cells — option now available at menu bar to toggle it on/off
• [#5098] EditGrid as an online Excel viewer — go to http://www.editgrid.com/viewer/ and key in an URL, and EditGrid will import it for your viewing pleasure.
• [#5306] Auto fit row height for cells with word wrap toggled on.
• [#5283] More languages under ELP — Danish, Dutch, Russian and Vietnamese now available for translation.

Other new features include:

• [#4372] Clone from a previous revision
• [#5038] Static link to localised pages
• [#5321] Fast login
• [#4795] Context menu at row/column header
• [#5303] Hotkeys for copy to/paste from clipboard — Ctrl+Shift+C and Ctrl+Shift+V
• [#4585] Allow reader to access remote data list
• [#4444] Allow copying/cloning a spreadsheet at sheet properties
• [#4601] Enable double-click to apply formatting in advanced data formatting toolbox
• [#5250] Allow labeling axis on charts
• [#4343] Mass resize column/row
• [#5295] More date format options
• [#5247] HTTPS authentication for everyone
• [#4424] Default format option available for text alignment, font face, foreground colour and background colour

Also fixed in this release are:

• [#5328] Fixed bug where /new causes endless loop to any browser/bot w/o cookies support
• [#5262] Opera support regression
• [#5324] L10n preview site language list incomplete
• [#5325] Pre-select all in paste from clipboard dialogue text area
• [#4942] Cannot select multiple rows or columns in Netcape 8.1
• [#5260] Mutiple row/column selection regression in FF
• [#5151] Close find box upon hitting Esc
• [#4844] Safeguard on too many cells exhibiting RTU effect at once
• [#5179] Inhibit grid admin messages on post-to-blog grids

Public Beta 12.3 (rev 4018)

• Allow capital letters in MDF extension
• [#5296] The charts move while scrolling

Public Beta 12.2 (rev 3987)

• [#5241] Fixed bug where API fails to properly convert underscores in spreadsheet names
• [#5266] Add RSS icon on recent spreadsheet list
• [#5270] Allow user with read permission to retrieve chart permalink
• [#5225] Fixed bug on password protected spreadsheets’ post-to-blog in IE
• [#5234] Fixed bug where Password-protected spreadsheets gives JS error in IE upon post-to-blog
• [#5272] Fixed bug where chart does not support sheet name with space
• [#5273] Fixed bug where chart on a spreadsheet in trash accessible via sheetobject permalink
• [#5271] Fixed bug where roll back fails to revert chart actions
• [#5261] Front-end engine memory optimisation for FF
• [#5257] Fixed bug where remote data are fetched to locked cells

Public Beta 12.1 (rev 3956)

• German version deployed. Congratulations to all contributors to the German translation spreadsheet.
• [#5210] Bulgarian translation spreadsheet available and open for translation under the EditGrid Localisation Project (currently offline - 2008-03-13)

Public Beta 12 (rev 3944) incorporates one important and frequently requested feature:

[#3932] Charting. Users may now create a wide range of charts on EditGrid, import charts from .xls and other supported file formats, and export charts onto user’s desktop. Better still, each chart comes with a permalink as well — meaning that charts on public readable spreadsheet can be directly linked from blogs or any other websites.

Other new features include:

• [#5224] Allow organisation user login at home page using the scheme orgname/username
• [#5217] Access My Data Format at the spreadsheet menu at My Workspace

Also fixed in this release are:

• [#5227] Allow up to 50 characters for My Data Format extensions
• [#5222] Allow users with read permission to access My Data Format
• [#5243] Fixed bug where a spreadsheet with any My Data Format can’t be purged
• [#5148] Fixed bug where lock owner can’t sort over locked region

And bug fixes for API since this release include:

• [#5235] Invalid argument in method doImport
• [#5183] API export regression

Public Beta 11.4 (rev 3861)

• [#5229] Add/remove sheet regression

Public Beta 11.3 (rev 3858)

• [#5223] Fixed bug where lock owner can’t enter edit mode in locked region if he/she is not spreadsheet owner
• [#5212] Find toolbox lost focus in IE upon invocation
• [#5216] Lock over lock regression

Public Beta 11.2 (rev 3845)

• [#5213] Show anonymous edit on Recent Spreadsheets
• [#5214] Provide RSS feed for Recent Spreadsheets

Public Beta 11.1 (rev 3837)

• [#5174] Sanitise viewport upon resizing browser window
• [#5173] Do not freeze pane when cursor is not in viewport
• [#5205] Set lower bound properly when only a row/column is frozen
• [#5187] Inhibit organisation users’ spreadsheets on Recent Spreadsheets list
• [#5188] Black background regression
• [#5203] Prompt for password when accessing password-protected spreadsheet from permalink

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

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

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

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

Public Beta 9.3 (rev 3487)

• [#4932] [#4997] Style importing regression
• Replaced JavaScript disabled warning with image

Public Beta 9.2 (rev 3480)

• [#4742] Advanced grid connection failover
• Merged grid stylesheet into one to improve loading speed

Public Beta 9.1 (rev 3466)

• Fixed exception in cloning a template
• [#4995] Fully localised home page
• [#4993] Support characters !, # and % in deep permalink

EditGrid Beta 9 (rev 3435) incorporates the following notable new features:

• [#4286] Home page revamp
• [#4971] Spanish version deployed — congratulations to all contributors on the Spanish translation spreadsheet who have made it 100% translated in barely a week’s time!
• [#4107] Deep permalink (sheet and cell level) — can now go directly to a sheet or retrieve the value of a specific cell by passing these URLs to your favorite browser:
  • www.editgrid.com/user/a_user/a_spreadsheet/Sheet2
  • www.editgrid.com/user/a_user/a_spreadsheet/Sheet2!B3
• [#4422] Upload a new version of an existing spreadsheet. The uploaded content will be made a new revision of the selected spreadsheet.

More new features will follow in patches to Public Beta 9 soon coming.

Other new features include:

• [#4693] Allow adding sheet note/tag by clicking “no tag/note”
• [#4918] Show organisation user’s status on user listing
• [#4773] Disable undo/redo when there is no application action on queue
• [#4296] Indicate progress while managing share to users
• [#4452] Usability improvement on sheet navigation, including:
  • [#4386] automatic widening for wider browser window
  • [#4510] the [+] button
• [#4538] Pre-fill remote data tool box with currently focused cell
• [#4094] Publish change log in RSS
• [#4846] Language selection menu at header
• [#4612] Recognise email addresses
• [#4083] Multiple selection with shift+left-click
• [#4873] Enabled hyperlink recognition at post-to-blog

Also fixed in this release are:

• [#4965] Do not localise default sheet name
• [#4794] Accept double quotation marks in number format string
• [#4975] Fixed inconsistent behaviour of show locked region on read-only spreadsheets
• [#4916] Inhibited browser’s native context menu at unlock cell/region button
• [#4935] Fixed garbage file exporting invoked at menu bar
• [#4931] Update menu bar items on click
• [#4906] Fixed bug where sorting + undo/redo would render cell formatting wrong
• [#4450] Fixed bug where a spreadsheet can be shared to the same user twice if hit in quick succession
• [#4876] Display last modified time on spreadsheet lists where time is 0 second
• [#4545] Fixed unlock button behaviour in past revisions
• [#4805] Fixed bug where sheet properties would become unscrollable when there is a very long tag
• [#4454] Fixed bug where a sheet would be re-ordered inadvertently
• [#4891] Fixed bug in copying unicode characters from clipboard
• [#4855] Do not show deleted spreadsheets in search result
• [#4725] Encode parantheses in permalinks
• [#4869] Adjusted column widths at My Workspace for localised versions
• [#4730] Fixed exception where non-owner attempts to roll back to a previous revision
• [#4830] Fixed bug where the whole sheet is copied upon selecting a row/column for copying to clipboard
• [#4880] Fixed critical bug where l10n would break organisation user portal
• [#4768] Ctrl+` in IE
• Extended sorting timeout to 120 seconds
• [#4724] Critical performance enhancement of paste-from-clipboard
• [#4733] Undo paste-from-clipboard in one step
• [#4769] Auto-fill regression
• [#4845] Insert row/column regression
• [#4863] Tooltip at tool bar in FireFox
• [#4970] Fixed critical bug upon sheet renaming
• [#4398] Vertical scrollbar missing
• [#4829] Fixed false security warning on click at menu bar
• [#4682] Usability enhancement of location of context menu in small browser windows
• [#4648] Update references properly for cut-and-paste

And new functionalities supported by API since this release include:

• Imposed API access limit: 3,000 per IP within 24 hours; 1,000 per user within 24 hours
• [#4890] Tab separated values format for get/set cells methods

Public Beta 8.2 (rev 3257a)

• [#4891] Non-latin characters now pasted properly from clipboard
• Extended timeout for sorting
• [#4874] System robustness improvement: restricted maximum number of cells to be imported at 30,000
• [#4765] Fixed critical issue where formulae were not updated upon renaming a sheet
• [#4865] Fixed bug where undoing a sorting of formula references would still give #Ref!
• [#4867] Fixed bug where after inserting a row at the top, a column lock fails to be unlocked

Public Beta 8.1 (rev 3150)

• Fixed bug in remote data: used default language where none is defined
• Fixed unexpected behaviour upon pressing Tab at formula bar
• [#4856] Hotkey for sorting

EditGrid Beta 8 (rev 3107) incorporates the following notable new features:

• [#2721] Undo/redo
• [#3017] Sorting
• [#4417] [#4418] [#4419] Localisation: Traditional Chinese and Simplified Chinese user interfaces available; and more coming soon.

Other new features include:

• Front-end library revamp
• Allow any user with read access to email a spreadsheet
• [#4379] Prompt user to accept a pending invitation at Incoming Spreadsheets upon access
• [#4174] Restore/purge multiple spreadsheets at Trash at once
• [#4667] Further enhancements on menu bar

Also fixed in this release are:

• [#4826] Display spaces in sheet name at sheet navigation
• [#4831] Rename link at menu bar for unsupported browser
• [#4479] Post to blog shows difference cell height in Microsoft Internet Explorer and Mozilla FireFox
• [#4405] Improved filename handling at send by email
• [#4821] Improved handling of special characters (\ / # ? . % *) in tags
• [#4760] Fixed potential privacy issue while creating new spreadsheets
• [#4705] Fixed bug where roll back to previous revision fails to roll back sheet renaming
• [#4672] Notes and tags alignment on public sheet list
• [#4741] (# 50) Fixed security issue where login with JavaScript disabled would expose password at URL
• [#4684] Fixed link of permalinks on menu bar
• [#4726] Import default style properly
• [#4694] Captured hotkey properly while not focused on grid
• Improved word wrap handling for HTML exporting
• Enhanced performance for repetitive row/column insertion/deletion
• [#4692] Removed tags when a co-editor rejects an incoming spreadsheet
• [#4703] Unified menu items under My Workspace
• [#4446] Clear toolbar button states properly upon deleting row/column
• [#4687] Do not allow owner to apply lock over a range locked by another user
• [#4709] Fixed default date/time formatting output for =NOW()
• [#4766] Fixed file download bug

And new functionalities supported by API since this release include:

• Fixed bug where a logged in user cannot create new sheets
• [#4657] Integration with My Workspace, first level
• [#4698] Export spreadsheet
• Sudoku mini-app
• Fixed style mask issue
• Fixed critical issue when calling SheetAdd

Public Beta 7.4 (rev 3011)

• [#4707] Restricted HTML exporting to first 3,000 rows
• [#4735] Security fix: user without read access should not be able to export a spreadsheet
• [#4711] HTML exporting: Powered by EditGrid wording

Public Beta 7.3 (rev 2947)

• [#4713] Applied and saved default style to spreadsheets properly

Public Beta 7.2 (rev 2927)

• [#4714] Fixed critical bug where loading grid in Safari would crash browser (support for Safari is still on the way)

Public Beta 7.1 (rev 2911)

• Word wrap in HTML exporting
• [#4218] Fixed bug of Ctrl+End keystroke sequence
• [#4707] Restricted HTML exporting to first 10,000 rows
• [#4671] Re-written front-end code to avoid being falsely filtered out by content-based proxy servers
• Performance enhancement on repeated row/column insertion/deletion
• Restricted paste region size
• Fixed tag picker bug on trailing space
• Fixed remote data bug where selecting Exchange Rate would load a new page
• Improved context menu alignment strategy

Like previous major releases, EditGrid Beta 7 (rev 2856) is a continuous improvement release with new features in both spreadsheet functionalities and unique web-based collaboration features. The most notable new features are:

• [#3736] Cut/copy-and-paste from EditGrid to MS Excel and other desktop applications
• [#3737] Cut/copy-and-paste from MS Excel and other desktop applications to EditGrid
• [#4278] Cell/range locking
• [#4395] Menu bar in grid mode
• [#4508] Spreadsheet tagging

Other new features include:

• [#4602] Ctrl+1 — hotkey for advanced number formatting
• [#3965] Word wrap — wrap long sentences to next line
• [#4647] Unmark a previously marked revision
• [#4621] More currency support — R$ (Brazilian real)
• [#4487] Added reference to EditGrid on exported HTML version
• [#4598] Support conditional colouring at advanced number formatting

Also fixed in this release are:

• [#4446] Fixed bug where deleting row/column fails to update toolbar button states
• [#4615] Fixed forced logout upon IP mis-match
• [#4574] Only co-editor with write access can edit sheet notes
• [#4611] Do not encode space when downloading multiple spreadsheets
• [#4622] More robust handling of remote data input
• [#4607] Post-to-blog “Powered by EditGrid” button should open new window
• [#4608] Fixed MSIE JavaScript error upon resizing grid
• [#4522] [#4524] [#4596] [#4599] AJAX improvements on remote data
• [#4543] Update remote data reference upon row/column insertion/deletion
• [#4551] Fixed bug where remote data feeds empty value for unavailable markets
• [#4643] Fixed remote data for Asian markets

And new functionalities supported by API since this release include:

• [#4594] Style
• [#4576] Only co-editor with write access can edit sheet notes
• [#4641] Check for deleting last sheet
• [#4629] Host-based authentication
• [#4557] Fixed inconsistent organisation name output for personal user
• [#4609] Web login

Public Beta 6.3 (rev 2660)

• [#4606] Currency format for 0 decimal place
• [#4610] Advanced number formatting for Mozilla FireFox 1.0

Public Beta 6.2 (rev 2632)

• [#4284] Advanced number formatting — now fully support date, time, currency and custom format string.

Public Beta 6.1 (rev 2619)

• [#4586] Fixed severe relative references update bug upon row/column insertion/deletion
• [#4579] Fixed false security warning when loading grid in Internet Explorer with organisation account
• [#4578] Granted write authorisation properly to password-protected spreadsheet
• [#4563] Fixed bug where FireFox appears to load the page for ever when opening EditGrid in iframe
• [#4577] Fixed IE runtime error
• [#4571] Fixed wrong MIME type at download multiple spreadsheet
• [#4570] Shift+Home|End keystroke sequence
• [#4565] Message history order

We have added many unique features starting from EditGrid Beta 6 (rev 2565), in addition to many useful spreadsheet functionalities. The most notable new features are:

• [#4336] [#4484] Remote data — get live updated stockquote and forex on your spreadsheets!
• [#4457] Basic API — see EditGrid Labs for more!
• [#3681] Drag-and-fill values and formuale
• [#3695] [#4171] Many more useful keyboard hotkeys, including [#4415] Ctrl+Shift+PgUp|PgDn for switching between sheets
• [#4149] Smarter version control. This entails the following changes:

  1. Auto-saved versions are now treated as temporary. The system keeps at most 20 auto-saved versions for every spreadsheet.
  2. User can “mark” an auto-saved version by providing a description. The system keeps all “marked” versions.

  To allow you to preserve and migrate past versions, all versions saved before this change are made “marked” for the time being.

Other new features include:

• [#4397] Download multiple spreadsheets at once
• [#4500] Select post-to-blog and sheet properties on menu at |My Workspace|
• Show Edit Lock status on public sheet list
• [#4434] Implemented cursor per sheet (previously only supports cursor per spreadsheet)
• [#4359] Enhanced HTML export
• [#4157] Administrator message in grid mode
• [#4326] Support URL data type
• [#4396] Send spreadsheet by email

Also fixed in this release are:

• Ask for confirmation at rollback to previous revision
• Disabled caching for post-to-blog in iframe mode
• Fixed leftward/upward scrolling malfunction
• [#4540] Fixed post-to-blog JavaScript mode malfunction
• [#4542] Fixed number formatting persistence issue
• [#4535] Warning for uploading unsupported file formats
• [#4446] [#4486] Rest toolbar button states and formula bar upon leaving current cell or applying cell formatting
• [#4481] Disabled delete sheet where there is only one
• [#4435] Fixed bug where rollback fails to clear newly created sheet
• [#4291] Fixed bug where a manual-input time value is formatted as a date
• [#4402] Fixed add to bookmark malfunction
• [#4403] Edit Notes at Sheet Properties
• [#4404] Fixed share to users malfunction at Sheet Properties

Public Beta 5.3 (rev 2396)

• Enabled response compression to further reduce traffic load
• [#4488] Fixed bug grid shows bottom of the grid upon insert column after delete all rows
• Database command optimisation
• [#4475] Fixed bug where Clear Contents at context menu appears to work on a read-only spreadsheet posted to blog
• Fixed bug where a row/column insertion/deletion overflows the usable grid area

Public Beta 5.2 (rev 2296)

• [#4451] Fixed style persistence issue
• [#4448] Clear All really clears all formatting
• [#4412] Style change RTU
• [#4344] Fixed resize problem for posting EditGrid Lite to blog

Public Beta 5.1 (rev 2274)

• Improved post-to-blog performance for large spreadsheets
• [#3907] Highlight a row/column
• [#3014] Cut/copy-and-paste a row/column
• [#4238] Fixed bug in FireFox 1.0.7 and 1.0.8 when highlighting long cell content in the formula bar
• [#4208] Improved handling of email verification requests
• [#4401] Clear Contents and Clear All (accessible from context menu)
• Better handling of null passwords at sharing with password
• Fixed link at function picker
• Fixed bug in Camino where context menu does not work on sheet navigation
• [#4430] Allow user with read privilege to access sheet properties
• [#4330] Enhanced style handling at back-end
• Performance improvement at the front-end for row/column insertion/deletion
• [#4347] Import all styles fully
• Fixed bug in IE where styles are not shifted upon row/column insertion/deletion
• [#4411] Allow user with read privilege to post to blog

In continuation with our development philosophy, EditGrid Beta 5 (rev 2202) blends new features unique to the web with back-end improvement to support conventional spreadsheet functionalities. The most notable new features are:

• [#2707] [#4334] Create more than one spreadsheet under a workbook — right-click at |Sheet 1| to create/rename/delete a spreadsheet
• [#3560] Post to blog — go to Sheet Properties and see how it works!
• [#4105] Stockquote robot for currency exchange
• [#4325] Stockquote robot for world major indices

Other new features include:

• Show |My Workspace| at top navigation bar to logged-in users
• [#3799] Allow user to name and save a new sheet in grid mode
• [#4185] Optimised width of row headers
• [#4303] Allow copying on spreadsheets with read access
• [#4179] Allow search engine to cache HTML version of public-readable spreadsheets
• [#4329] Allow user to opt-in to receive news and announcements
• [#4236] Fast switching between grid mode and sheet properties
• [#4146] Graphical user interface for sheet locking in |My Workspace|
• [#4233] Revamped user removal mechanism for organisation accounts
• [#4101] System messages to registered user
• [#4108] User can now configure his/her own time zone
• [#4304] Send email to invite friends

Also fixed in this release are:

• [#4314] Re-activated rollback to previos revisions
• [#4322] Formula display error upon row insertion
• [#4351] Improved performance of loading Home page
• [#4143] Quick login button for logged-in user to switch to another account
• [#4373] User with read privilege can view revision history
• [#4390] User with write privilege can rollback to a previous revision

Public Beta 4.1 (rev 2073)

• Improved grid loading time by 75% by trimming down JavaScript bundle file size
• [#4318] Import safeguard: restrict import file size to 1MB
• [#4315] Fixed email spreadsheet link
• Fixed bug on import with an empty string in UTF-8
• [#4305] Fixed bug where range formatting would apply style of first cell to rest of the range
• [#4302] Fixed bug where colour is not imported correctly
• Fixed bug where line-break is not displayed correctly
• [#4247] Context menu in FireFox with certain extensions installed

EditGrid Beta 4 (rev 1925) is a major release upon an important revamp to the back-end architecture for storage and computation. The most notable new features are:

• Absolute and relative referencing fully supported — now EditGrid will automatically update formula reference for you upon copy-and-paste and row/column insertion/deletion.
• Advanced importing — import cell data and formula as well as row/column size, cell alignment, font size, cell background and other spreadsheet onto EditGrid. Displayed to the extent supported by Public Beta 3.
• More functions supported — 500+ functions now fully supported for maximum inter-operability with MS Excel and other common spreadsheet applications.

Other new features include:

• [#4129] Insert line-break at grid mode
• [#4261] More user-friendly error pages
• [#4280] Quick link for uploading spreadsheet
• [#4184] More prominent Upload button
• [#4183] Export button in grid mode
• [#4186] [#4260] Toolbar outlook revamp

Also fixed in this release are:

• [#4293] Log out after selecting “remember me”
• [#4247] Display context menu correctly on FireFox with certain plugins installed
• [#4270] Effect of pasting style
• [#4269] JavaScript error upon hitting Ctrl+Enter
• [#4272] Deleted sheet appears on public sheet list
• [#4271] Sheet cloning malfunction
• Robots’ edits should update a spreadsheet’s last modification user and time

Public Beta 3.1 (rev 1726)

• [#4231] Past revisions should be readonly
• Fixed link to retrieve blog’s RSS feed
• New release box on home page
• [#4222] Fixed MROUND() (hopefully, no need to fix these any more from next release onwards)
• [#4198] FIXED ROUND() (hopefully, no need to fix these any more from next release onwards)
• [#4188] Do not warn against unsaved and unmodified new spreadsheet, but warn against unsaved imported spreadsheet

EditGrid Beta 3 (rev 1664) sees a critical improvement on the usability on the web. Notable new features include:

• [#3708] RSS feed of public sheet list
• [#4148] Enhanced range editing performance
• [#4217] Enhanced range formatting performance
• [#4144] More usable mouse scroll
• [#4141] Declare support of all browsers based on Gecko 1.7+
• [#4175] Better differentiate between insert row/column and delete row/column
• [#4169] Link to function reference from function picker
• Revamped home page
• [#3925] Sheet properties
• [#3968] Highlight active row/column header
• [#3905] Single cell cut/copy, multiple cell paste
• [#3906] Multiple cell cut/copy, multiple cell paste
• [#4121] Copy from one spreadsheet, paste at another spreadsheet (same session)

Also fixed in this release are:

• [#4131] in find toolbox would now start finding the next match
• [#4196] COUNTIF() can now count string values
• [#4195] Context menu on sidebar
• [#4192] Fixed bug where hiding a toolbox (eg function picker) on an unsaved spreadsheet may lead to data loss
• [#4124] String formula references now updated automatically
• [#4137] Fixed bug where focus on grid is lost after closing a toolbox

Public Beta 2.2 (rev 1532)

• [#4181] Fixed bug where screen fails to move with cursor to the right upon dragging
• Show anonymous user when the last modifying user is unregistered
• [#4170] Ctrl+End
• [#4148] Improved performance of range operations (delete, cut/copy-and-paste, apply cell formatting &c.)
• [#3848] Fixed sheet name acceptance and parsing bug
• [#4159] Decimal number without leading zero (eg .05) now treated as a number
• [#4168] Fixed number alignment bug

Public Beta 2.1 (rev 1461)

• [#4142] Minor enhancement on toolbar
• [#4145] Find should be case-insensitive
• [#4097] Cascading formula evaluation bug
• [Cancel] button in grid mode

EditGrid Beta 2 (rev 1431) is the second release targeted for trial use by public users. The focus of this release is on the user experience on the grid as well as features on the user workspace.

Notable new features include:

• [#4134] Export a sheet on the public sheet list
• [#3929] Pick formula parameter by mouse
• Summation button on toolbar
• Post to del.icio.us button
• [#4100] Link to public sheet lists
• [#3878] Trash, and restore deleted sheet
• |My Workspace| revamp
• [#4020] Find cell data
• [#3804] Recover lost password
• [#3914] Context (right-click) menu on the grid
• [#3938] Change history tracking
• [#4060] Email verification
• [#3803] Use cookie to remember login
• [#4084] Function picker
• [#3949] Password protection on sheets

Also fixed in this release include:

• [#4133] Graciously handle browsers which block the Print dialogue
• [#4097] Cascading formula evaluation and pasting
• [#4120] SUBSTITUTE() evaluation
• Cross cursor in Microsoft Internet Explorer
• [#4109] Formulae which return TRUE display “1″ instead
• [#4110] OR() evaluation
• [#4096] Improved decimal number precision
• [#4112] CONCATENATE() spelling

Public Beta 1.2

• Fixed UTF8 issue on URI

• [#4089] Fixed failure of permlink for a username with an underscore (_)

EditGrid Beta 1 (rev 1219) is the first release targeted for trial use by public users — both personal and corporate. The focus of this release is on the core features essential for business use.

Notable new features include:

• Organisation account
• [#4065] Per-organisation login page
• [#3467] Eye-catching notification of changes from remote through RTU
• [#4026] Permlink for exporting — try http://www.editgrid.com/user/personal/My_Timetable.xls !
• Permlink for HTML version — see http://www.editgrid.com/user/business/Customer_Contact_List.html .
• [#3948] Sheet owner can assign readonly or read-write privilege to co-editors
• [#3933] Number formatting
• [#3931] Show bounding box upon cut/copy
• [#3839] Print button
• Multiple sheet deletion
• [#3473] Copy a sheet
• [#4025] Change password
• [#3988] Neat and simple colour picker
• [#4004] Line break
• [#3983] Export cell formatting
• [#3975] Better warning against connection timeout, failed response or permission denied
• [#3978] Support uploading Gnumeric, OOo Calc, Lotus 1-2-3 and CSV formats
• [#3934] Select multiple cells by holding shift+arrow keys
• [#3919] Status area
• Support MSIE 7

Also fixed in this release are:

• [#4053] Update formula value upon insert/delete row/column
• [#4052] Fixed bug where a sheet whose name contains ” is inaccessible
• [#3999] Location bar path of access
• [#3855] Circular reference — now fixed using Strongly Connected Component (SCC) algorithm
• [#39973997399739973997399739973997...]
• [#4022] Fixed bug where user appears to be able to change font face and size of a readonly sheet
• [#4007] now works

EditGrid PR3 is geared towards new features as required by real usage and bug fixes on the previous release. Notable new features include:

• New templates for personal and business use
• Implemented 16 new functions including VLOOKUP(), SUMIF(), COUNTIF(), RANK() and MATCH()
• [#3921] [#3922] Font colour and cell background colour selection
• [#3920] [#3944] Select font face and size
• [#3923] Revamped My Public Sheet List
• Revamped My Workspace
• Enabled sheet notes
• Displayed a sheet’s last edited user and timestamp at My Workspace

Fixes include:

• [#3904] Fixed bug where deleting a row/column doesn’t update row height/column width
• [#3795] Fixed session timeout bug
• [#3985] Enhanced importing performance
• [#3726] Fixed bug where inserting/deleting a row/column doesn’t shift the focused cell on co-editor’s grid
• [#3963] Fixed bug where a ” in formula would break grid
• [#3796] Indication on read-only sheet
• [#3868] Warning where browser does not support Javascript
• [#3902] Fixed issue of multiple selection on FireFox 1.0
• [#3874] Warning when a user quits an unnamed/unsaved sheet
• Added “saving…” icon on grid
• (Re-)enabled cross cursor on grid
• [#3891] Fixed bug where grid would blank upon scrolling on FireFox 1.0
• Revamped grid breadcrumb
• [#3873] Better support of scrolling on FireFox for Mac OS X
• Performance enhancement on loading large sheet
• Full Unicode support
• [#3847] Fixed row/column resize bug
• … and numerous other miscellaneous issues.

• [#3891] Fixed bug where grid would disappear upon switching to edit mode after scrolling or resizing
• [#3830] Fixed sheet creation bug
• [#3810] Show revision number

Private Release 2.1

• Backward support for FireFox 1.0+

Private Release 2

• More keyboard hotkeys
• Fine-tuning of grid performance
• Multiple-cell selection
• Multiple-cell cut, copy and paste
• Multiple-cell apply formatting
• Create new sheet by URL (try it out at http://www.editgrid.com/new now!)

Private Release 1.3 @ February 2006

• Grid interaction revamp
• Web interface revamp
• Incremental scrollling
• Insert/delete a row/column
• Unicode support on sheet name

Private Release 1.2 @ January 2006

• Sheet access privilege control (private, public read-only, public read-write)
• Sheet co-editorship
• Cell formatting (bold, italic, underline)
• Cell alignment (left, centre, right)

Private Release 1.1 @ December 2005

• Unicode support on sheet content
• Multiple sheet per user
• Cut, copy and paste

Private Release 1 @ November 2005

• Keyboard navigation
• User-defined formulae
• 118 functions
• Import from MS Excel format
• Export to MS Excel format
• User registration
• One sheet per user