Enhancements from the Previous Release

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

• Widget Features
• • The bullet, Spread, stacked, vari, box plot, cascade, hbar, and vbar sparklines have been added.
  • The pareto sparkline has been added.
  • Custom cultures are now supported.
  • More formulas have been added.
  • The formula text box now supports table names and custom names.
  • TypeScript support is now available.
  • Touch support has been improved.
  • JSON Schema support has been added.
• Sheet Features
  • Tag support has been added.
  • Custom formats are now supported.
  • The wildcard character is now supported in some formula functions.
  • Binding support has been added for tables.
• Cell Features
  • The combo box cell has been enhanced.
• New Methods
  • The showDragFillSmartTag method has been added.
  • The defaultDragFillType method has been added.
  • The getDirtyRows method has been added.
  • The getDirtyCells method has been added.
  • The hasPendingChanges method has been added.
  • The clearPendingChanges method has been added.
  • The getInsertRows method has been added.
  • The getDeleteRows method has been added.
  • The scrollbarMaxAlign method has been added.
  • The scrollbarShowMax method has been added.
  • The enableFormulaTextbox method has been added.
  • The refresh method has been added.
  • The getHost method has been added.
  • The getAutoFitWidth method has been added.
  • The getAutoFitHeight method has been added.

Resolved Issues

The following issues have been resolved since the last release.

• The duplicate rule now has a faster response. [93053]
• Formulas with custom names that contain mutated vowels are now correctly imported. [92964]
• The Spread sheet layout is now correct when setting the canUserDragFill option. [92950]
• The SpreadJS drop-down list is displayed, when the z-index of the SpreadJS host element is greater than 0. [91837]
• The cell vertical alignment now works correctly. [91731]
• The FormulaTextBox does not input the formula when the canUserEditFormula method is false. [91663]
• SpreadJS works correctly after importing an Excel file which has page break settings. [91178]
• The sheetTabDoubleClick event is raised correctly, when the tabEditable method is set to false. [90612]
• The behavior is now correct for some locale settings. [90459]
• SpreadJS now displays normally on mac retina display (13" and 15"). [90354]
• Column headers are now unchanged after copying or pasting the column from one sheet to another. [90085]
• The createListValidator method accepts number strings. [89811]
• Ctrl+Z works correctly when the sheet is protected. [89157]
• The Bold and Italics style in the sample now works correctly in Microsoft IE and Mozilla FireFox. [89057]
• Importing to SpreadJS in Microsoft IE8 now works correctly. [86792]
• SpreadJS now works with wijgrid in the same angularJS page. [85147]