Release Notes for Version 8.0.0

Breaking Changes

• Changed the 'net461' .NET Framework target to 'net462.'

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.