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]