Released: Aug 18, 2025

Updates in 8.2.0

Features

• Added support for Excel-like worksheet background images with full compatibility for SpreadJS SJS/SSJSON file formats. Using the IWorksheet.BackgroundPicture interface, developers can retrieve background images when they are stored in Base64 format and export them to PDF with the PrintBackgroundPicture = true option.
• Added support for new Excel functions GROUPBY, PIVOTBY, and PERCENTOF.
• Introduced the Evaluate2 API to return spilled values from dynamic array formulas.
• Added the ability to get and set Alternative text for shapes.
• Enabled setting chart sheet zoom to "Fit to Selection".
• Custom functions can now accept error parameters.
• Added support for the new Excel formula TRIMRANGE.
• Enabled retrieval of sheet count and names for GanttSheets from SJS files.
• Expanded the ShapeType enum with new types.
• Improved the performance of template expansion when the data source is ITableDataSource and the ExpansionType is list mode.
• Added support for Eta-Reduced Lambda.

Fixes

• Exporting to Excel takes unusually long when files contain multiple VLOOKUP functions.
• Font formatting changes unexpectedly after opening and saving files.
• Memory usage is excessively high when processing large-scale data with Workbook.ProcessTemplate().
• Report rendering speed is slower than expected when processing large datasets.
• Performance differs significantly between Template and setDataSource methods when rendering large lists.
• Processing templates with a large number of rows takes longer than expected and may cause memory issues in multi-threaded scenarios.
• Font formatting is inconsistent when converting SJS files to XLSX, resulting in font changes.
• Executing the toImage function on Mac and Linux triggers console errors due to unsupported fonts or emoji rendering issues.
• Freeze pane location shifts after processing files containing collapsed groups, causing incorrect frozen areas.
• Sorting order for Japanese text in Pivot Tables does not follow locale-specific rules.
• Saving certain workbooks fails with System.ArgumentOutOfRangeException due to issues in chart handling.
• Table filter buttons appear inconsistently compared to older versions, indicating lost filter information in processed templates.