# Release Notes for Version 8.2.0

## Content

## 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.