Enhancements from the Previous Release

• Enhanced template language with better performance.
• Added support for ignoring errors in a range.
• Added support for interrupting the execution of ProcessTemplate method.
• Added support for template language to support OverwriteWithFormat under Classic Mode.
• Added support for lossless .sjs and ssjson I/O of GanttSheet.
• Added support for CalculationMode options.
• Added support for searching cells with tags.
• Added support for multi-column sorting in the template language.
• Added support for custom sort orders in the template language.
• Added support to get and set cell background images.
• Added support for table references in cross-workbook formulas.
• Added support for exporting barcodes as pictures in Excel files.
• Added support for lossless .sjs and ssjson I/O of ReportSheet.

Resolved Issues

• Fixed the exception thrown on calling ProcessTemplate method when data source is not found.
• Fixed the issue of an incorrectly grouped result after calling ProcessTemplate method when using JSON data source.
• Fixed the issue of the incorrect result of SUMIFS formula after processing template file.
• Fixed the exception thrown on calling ProcessTemplate method when data field is numeric.
• Fixed the issue of an incorrect result in the resultant workbook after processing template file.
• Fixed the issue of the incorrect result of SUM formula after processing template file.
• Fixed the issue of an incorrect merge area after processing template file.
• Fixed the issue of the incorrect result of DIV formula after processing template file.
• Fixed the issue of the cell background color not being expanded as expected in the exported report workbook.
• Fixed the issue of incorrect results for the MIN and MAX formulas after processing template file.
• Fixed the issue of an incorrect calculated result in the exported report workbook after processing template file.
• Fixed the issue of the changed formula in the exported report workbook after processing template file.
• Fixed the exception thrown on calling ProcessTemplate method.
• Fixed a performance issue on processing template when setting G=R.
• Fixed the issue of the changed applied range of conditional format in the exported workbook.
• Fixed the issue of incorrect chart in the exported PDF file.
• Fixed the working of ISort.Apply() method.
• Fixed the performance issue on processing template containing merged cells.
• Fixed the issue of a lost border in the exported XLSX file.
• Fixed the issue of a lost image in the exported XLSX file when PaginationMode is true.
• Fixed the issue of a lost row or column header caption in Pivot table in the exported XLSX file.
• Fixed the exception thrown on loading a particular ssjson file.
• Fixed the exception thrown on loading a particular SJS file.
• Fixed the issue of the incorrect result of the DATEVALUE formula.
• Fixed the performance issue on processing templates when there are too many sheets.
• Fixed the issue of incorrect expansion of table formula when calling ProcessTemplate method.
• Fixed the exception thrown on loading worksheets from JSON when the JSON contains non-existent external references.