Changes from the Previous Release

This version of the product has the following changes.

• The default action for the Tab key has changed.
• The default action for Shift + Tab has changed.
• Additional event arguments have been added to the RangeChanged event.
• The ButtonClicked event has an additional argument.
• The setArrayFormula, getFormula, getFormulaInformation, and hasFormula methods have less arguments.
• The setShowFilterButton and getShowFilterButton methods have been changed to the filterButtonVisible method.
• The Array class has been changed to CalcArray in the $.wijmo.wijspread.Calc namespace.
• The Error class has been changed to CalcError in the $.wijmo.wijspread.Calc namespace.
• The ParserContext constructor has been changed.
• A parameter has been added to the toJSON method in the Spread and Sheet classes.
• The type field has been changed to typeName.

Enhancements from the Previous Release

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

• Widget Features
  • The exportFileType option has been added to the Excel Import and Export Service.
  • The INDIRECT formula function is now supported.
  • The AsyncFunction and AsyncEvaluateContext classes have been added.
• Cell Features
  • Watermarks are now supported.
• New Methods
  • The filterButtonVisible method has been added.
  • The getTypeFromString method has been added.
  • Additional methods have been added to the RowFilterBase class.
  • Additional actions have been added to the SpreadActions class.
  • The hideSelection and focus methods have been added to the Spread class.

Resolved Issues

The following issues have been resolved since the last release.

• The designer now works correctly. [111509]
• Filling a series with drag fill now works correctly after resetting Spread. [111254]
• Formulas now work correctly with cross-sheet references. [110778]
• The addRows method now works correctly when calculations have been suspended. [110265]
• Scrolling now works correctly with frozen rows. [110263]
• The formula box now works correctly with the SUM and OFFSET formulas. [109187]
• The VARISPARKLINE formula now works correctly. [107901]
• Serializing to a JSON object now works correctly when Spread is bound to a server side object. [107388]
• The sheet order is now correct when saving to a JSON object. [106887]
• The autoSize method now works correctly with cell comments. [106483]
• The RangeChanged event now shows the correct argument values. [106163]
• The autoFitRow Method now works correctly. [106142]
• The SUBTOTAL formula now updates correctly when filtering a cell range. [101523]
• Array formulas now work correctly. [94121]
• The file name is now exported correctly. [93020]
• The cell vertical alignment now works correctly. [91731]