Document Solutions for Excel .NET Releases
Released: Jul 2, 2026
Updates in v9.1.3
Fixes
- Fixed incorrect handling of Charts inside nested Shape groups when opening a Workbook.
- Fixed incorrect Sort results for in-cell Images when sorting a Range that contains Images without alternative text.
- Fixed failure to open valid XLSX Workbooks whose theme elements use a default namespace.
- Fixed incorrect black Worksheet tab color when clearing the tab color with an empty value.
- Fixed incorrect date formatting for non-English Workbook cultures in Cell text and PDF output.
- Fixed incorrect...
Released: Jun 25, 2026
Updates in v9.1.2
Fixes
- Fixed failure to open Workbook JSON when a Cell contains array information and a shared Formula reference.
- Fixed incorrect AVERAGEIF calculation results when the criteria range contains both numeric values and blank Cells and the sum range is omitted.
- Fixed incorrect Formula results when a Named Range LAMBDA returns a Range through an IFS expression for use in COUNTIFS or MAXIFS.
- Fixed unexpected unsigned satellite resource assembly included in the NuGet package.
Released: Jun 11, 2026
Updates in v9.1.1
Fixes
- Fixed issue where unable to open Workbooks containing defined name formulas that use dynamic array functions and optional LAMBDA parameters.
- Fixed unexpected recalculation of some external-link formulas when opening a Workbook, causing cached values to be replaced with #NAME? or recalculated results.
- Fixed issue where unable to parse CJK date formats in template language filter DATETIME expressions.
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...