Release Notes for Version 9.1.0

Enhancements from the Previous Release

• Added the IPivotTable.DisplayFieldCaptions property 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 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.CellPicture property 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.

• Added the PrintOutOptions.PaperSourceName property to support printer tray and paper source selection in PrintOut.

Resolved Issues

• 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 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.