Enhancements from the Previous Release

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

• 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.

• Widget Features

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]