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

Enhancements from the Previous Release

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

  • Cascade Sparkline Total Column - Users can now use the total column indicator in the cascade sparkline.

  • Support for exporting to HTML - Users can export range or an entire worksheet to html. You can export any particular range of cells in the HTML format.

  • SpreadJS Accessibility Support - Users can now get basic accessibility support so that SpreadJS becomes compatible with ADA compliance and screen readers.

  • Iterative calculation - SpreadJS provides support for iterative calculation when the formula in a cell refers to its own cell in spreadsheets to recalculate the formula until a definite result is found.

  • Support changing color for comment icon - Users can now customize cell comments indicator color and size.

  • Horizontal axis cross value - SpreadJS allows users to adjust chart axis crosses, so that users can move the x-axis or y-axis to the point axis value or minimum/maximum axis value.

  • User can now enable or disable ribbon menu according to different protect options when the worksheet is protected.

  • Support Access range - Users can conveniently choose which way to obtain range information in the sheet area according to their needs, either using row and column information or range/cell address string.

  • Support Header Formulas and Sparklines - Users can add formula and SparklineEx to both the row header area and column header area of the spreadsheet.

  • Intervals of Bars of Bar Chart - Users can customize the appearance of bar and column charts by adjusting the series gap width and their overlapping.

  • Support Excel Fill Effects and Pattern - Users can customize chart elements by applying pattern-fill effects.

  • SpreadJS Angular library now supports AOT and Prod compiler.

  • Support copy pasting floating images - Users can copy and paste images from Excel to SpreadJS worksheets.

  • Support customizing doughnut charts hole size - User can customize doughnut hole size for doughnut charts.

  • SpreadJS now supports the XLOOKUP and XMATCH functions.

  • Users can now store and define values within a formula using the LET function.

  • The scroll bar by pixel behavior is now more accurate.

  • Support selection for auto-merge feature - Customers can use auto-merge with the selection feature of addSpan.

  • Clipboard events for floating object - Users can now use clipboard events for copy-paste operation of floating objects such as pictures, charts, shapes, slicers, and custom floating objects.

  • Multiple-Column Dropdown - Users can provide a drop-down list as well as an editable area using multiple column dropdown cell.

  • Table binding support - Users can choose how to expand the rows in the table-binding case.

  • Set a switch that does not display ### - Users can set a switch so that cells do not get masked with '####', scientific notation, rounded-up decimals, etc. when the column width is not enough.

  • Incremental Loading Support - SpreadJS now supports incremental loading to enable high-performance data processing in worksheets.

  • Custom Array Formula - Users can return the array in the custom functions.

  • SpreadJS supports OBJECT and RANGEBLOCK functions - Users can set the rangetemplate celltype and bind the object using this functions.

  • Designer support for RangeTemplate cell type - Users can create a range template cell type through the designer.

  • SpreadJS Support Funnel Chart - Users can add a new chart type called the Funnel Chart.

  • SpreadJS supports PROPERTY function, so that users can specify the property path to return the value of object.

Resolved Issues

