[]
        
(Showing Draft Content)

Release Notes for Version 8.2.0

Enhancements from the Previous Release

  • Added support for new Excel functions: GROUPBY, PIVOTBY, and PERCENTOF.

  • Added the Evaluate2 API to return spilled values from dynamic array formulas.

  • Added the IShape.setAlternativeText method to enable setting Alternative Text for shapes.

  • Added the IWorksheetView.setFitSelection method to allow setting the chart sheet zoom to Fit to Selection.

  • Added support for custom functions to accept error parameters.

  • Added support for the new Excel formula TRIMRANGE.

  • Added the ability to retrieve sheet count and names for GanttSheets from SJS files.

  • Added new types to the ShapeType enum.

  • Added performance improvements for template expansion when the data source is ITableDataSource and the ExpansionType is list mode.

  • Added support for Eta-Reduced Lambda.

Resolved Issues

  • Fixed the issue of slow export to Excel when files contain multiple VLOOKUP functions.

  • Fixed the issue of font formatting changing unexpectedly after opening and saving files.

  • Fixed the issue of excessive memory usage when processing large-scale data with Workbook.ProcessTemplate().

  • Fixed the issue of slow report rendering when processing large datasets.

  • Fixed the issue of significant performance differences between Template and setDataSource methods when rendering large lists.

  • Fixed the issue of slow template processing and potential memory issues in multi-threaded scenarios when handling templates with a large number of rows.

  • Fixed the issue of inconsistent font formatting when converting SJS files to XLSX, resulting in font changes.

  • Fixed the issue of console errors on Mac and Linux when executing the toImage function due to unsupported fonts or emoji rendering.

  • Fixed the issue of freeze pane location shifting after processing files with collapsed groups, resulting in incorrect frozen areas.

  • Fixed the issue of incorrect sorting order for Japanese text in Pivot Tables not following locale-specific rules.

  • Fixed the issue of saving certain workbooks failing with System.ArgumentOutOfRangeException due to chart handling.

  • Fixed the issue of table filter buttons appearing inconsistently compared to previous versions, indicating lost filter information in processed templates.