Release Notes for Version 9.1.0

Enhancements from the Previous Release

• Added the IPivotTable.setDisplayFieldCaptions method to allow showing or hiding field headers in pivot tables.

• Added support for exporting shape text with bullets to PDF, Image and HTML.

• Added support for exporting waterfall charts to PDF, Image and HTML.

• Added the ICellControl.setCheckbox method to support Microsoft Excel cell checkboxes.

• Added enhanced support for digital signatures.

• Added support for NULL and empty values in template filters.

• Added support for the REGEX keyword in template filters.

• Added support for date and time values in template filters.

• Added the IRange.setCellPicture method to allow inserting pictures in cells.

• Added support for expandable cell types and drop-down fields in template cells.

• Added support for pivot table styles.

• Added support for lossless import and export of the SJS and SSJSON file formats in SpreadJS v19.1.

Resolved Issues

• Fixed the issue of signed Excel files becoming invalid when saved with a PFX certificate.

• Fixed the issue of security vulnerabilities and bundled third-party dependencies.

• Fixed the issue of images from template data sources appearing in the wrong order.

• Fixed the issue of pivot table styles being lost after refresh.

• Fixed the issue of pivot table cell alignment being lost after sorting.

• Fixed the issue of unexpected memory growth during concurrent report generation.

• Fixed the issue of recalculating a workbook after input updates producing inconsistent results.

• Fixed the issue where certain SJS files failed to open due to a FormatException triggered by NaN values.

• Fixed the issue where the implicit intersection operator (@) was unexpectedly inserted into FORECAST.LINEAR formulas after opening and saving a workbook.