Enhancements from the Previous Release

• Added import data from object collections and Data Tables.
• Added support for I/O of Pivot Table Timeline slicer.
• Added the ability to add and manage Scenarios in What-If analysis.
• Added support for Pattern Fill when rendering to PDF or Image.
• Added support for calculated page numbers in headers and footers.
• Added the ability to set color using various string formats: HEX, RGB, and color names.
• Added support for Image Sparkline formula.
• Added support for automatic cell merging.
• Added support for Cell Decoration styling.
• Added support for the option to include or exclude binding data.
• Added support for Excel Table as a data source for Pivot Tables.
• Added support for allowing editing in cell, Chart Color Scheme, and Date-Time Picker options in Lossless I/O for SpreadJS.
• Added new APIs to manage PivotTable.

Resolved Issues

• Fixed the issue of showing hidden data labels of the chart in the exported image file.
• Fixed the issue of lost Timeline Slicer in the exported PDF file.
• Fixed the issue of incorrect rowcount after calling IRange.Delete() method.
• Fixed the issue of lost data labels of the chart in the exported HTML file.
• Fixed the expansion issue of some style as expected after processing the template.
• Fixed the performance issue in template processing.
• Fixed the issue of incorrect fill color of data points in the chart in the exported Image file.
• Fixed the issue of the larger size of the exported SJS file than the source file.
• Fixed the issue of different layout of RadioButtonListCellType from SpreadJS.
• Fixed the expansion issue of some cells as expected after processing the template.
• Fixed the issue of incorrect result of IWorksheet.RowCount after setting it explicitly.
• Fixed the issue of exception thrown on processing particular template.
• Eliminated the security vulnerabilities by upgrading the versions of certain dependencies.