Enhancements from the Previous Release

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

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

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]