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 GrapeCity 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 GcExcel template functionality.
• PDF form is not displayed when 'printed' and 'hidden' settings are false in form field.
• Rows do not repeat while using GcExcel 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.