# Release Notes for Version 4.0.0

Detailed release notes for DsExcel version 4.0.0

## Content



## Enhancements from the Previous Release

The following features have been added with this version of the product:

* Support for new PDF Form custom input types in Excel Templates with advanced input and validation settings.
* Support for adding, modifying and deleting Pivot Charts in Excel documents.
* Support for iterative calculations in Excel documents.
* Support for adding Barcodes while exporting to PDF, HTML or Image file formats.
* Support for cross-workbook formulas.
* Support setting default value for template cell.
* Support for getting range address to get cell's address.
* Add page printing events to track progress of Excel to PDF conversion.
* Support for selecting multiple worksheets.
* Support for getting special cells in a range.
* Disable auto grouping for date/times in PivotTable.
* Add more features for SpreadJS integration: cell buttons, radio and checkbox list cell type, etc.

## Resolved Issues

The following issues have been resolved since the last release.

* PivotTable MergeLabel's merged area is incorrect.
* PivotTable.DataBodyRange throws exception.
* Cannot open xlsx when the pivot source contains null values.
* Failed to export an Excel with pivot table.
* Program does not end and CPU utilisation is 100% while exporting to PDF.
* Broken Excel file is generated when copying a sheet.
* ArrayIndexOutOfBoundsException when generating JSON.
* When margins are set to the same value, the rendering position is not the same in PDF.
* Labels does not merge in exported xlsx file.
* SUM is calculated incorrectly when using DsExcel template functionality.
* PDF form is not displayed when 'printed' and 'hidden' settings are false in form field.
* Rows do not repeat while using DsExcel Template.
* Null exception is thrown during loading ssjson.
* Null exception is thrown when calling Workbook.Calculate.
* The text in exported image is wrong.
* The pivot table label does not merge in exported xlsx file.