[]
        
(Showing Draft Content)

version 8.2.0

Enhancements from the Previous Release

  • Added support for new Excel functions: GROUPBY, PIVOTBY, and PERCENTOF. (DOCXLS-9486)

  • Added the Evaluate2 API to return spilled values from dynamic array formulas. (DOCXLS-11502)

  • Added the IShape.AlternativeText property to enable getting and setting Alternative Text for shapes. (DOCXLS-11891)

  • Added the IWorksheetView.FitSelection property to allow setting the chart sheet zoom to Fit to Selection. (DOCXLS-11930)

  • Added support for custom functions to accept error parameters. (DOCXLS-12010)

  • Added support for the new Excel formula TRIMRANGE. (DOCXLS-12136)

  • Added the ability to retrieve sheet count and names for GanttSheets from SJS files. (DOCXLS-12206)

  • Added new types to the ShapeType enum. (DOCXLS-12226)

  • Added performance improvements for template expansion when the data source is ITableDataSource and the ExpansionType is list mode. (DOCXLS-12230)

  • Added support for Eta-Reduced Lambda. (DOCXLS-12446)

Resolved Issues

  • Fixed the issue of slow export to Excel when files contain multiple VLOOKUP functions. (DOCXLS-10630)

  • Fixed the issue of font formatting changing unexpectedly after opening and saving files. (DOCXLS-11791)

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

  • Fixed the issue of slow report rendering when processing large datasets. (DOCXLS-11950)

  • Fixed the issue of significant performance differences between Template and setDataSource methods when rendering large lists. (DOCXLS-12216)

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

  • Fixed the issue of inconsistent font formatting when converting SJS files to XLSX, resulting in font changes. (DOCXLS-12504)

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

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

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

  • Fixed the issue of saving certain workbooks failing with System.ArgumentOutOfRangeException due to chart handling. (DOCXLS-12810)

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