Changes from the Previous Release

This version of the product has the following changes.

• Earlier versions of SpreadJS cannot load JSON files created with the current version of SpreadJS.
• The evaluateFormula method has the useR1C1 parameter.
• The suspendCalcService and resumeCalcService methods in the Sheet class have parameters.
• The suspendCalcService and resumeCalcService methods have been added to the Spread class.
• SpreadJS provides additional function modules to reduce JavaScript file size.
• The context parameter has been added to methods in the BaseCellType and CustomCellType classes.

Enhancements from the Previous Release

The following features have been added with this version of the product.

• Widget Features
• • Area, Scatter, Pie, and Custom Sparklines have been added.
  • Column, Line, and Winloss Sparklines can be added with formulas.
  • The allowSheetReorder method has been added.
  • The useTouchLayout method has been added.
  • The jQuery UI is no longer required.
  • The formula text box has been added.
  • Arrary formulas are supported.
  • The setActiveSheet method has been added.
  • The getSheetIndex method has been added.
  • The SheetNameChanged and SheetNameChanging events have been added.
  • The rangesToFormula method has been added.
  • Options to save and load JavaScript files have been added.
• Cell Features
• • The Spacebar key has been added as a default reserved key for the button, hyperlink, and check box cell types.
  • The isReservedKey, processKeyDown, and processKeyUp methods have been added.
  • The imeMode method has been added.
  • Cell comments have been added.

Resolved Issues

The following issues have been resolved since the last release.

• The CellClick event now occurs on IPad2 devices. [71847]
• Virtual Keyboard does not pop up when the user clicks on the checkbox cell in SpreadJS. [71121]
• Cell value is not copied in the hidden rows when dragging the cell in a filtered row collection. [69924]
• User Defined format code works in SpreadJS. [69915]
• Formulas are correctly calculated in a specific row of a specific sheet in SpreadJS. [69653]
• The setShowFilterButton method of SpreadJS works normally. [69561]
• The browser no longer stops responding when multiple calculations are performed. [69544]
• Formulas starting with "=+" work correctly. [69442]
• Formulas are imported correctly when loading files using ExcelIO. [67469]
• Custom Name Expression is updated after adding rows. [68272]
• Excel files created using LibreOffice are exported to PDF correctly. [66367]
• Cross sheet reference formulas are updated when the data in the dependent sheet is changed by resetting its data source. [65995]
• Pinch zoom in and out touch gesture for SpreadJS works in IPad2 tablet. [65953]
• T.Test formula of Microsoft Excel 2013 evaluates correctly. [65604]
• AutoFit behavior is correct when columns have span and text word wrap. [65186]
• Data validation that references another spreadsheet works in the Designer. [64618]
• Memory issues are resolved. [64597]
• VLOOKUP function finds an exact match in SpreadJS when using Excel IO service to import an excel file. [64399]
• Keyboard navigation works in SpreadJS, when it is used on an aspx page along with script manager. [63132]