# Release Notes for Version 9.1.0

## Content

## Enhancements from the Previous Release

* Added the [IPivotTable.DisplayFieldCaptions](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IPivotTable.DisplayFieldCaptions.html#GrapeCity_Documents_Excel_IPivotTable_DisplayFieldCaptions_) property to [allow showing or hiding field headers](/document-solutions/dot-net-excel-api/docs/online/Features/UsePivotTable/PivotTableSettings/pivot-table-layout#show/hide-pivot-table-field-headers) in pivot tables.
* Added support for [exporting shape text with bullets](/document-solutions/dot-net-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/dot-net-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/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.ICellControl.SetCheckbox.html#GrapeCity_Documents_Excel_ICellControl_SetCheckbox_) method to support Microsoft Excel [cell checkboxes](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/cell-checkboxes).
* Added support for [NULL and empty values in template filters](/document-solutions/dot-net-excel-api/docs/online/templates/template-configuration/template-properties/filter#filter-null-values).
* Added support for the [REGEX keyword in template filters](/document-solutions/dot-net-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/dot-net-excel-api/docs/online/templates/template-configuration/template-properties/filter#filter-date-and-time-values).
* Added the [IRange.CellPicture](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IRange.CellPicture.html) property to [allow inserting pictures in cells](/document-solutions/dot-net-excel-api/docs/online/Features/ManageWorksheet/RangeOperations/picture-in-cell).
* Added support for [expandable cell types and drop-down fields](/document-solutions/dot-net-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.
* Added the [PrintOutOptions.PaperSourceName](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.PrintOutOptions.PaperSourceName.html#GrapeCity_Documents_Excel_PrintOutOptions_PaperSourceName_) property to [support printer tray and paper source selection](/document-solutions/dot-net-excel-api/docs/online/Features/print#print-options) 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.