Released: May 5, 2026

Updates in v9.1.0

Features

• Added the IPivotTable.setDisplayFieldCaptions method 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 enhanced support for digital signatures.
• Added support for NULL and empty values in template filters.
• Added support for the REGEX keyword in...

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: Dec 10, 2025

Updates in 8.2.5

Fixes

• Calling waitForCalculationToFinish can block for a long time during Workbook calculation.
• Workbook.Open can take an excessively long time to complete.
• Enabling CanShrinkToFitWrappedText when exporting to PDF can cause the save operation to fail.
• Formulas that combine LET, TAKE, BYROW, and LAMBDA can evaluate to #VALUE!.
• Formula evaluation under Japanese culture can produce incorrect values compared to Excel.
• A PivotTable created from a Data Model with no Rows or Columns selected can...

Released: Nov 12, 2025

Updates in 8.2.4

Fixes

• Destination Cells lose Data Validation when rows are copied.
• Embedded images in Picture-In-Cell disappear after Excel I/O.
• Exported Workbooks containing a Chart with a Secondary Axis cause an error when opened in Excel.
• HasArray and CurrentArray do not recognize Dynamic Array Formulas.
• Only the first Cell expanded from a JSONTable participates in calculation.
• Certain saved XLSM files are reported as corrupted by Excel.
• Formulas produced during Template expansion can be incorrect.
• IMSUM 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.
• Formula evaluation may produce incorrect numeric results under a German locale.
• Exporting a Range with quoted conditional formatting values causes an...

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 4, 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.
• After setting multiple SubtotalTypeNone options in a pivot table...

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.