[{"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 16.0.0

Enhancements from the Previous Release

The following features and enhancements have been incorporated into this version of the product:

Resolved Issues

The following issues have been resolved since the last release:

  • SpreadJS has resolved the screen freeze issue while turning over the column.

  • SpreadJS has resolved the performance issue where the Excel import got slower than v13.

  • SpreadJS has resolved the issue where the table slicer was not imported properly.

  • SpreadJS has resolved the issue where the layout of designer component was not correct when referencing the bootstrap.

  • SpreadJS has resolved the issue where the CellChanged Event was fired when pasting a range below the table.

  • SpreadJS has resolved the issue where the EnableDataValueEditing flag was not working correctly.

  • SpreadJS has resolved the issue where the added comments were displayed incorrectly.

  • SpreadJS has resolved the issue where editing the row and column subtotals and grandtotals did not work correctly.

  • SpreadJS has resolved the issue where setting the font style of subtotal rows and columns in PivotTable did not take effect

  • SpreadJS has resolved the issue where an error occurred after setting rich text In the Google browser of the Mac computer.

  • SpreadJS has resolved the issue where exporting XLSX file from SpreadJS showed a warning message while applying the custom culture.

  • SpreadJS has resolved the issue where Excel file was getting corrupted while export.

  • SpreadJS has resolved the issue where SUM(OFFSET(...)) showed #REF! when importing in SpreadJS.

  • SpreadJS has resolved the issue where the table column background issue occurred when resizing a column.

  • SpreadJS has resolved the issue where the sum calculation of the status bar was invalid.

  • SpreadJS has resolved the issue where textOrientation could not be cleared.

  • SpreadJS has resolved the issue where sorting the table through the sort dialog did not work.

  • SpreadJS has resolved the issue where an incorrect value was shown in the cell for Custom Format 0.00E+0.

  • SpreadJS has resolved the issue where the PDF file could not be exported correctly from SpreadJS.

  • SpreadJS has resolved the issue where setting the cell format to scientific notation with three decimal places in the Designer Component failed.

  • SpreadJS has resolved the issue where there was chart overflow when the frozen row count exceeded the viewport row count.

  • SpreadJS has resolved the issue where dragging the list items in Designer did not change the order of items.

  • SpreadJS has resolved the issue where setting style using PivotTablechanged event did not update the pivot table correctly.

  • SpreadJS has resolved the issue where an incorrect shape name would return undefined, but a blank name would return an empty string.

  • SpreadJS has resolved the issue where an exception was thrown during toJSON.

  • SpreadJS has resolved the issue where combo item style was lost after deleting the value.

  • SpreadJS has resolved the issue where the value function was working when the culture had a different decimal separator.

  • SpreadJS has resolved the issue where the picture does not display when printing.

  • SpreadJS has resolved the issue where the hyperlink was not working when uploading any file.

  • SpreadJS has resolved the issue where the CommentRemoving event did not occur on executing "Ctrl + Z".

  • SpreadJS has resolved the issue where the chart was not getting refreshed as values in the range were getting updated.

  • SpreadJS has resolved the issue while loading the SSJSON file containing AsyncFunction with option doNotRecalculateAfterLoad.

  • SpreadJS has resolved the issue where calcOnDemand caused the pasted formula to be invalid.

  • SpreadJS has resolved the issue where changing the conditional format was invalid.

  • SpreadJS has resolved the issue where the grid line was lost when freezing the column.

  • SpreadJS has resolved the issue where the Query Function result was not updated on changing the Tablesheet.

  • SpreadJS has resolved the issue where IRibbonPanel had no overflowTitle property.

  • SpreadJS has resolved the issue where a discrepancy occurred with Excel for conditional formatting and "no color" background.

  • SpreadJS has resolved the issue where the exported Excel file threw an error.

  • SpreadJS has resolved the issue where the loading time of fromJSON exceeded the limit.

  • SpreadJS has resolved the SJS Function Analysis Error.

  • SpreadJS has resolved the issue where the user could not set the missingCaption number in the Designer.

  • SpreadJS has resolved the browser hang issue when a spreadsheet was loaded.

  • SpreadJS has resolved the issue where the UI changed when using the Designer Component with Bootstrap 3.4.1 CSS settings.

  • [Designer] SpreadJS has resolved the issue where the shape list was incorrectly displayed while adjusting the browser size.

  • SpreadJS has resolved the issue where both valuesAndFormatting and ormulasAndFormatting did not contain the conditional formatting.

  • SpreadJS has resolved the issue where the calculation behavior of V15 was different from that of V14.

  • SpreadJS has resolved the issue where the hidden row caused frozen layout.

  • SpreadJS has resolved the issue of Table Formula Calculation with auto-expand table.

  • SpreadJS has resolved the issue where the user could not export the PDF file with italic font.

  • SpreadJS has resolved the issue where the pie chart could not switch colors according to the selected series.

  • SpreadJS has resolved the issue where an incorrect formatter was displayed in the Designer Dropdown when the Currency formatter was selected from the dropdown.