Enhancements from the Previous Release

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

• Widget Features
  • Client side Excel import and export has been added.
  • Cell padding has been added for the watermark.
  • The formula text box control now has support for selecting multiple ranges.
  • Copy and paste has been improved.
  • The Month sparkline has been added.
  • The Year sparkline has been added.
  • The TableRemoveOptions enumeration has been added for the remove method.
  • The allowCopyPasteExcelStyle and allowExtendPasteRange properties have been added to the Workbook options.
  • The copyPasteHeaderOptions property has been added to the Workbook options.
  • Additional parameters have been added to the ClipboardChanging, ClipboardChanged, ClipboardPasting, and ClipboardPasted events.
  • The AsyncFunctionEvaluateMode class has been added.
  • The REFRESH formula function has been added.
  • A migration file has been added for backward compatibility.

Changes from the Previous Release

This version of the product has the following changes.

• Namespaces have been updated.
• The fromRange option has been changed to fromRanges in the clipboardPaste command.

Resolved Issues

The following issues have been resolved since the last release.

• The AVERAGE function now works correctly in an IF statement. [218673]
• Exporting SSJSON to XLS now works correctly. [218087]
• Certain formulas now work correctly in Internet Explorer and Chrome. [217400]
• Column headers now print correctly when the control is bound to a data source. [217399]
• Copying and pasting values with quotes now works correctly. [214594]
• The drag fill undo action now works correctly. [214351]
• Exporting to HTML now works correctly. [211587]
• Spread files are now saved correctly with Google Drive. [205891]
• Copying data with double quotes from Excel and selecting that data, now works correctly. [205594]
• Binding certain columns in a table now works correctly. [202895]
• Certain Excel-formatted files now import correctly. [202339]
• Scrolling now works correctly with filters. [201910]
• The autoFitRow method now works correctly. [201878]
• The EOMONTH formula now works correctly. [201507]
• Certain fonts are now displayed correctly in hyperlink cells. [201320]
• The add method now has additional options. [201072]
• The copyTo method now works correctly with button cells. [201071]
• Hidden values now work correctly when filtering. [201058]
• Deleting rows after filtering now works correctly. [200761]
• Expressions are now handled correctly after adding or deleting a row. [200714]
• Printing when the scrollbarMaxAlign option is true now works correctly. [199766]
• Using a large number of groups now works correctly. [198690]
• Certain formulas now work correctly in Chrome. [198496]
• Certain Excel-formatted files now import correctly. [198083]
• The autoFitColumn method now works correctly in Chrome. [197671]
• The SheetNameChanged event now works correctly in Firefox. [196959]
• Spread now works correctly with small column widths. [196954]
• Borders now work correctly. [194652]
• Data validation now works correctly when importing Excel-formatted files. [193937]
• Cross-sheet references now work correctly. [193936]
• Frozen rows and hidden rows now work correctly. [193121]
• Certain Excel-formatted files now import correctly. [192849]
• Setting a cell border after applying a default style now works correctly. [191933]
• Opening certain Excel-formatted files in the designer now works correctly. [191249]
• The typescript file now contains the correct information. [189898]
• The filter button now displays entries correctly. [189880]
• Editing sheet names now works correctly. [189150]
• Floating objects now load correctly. [189098]
• Sorting has been enhanced. [185372]
• The data validation drop-down now works correctly when hiding Spread. [153907], [152907]
• Custom functions now work correctly when loaded from a file. [153588]
• The removeTable method now has additional options. [153477]
• Certain formulas now import correctly. [153273]
• Certain calculations now work correctly. [152638], [152640]
• Using the undo action with multiple column headers now works correctly. [152580]
• The startSheetIndex method now works correctly. [152065]
• The mouse event now works correctly with multiple row headers. [152061]