The following issues have been resolved since the last release.

  • The Convert function does not support m/s.

  • gc.spread.sheets.angular.ts typescript file is shipped with spread-sheets-angular npm package.

  • SpreadJS does not work with Angular 9.

  • The shortcut Ctrl + Z can change the active sheet.

  • The formula =sss('') does not fire InvalidOperation.

  • Vertical scrollbar can not reach bottom when enabling both scrollbarMaxAlign and scrollByPixel.

  • Auto scroll behavior is affected when dragging scrollbar.

  • The range of filter is not updated correctly while inserting copied column.

  • The formula in the validator does not work after changing formula reference from A1 to RC.

  • There is an error in exporting Excel.

  • The form with auto merge cells is not smooth when the mouse is scrolling in Internet Explorer 11 and edge browsers.

  • There are accuracy issues with the y-axis scale of the chart.

  • The introduction of style files affects custom cell styles

  • The selected state changes when adding rows.

  • The loading, calculation and updating for spreadsheet that uses RAND and RANDBETWEEN is very slow.

  • The Image distorts during printing.

  • The viewport scroll is slower than scrollbar.

  • When the sort option is clicked, the page is stuck while using "npm install" demo.

  • DataValidation feature does not work for added rows at 0 index in the table.

  • The hyper link color appears as gray in SpreadJS worksheet.

  • The Text display is incomplete in the edit box of Android phones.

  • The scroll feature does not work with frozen rows.

  • The excelio.save method does not work correctly in the node environment

  • There is copy and paste Issue with Google Sheets while using SpreadJS.

  • The conditional formatting is not applied for value starting with '#' character.

  • The Chinese styling is lost when saving Excel.

  • The Designer_Source will cause the tag to shift, while modifying the title.

  • The Drop-down data is wrong after filtering the table.

  • The named Range is not getting updated after inserting the columns.

  • After un-hiding, the width of the hidden column is still zero.

  • The parameter in the parameter dialog of the SUMIFS function is wrong.

  • The Pie and Doughnut chart legends are shown differently than Excel when the Category Axis Labels range contains two or more rows.

  • The Designer Format Dialog Font Style is different from Excel.

  • The issue of text misalignment occurs when the text of a cell overflows, and the same cell is selected and clicked to merge it to the center.

  • The content pasted in the editing is different from the content copied in the editing, in the case of word wrap.

  • The imported .xlsx file, SJS and Excel are inconsistent with the display status of the range group button.

  • The row selected by the row header cannot be deleted in the online editor.

  • The conditional format references changes on changing the priority of the conditional rule.

  • The Cell A2 should not change until A1 change, while adding a Custom Function RAND1, setting calcOnDemand, inputting 1 in cell a1, inputting "=RAND1(A1)" in cell A2 and then inserting rows after A3.

  • The Auto-merge function is invalid in case of cell overflow.

  • The Excel export by SpreadJS gives an error.

  • The insertion of table rows and columns does not correctly update the cell styles after loading the table from the data source.

  • The hyperlink changes after being imported to SpreadJS.

  • The content imported into the online editor is inconsistent with Excel.

  • The data source can not be bound to the table after using suspendEvent.

  • The exported Excel has style error with outlines and strikethroughs in the sheet.

  • The column still does not show even after clicking the unhide option.

  • Setting the autoMerge feature leads to a stuck scrollbar.

  • In component designer, fromjson causes the page to crash.

  • The calculated col/row size is displayed in tooltip while zooming.

  • The Spreadsheet is displayed incorrectly when zooming by pinch operation.

  • The Font (style) is not exported to Excel properly.

  • The Chart Category does not show the leading zero.

  • The subtotal formula does not work.

  • The Component designer can not delete the row using the context menu.

  • The Component designer misses the schema of data-binding by exporting and importing.

  • The Export excel with data validation by component designer, the result is inconsistent with setting.

  • The named style does not work when the name has '&'.

  • The formula is invalid when the formula refers to the cell after dragging the scroller.

  • The formula does not adjust while deleting the sheet.

  • After setting the mobile scrollbar in the designer, the selection cannot be dragged to right.

  • The Text with underline is not copied from Excel to SpreadJS in FireFox.

  • The formula does not calculate after setting calcOnDemand to true.

  • Some portion of the imported excel file is missing.

  • The importing of file takes too much time.

  • The POWER function returns a different value than Excel.

  • The Component designer Chinese culture does not get completely translated.

  • The "=OR(VLOOKUP(K31,Sheet10!A:C,1,FALSE),FALSE)" is giving formula result different in Excel.

  • The expanding/collapsing event takes a lot of time to update the sheet.

  • While setting Sparkline options in Angular applications, there are errors in the console saying that the options do not exist on typing 'Object'.

  • The conditional Formatting breaks while inserting a new row.

  • When a cell has value like "a b  c" and when it is copied (ctrl + c) and pasted (ctrl + v) in the cell, then it is pasted as "a b c".

  • The deletion of sheet rows takes a long time.

  • The localization of string resources is allowed but the default sheet name is still in English, and cannot be localized.

  • There is repeated display of ribbon with designer component.

  • The slicer is displayed incorrectly after zooming.

  • There is formatting issue on pasting the data from GoogleSheets.