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)