# Release Notes for Version 9.1.0

## Content

## Enhancements from the Previous Release

* Added the [IPivotTable.setDisplayFieldCaptions](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/IPivotTable.html#setdisplayfieldcaptions) method to [allow showing or hiding field headers](/document-solutions/java-excel-api/docs/online/Features/UsePivotTable/PivotTableSettings/pivot-table-layout-and-format#show/hide-pivot-table-field-headers) in pivot tables.
* Added support for [exporting shape text with bullets](/document-solutions/java-excel-api/docs/online/ManageFileOperations/ExporttoaPDFFile/ExportShapes#export-shape-text-with-bullets) to <span data-teams="true">PDF, Image and HTML</span>.
* Added support for [exporting waterfall charts](/document-solutions/java-excel-api/docs/online/ManageFileOperations/ExporttoaPDFFile/export_charts_to_pdf#waterfall-chart) to <span data-teams="true">PDF, Image and HTML</span>.
* Added the [ICellControl.setCheckbox](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/ICellControl.html#setcheckbox) method to support Microsoft Excel [cell checkboxes](/document-solutions/java-excel-api/docs/online/Features/ManageWorksheet/cell-checkboxes).
* Added enhanced support for digital signatures.
* Added support for [NULL and empty values in template filters](/document-solutions/java-excel-api/docs/online/templates/template_configuration/template_properties/filter#filter-null-values).
* Added support for the [REGEX keyword in template filters](/document-solutions/java-excel-api/docs/online/templates/template_configuration/template_properties/filter#filter-values-with-regex).
* Added support for [date and time values in template filters](/document-solutions/java-excel-api/docs/online/templates/template_configuration/template_properties/filter#filter-date-and-time-values).
* Added the [IRange.setCellPicture](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/IRange.html#setcellpicture) method to [allow inserting pictures in cells](/document-solutions/java-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/picture-in-cell).
* Added support for [expandable cell types and drop-down fields](/document-solutions/java-excel-api/docs/online/templates/template_configuration/global-settings#spreadjsstyleexpandable) 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.