Enhancements from the Previous Release

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

• A slicer for filtering has been added.

• The fixedPosition method has been added.

• The protectionOption method has been added.

• The Excel Import and Export component has been added.

• Excel-style themes have been added.

• Printing options have been added.

• The scrollIgnoreHiddenRowOrColumn method has been added.

• The resizeZeroIndicator method has been added.

• The tabNavigationVisible method has been added.

• Widget Features

Changes from the Previous Release

• The Excel Import and Export Service has been replaced by the Excel Import and Export Component.

• SpreadJS no longer requires external dependencies.

This version of the product has the following changes.

Resolved Issues

The following issues have been resolved since the last release.

• Floating objects are now rendered correctly when setting the width for frozen columns. [137098]

• Cell spanning is applied correctly when the cell is in edit mode. [137037]

• The combo box cell now paints correctly. [136679]

• The allowCellOverflow method now works correctly when scrolling. [136560]

• The cell format is now applied correctly. [136370]

• Spaces are no longer removed incorrectly when the text contains a comma. [136251]

• Hidden rows in groups are no longer visible when importing an Excel-formatted file. [135934]

• The Photo calendar template in the SpreadJS designer has been updated. [135422]

• The PROPER function now works correctly. [135420]

• The undo or redo now works correctly when filling a range. [135279]

• Text entered between the "< >" tags is now displayed correctly in the formula bar. [135204]

• The context menu now works correctly when resizing the window. [135132]

• Pictures are now placed correctly when not in view. [134341]

• The JSON date format is now correct. [134210]

• The date format now works correctly. [133909]

• Saving to the ssjson format now works correctly. [133471]

• The correct editor is now created with the combo box cell when using the EnterCell event. [133405]

• Rounding is now applied correctly with a general format. [133025]

• New line characters are now truncated correctly. [132845]

• Scrolling now works correctly with MAC style scrolling. [132296]

• Scrolling and filtering now work correctly with MAC style scrolling. [132292]

• The addCustomName method now works correctly. [132151]

• Custom formats now work correctly. [131997]

• The combo box cell now works correctly with drag and fill. [131724]

• Scrolling now works correctly when selecting SpreadJS. [131665]

• Conditional formats are now applied correctly. [131326]

• Dependent cells are now updated correctly when changing custom names. [131166]

• The SpreadJS designer now works correctly with custom names. [130891]

• The Decrease Decimal option in the SpreadJS designer now works correctly. [130710]

• Finding formulas now woks correctly in the SpreadJS Designer. [130702]

• Custom formats now work correctly. [130662]

• The SUM formula now works correctly. [129660]

• The CONVERT formula now works correctly. [129624]

• Pasting with the Ctrl + V keys now works correctly. [129623]

• Borders now work correctly in the SpreadJS Designer. [129069]

• Date time formats now work correctly. [129056]

• The time format now works correctly. [129049]

• Fraction value formats now work correctly. [129047]

• Changing cell references in Name Manager now works correctly. [129044]

• Pasting to merged cells now works correctly. [128294]

• Copying and pasting more than 5000 rows has been enhanced. [128289]

• Selecting multiple rows, columns, or cells now works correctly. [128275]

• The value alignment is now correct when using combo boxes. [128273]

• The toJSON and fromJSON methods now work correctly. [127519]

• Formulas now work correctly if there is a circular reference. [127145]

• Adding rows now works correctly when using AngularJS. [127140]

• The SUMIFS formula now works correctly. [126999]

• Copy and paste now works correctly. [126184]

• Hexadecimal values now work correctly in SpreadJS. [126183]

• Cells are now highlighted correctly when the formula contains text parameters. [125912]

• The error message pop-up now works correctly with data validation. [125901]

• The hyperlink cell now works correctly if there are multiple tables on the page. [122533]

• Formulas are now displayed correctly in the formula box when there are custom list and array group separators. [122476]

• The getViewportRightColumn method returns the correct value when scrolling. [121565]

• The excelCompatibleFormatString method now works correctly. [121558]

• The evaluateFormula method now works correctly. [121546]

• Formulas are now handled correctly when deleting columns. [121541]

• Decreasing the number of decimal places now works correctly. [120735]

• Certain formulas are now handled correctly when exporting to JSON. [120359]

• Certain custom formats now work correctly. [120229]

• The FormulaListValidator now works correctly. [118625, 118675]

• The JSON schema now works correctly. [118184]

• Importing certain Excel-formatted files now works correctly. [117502]

• Copying and pasting data with quotes now works correctly. [117310]

• The includeBindingSource argument now works correctly. [117232]

• Automatic fill now works correctly if numbers have a large number of decimal places. [116740]

• The SpreadJS Designer now works correctly with a JSON file. [116146]

• Comments now display in the correct location. [115832]

• Certain Excel-formatted files now import correctly. [115590]

• Pasting text into a cell with a formula from an external source now works correctly. [115431]