Released: May 5, 2026

Updates in v9.1.0

Features

• Added the IPivotTable.DisplayFieldCaptions property to allow showing or hiding field headers in pivot tables.
• Added support for exporting shape text with bullets to PDF, Image and HTML.
• Added support for exporting waterfall charts to PDF, Image and HTML.
• Added the ICellControl.SetCheckbox method to support Microsoft Excel cell checkboxes.
• Added support for NULL and empty values in template filters.
• Added support for the REGEX keyword in template filters.
• Added support for date and time...

Released: Jan 6, 2026

Updates in v9.0.0

Features

• Support Lossless of Query Table.
• Added support for new Excel functions VALUETOTEXT and ARRAYTOTEXT.
• Support controlling SharedFormula export in XLSX export.
• Support AI functions.
• Support SJS/SSJSON IO of Threaded comments.
• Performance optimization.

Fixes

• Copying a Worksheet with many formulas is very slow.
• Opening and profiling a Workbook is noticeably slower.
• Saving a Workbook to PDF can trigger a console error.
• Formatting and AutoFit on very large reports causes severe slowdowns and...

Released: Oct 15, 2025

Updates in 8.2.3

Fixes

• Conditional formatting in the sjs extLst node is not parsed, causing differences in cell text rendering compared to SpreadJS.
• Inserted shapes may be misaligned due to oversized anchor offsets exceeding column/row boundaries.
• Enabling WrapText increases row height unexpectedly from the second row when customHeight is true.
• Exporting a Range with quoted conditional formatting values causes an InvalidFormulaException during Image or PDF export.
• Shape hyperlinks are lost when exporting and...

Released: Sep 25, 2025

Updates in 8.2.2

Fixes

• File Upload cell values are lost during copy/paste or export, causing missing file names.
• Setting a data source can overwrite cell content and remove formulas.
• First update of BackgroundPicture width may be ignored after changing FontSize.
• Freeze Pane position shifts when file contains collapsed groups.
• Workbook.Calculate() may return errors if the calculation engine starts Off.
• Full-width "&" in Worksheet names change to half-width "&" in formulas after save/load.
• Upgrading can...

Released: Sep 5, 2025

Updates in 8.2.1

Fixes

• Chart axis label spacing is ignored when exporting to image, showing dense labels instead.
• Localized color tokens (e.g. [Red] in Chinese) cause number format errors or inconsistencies.
• Extra blank comment may appear in exported XLSX files (visible in WPS).
• Percentage format is lost after cell expansion.
• Setting a cell value can throw System.ArgumentException.
• Opening large .ssjson files with many styles is very slow.
• Some dynamic array formulas return incorrect results on first calculation...

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

Released: Jul 26, 2025

Updates in 8.1.5

Fixes

• When a specific file is loaded and borders are added to cells, the used range becomes incorrect.
• A workbook calculation exception occurs when a formula contains an external workbook reference.
• Unexpected file size increases when applying NumberFormat and HorizontalAlignment to entire rows or columns.
• The LET function returns a #REF! error.
• The chart does not meet expectations after data expansion.
• Issue with the HOUR formula.
• An InvalidFormulaException occurs when a LAMBDA parameter is...

Released: Jul 3, 2025

Updates in 8.1.4

Fixes

• After ignoring formulas, the calculation results of LAMBDA formulas are not exported properly.
• A NullPointerException is thrown when saving a Workbook to SJS, HTML, or PDF formats.
• After setting FitToPagesWide, the exported PDF file still has two pages.
• The calculated result is incorrect when ROW function is used in defined name.

Released: Jun 13, 2025

Updates in 8.1.3

Fixes

• An exception is thrown when calling the Manager.Paginate method.
• Grouping a range results in an incorrect outline.
• The result of setting the option to insert entire rows and columns is not as expected.
• An exception is thrown when exporting a PDF file that contains a specific chart.
• Fetching IconType throws an ArrayIndexOutOfBoundsException when the icon is IconType.NoCellIcon.
• Formula cells are not evaluated after calling Workbook.Calculate() method.
• Pivot table totals to an incorrect...

Released: May 23, 2025

Updates in 8.1.2

Fixes

• The ApplyFilter method does not take effect.
• Exception occurs in Workbook.ProcessTemplate().
• The PivotTable data source is not updated after the sheet name is changed.
• An error is thrown when saving an SJS file.
• The program throws an exception when opening an SSJSON file.
• Issues with SUMIF calculation when exporting Excel to PDF.
• The value of RowCount is not expected.
• The exported PDF file does not display consistently with SpreadJS.
• Prompt for illegal parameters when importing an SSJSON...