Release Notes for Version 7.1.0

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.