[{"id":"dc3147d7-d3fb-4bc1-b1b3-142c0633e6d3","tags":[{"name":"New","color":"Red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99","links":null,"id":"c3c0ef13-c7a9-4649-9fcb-23b3abec175d"}]},{"id":"ca5ca1be-6d75-4ad1-880e-1589e3d52695","tags":[{"name":"New","color":"Red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99","links":null,"id":"c3c0ef13-c7a9-4649-9fcb-23b3abec175d"}]},{"id":"ea870089-5ea1-499a-bb0c-29cf378ead8d","tags":[{"name":"New","color":"Red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99","links":null,"id":"c3c0ef13-c7a9-4649-9fcb-23b3abec175d"}]},{"id":"d304d34f-f329-4f3b-b45e-2acb478427f8","tags":[{"name":"New","color":"Red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99","links":null,"id":"c3c0ef13-c7a9-4649-9fcb-23b3abec175d"}]},{"id":"3a79d24d-b853-4a51-a1e4-361feab06c57","tags":[{"name":"Upd","color":"Blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99","links":null,"id":"2f377cfe-f512-431a-895b-f89af32041ce"}]},{"id":"5d31b3db-69bb-4388-9a57-450a63e44456","tags":[{"name":"Upd","color":"Blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99","links":null,"id":"2f377cfe-f512-431a-895b-f89af32041ce"}]},{"id":"95e6d892-7bcd-4f6a-a152-504dec37c741","tags":[{"name":"New","color":"Red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99","links":null,"id":"c3c0ef13-c7a9-4649-9fcb-23b3abec175d"}]},{"id":"ec137f4b-3069-487f-bb0c-69f40fe6805d","tags":[{"name":"New","color":"Red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99","links":null,"id":"c3c0ef13-c7a9-4649-9fcb-23b3abec175d"}]},{"id":"9a2b2f20-5f3d-43a4-90d0-6f517fd3eebc","tags":[{"name":"Upd","color":"Blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99","links":null,"id":"2f377cfe-f512-431a-895b-f89af32041ce"}]},{"id":"8d43dc09-ddd1-4c42-8b02-90765c4c705b","tags":[{"name":"New","color":"Red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99","links":null,"id":"c3c0ef13-c7a9-4649-9fcb-23b3abec175d"}]},{"id":"a0c3d1e1-4a95-4eaf-808e-93242f2f9aee","tags":[{"name":"Upd","color":"Blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99","links":null,"id":"2f377cfe-f512-431a-895b-f89af32041ce"}]},{"id":"bd44c5b0-cd6b-443c-95dc-b8d8054fe1d7","tags":[{"name":"New","color":"Red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99","links":null,"id":"c3c0ef13-c7a9-4649-9fcb-23b3abec175d"}]},{"id":"fd5ccaa1-50b7-4c33-9ec5-c1eb48317119","tags":[{"name":"Upd","color":"Blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99","links":null,"id":"2f377cfe-f512-431a-895b-f89af32041ce"}]},{"id":"ea61139a-0ecf-45ba-83c3-c2f8b20a4126","tags":[{"name":"New","color":"Red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99","links":null,"id":"c3c0ef13-c7a9-4649-9fcb-23b3abec175d"}]},{"id":"ca986d5e-dfda-46e9-84f3-f44e4248ab94","tags":[{"name":"Upd","color":"Blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99","links":null,"id":"2f377cfe-f512-431a-895b-f89af32041ce"}]}]
        
(Showing Draft Content)

Release Notes for Version 9.40.20153.0

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]