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

Enhancements from the Previous Release

The following features and enhancements have been incorporated in this version of the product.

  • SpreadJS introduces the TableSheet, a fast data-bound table view with grid-like behavior with a spreadsheet user interface.

  • SpreadJS has added support for color index in cell formatting.

  • Users can now align content horizontally using the "Center Across Selection" option.

  • SpreadJS has updated charts to support Data Point Customization.

  • Users can now start formula by plus (+) sign like in MS Excel.

  • SpreadJS has been updated to give a clear prompt when modifying duplicate sheet names.

  • The InvalidOperation event has been updated to include dragFill invalid type.

  • SpreadJS date-type outline hierarchy has been updated in the Filter Dialog Box.

  • SpreadJS has included new ClipboardPasted and ClipboardPasting Event Arguments called fromRanges, fromSheet, isCuttng.

  • Pivot Tables now supports adding Calculated Items in rows and columns.

  • Filter Dialog search box has been added in Pivot Table to improve sorting and filtering options.

  • Slicer support has been added in Pivot tables to enable manual filtering of the data.

  • GETPIVOTDATA formula function now supports Spill.

  • SpreadJS Print settings now support Different Header & Footer in the odd/even/first page.

  • SpreadJS supports LAMBDA function which helps to create and name custom reusable functions that can be called like any other function.

  • SpreadJS supports seven new LAMBDA helper functions which help creating re-usable LAMBDA functions by having LAMBDA function as a parameter.

  • Users can now scroll context menus with indicators that appear if the menu is not fully displayed in the window.

  • Support of ASC function has been added.

  • Support of DBCS function has been added.

  • Support of JIS function has been added.

  • SpreadJS Designer now shows the font name with OS culture in font list.

  • SpreadJS Designer now provides a print menu that lets you preview and print all or part of a worksheet or workbook.

  • The Ctrl+F shortcut key now triggers the Find and Replace dialog window in SpreadJS Designer.

  • Remove Duplicates feature has been added in SpreadJS Designer which enables the user to add efficiency and remove redundancy.

  • Text To Columns feature has been added in SpreadJS Designer which is used to convert simple text or sentences having multiple words into separate columns..

  • SpreadJS Pivot Table now supports importing or exporting a spreadsheet to JSON without style.

  • Users can now show or hide column and row headers in the Pivot Table.

  • Pivot Table is updated to support Number Format for Row and Column Fields.

  • Date parsing has enhanced data performance loading from JSON or CSV.

  • Users can now use date type filters in Pivot Tables which can be used to specify a criteria that is applied to date type items.

  • SpreadJS now supports setting apply flag in named styles.

  • Support for Windows 11 and Windows Server 2022 has been added.

  • Upgraded the PDFkit for fixing the security issues.

  • Upgraded filesaver.js for process irregularities with UglifyJS.

  • SpreadJS now allows you to configure styles according to the state of the rows and columns.

  • Users can now change the tab strip position through sheet context menu in SpreadJS Designer.

  • SpreadJS has been updated to support Angular 13 along with Angular 11 and 12.

  • The ribbon UX has been updated in SpreadJS Designer

  • New filter options have been added in the SpreadJS Designer Name Manager Dialog.

  • SpreadJS Designer has added serialization option in the File Export menu.

  • The Workflow List UX in Cell DropDowns has been enhanced.

Resolved Issues

The following issues have been resolved since the last release.

  • PivotTable has been updated to position the filter panel correctly.

  • DataValidator has been updated to import properly from the Excel files.

  • Various chart-related issues have been fixed for SpreadJS Designer.

  • Pivot Table field labels import properly now.

  • The RangeChanged Event has been updated to fire if the Cell Dependents is changed using the Undo operation.

  • After Excel import, the height and width of the sheet are updated to change.

  • Fixed SpreadJS ExcelIO operation where redundant borders are applied.

  • The pie chart color has been updated to have solid fills.

  • The INDIRECT formula function works correctly with spilled array reference.

  • The designer template function works correctly in SpreadJS Designer.

  • SpreadJS now imports excel cell text-overflow.

  • The data binding button position has been updated.

  • The formula edit box is retained when cross sheet reference is added in SpreadJS Designer.

  • Columns have been updated to display fully after the column outline is expanded.

  • Column width has been updated when importing SSJON exported from GcExcel.

  • SpreadJS Designer now updates the selection of multiple sheets and dragging.

  • SpreadJS exports Excel files with formula correctly.

  • After adding a formula, the designer formula bar has been updated to display the formula.

  • Compatibility with the conditional format has been improved.

  • SpreadJS imports Excel files with charts correctly.

  • The fromJson method imports the background image correctly.

  • Right-click paste item is now compatible with Excel.

  • The TYPE formula function works correctly.

  • Cell back color has been updated to change its color when exported

  • The formula display works correctly after importing the excel file.

  • Tables are added correctly without any rows error.

  • The chart has been updated to resize its position when frozen panes are enabled.

  • Table cell types are updated correctly when columns are inserted.

  • Files with comments are imported correctly.

  • The Data Validation dialog in SpreadJS Designer now opens correctly.

  • SpreadJS has been updated to have cell #VALUE like excel.

  • The name box list has been updated to have a fixed length box and enables the scrollbar correctly.

  • Shape zoom factor is handled correctly.

  • Table header selection has been updated to extend even if sheet protection is not enabled.

  • Objects with resizing options work correctly when charts are selected.

  • Inserting a copied cell in an imported JSON file works correctly.

  • Cell formats handle fraction values correctly

  • External content is copied correctly after the chart is moved.

  • SpreadJS dropdown is retained when importing an excel file.

  • The formula has been updated to calculate after the cell is modified.

  • An error is handled while executing the toJSON method.

  • The pasteSkipInvisibleRange property has been updated to reflect the pasting effects.