Document Solutions for Excel Java v9.1.42026年7月24日
修正
Unexpected custom Formula evaluation in another Cell when retrieving the current Array Formula for a Range.
Unexpected Excel repair warnings and incorrect duotone Image colors when exporting SpreadJS files to XLSX.
Incorrect Conditional Formatting colors in XLSX files exported from SJS sources compared with equivalent SSJSON sources.
Incorrect English weekday names when retrieving Korean-formatted Cell text or exporting a Workbook to PDF.
Unexpectedly slow Worksheet renaming after repeatedly copying Worksheets in a growing Workbook.
Incorrect #REF! results for INDIRECT Formulas that use Japanese localized Table structured-reference specifiers.
Unexpected exceptions when a Workbook contains a question mark in a Table name.
Unexpected null values for empty results in a spilled Formula after opening a Workbook without recalculation.
Incorrect HasArray results for Cells containing regular Formulas or plain text.
Missing object details in the exception returned when opening certain Workbooks with conflicting external link data.
Document Solutions for Excel Java v9.1.32026年7月2日
修正
Incorrect handling of Charts inside nested Shape groups when opening a Workbook.
Incorrect Sort results for in-cell Images when sorting a Range that contains Images without alternative text.
Failure to open valid XLSX Workbooks whose theme elements use a default namespace.
Incorrect black Worksheet tab color when clearing the tab color with an empty value.
Incorrect date formatting for non-English Workbook cultures in Cell text and PDF output.
Incorrect Worksheet Formula evaluation when custom names supplied by a Formula resolver return text or numeric values.
Unexpected sharing of Worksheet and Range metadata across Worksheets generated by template processing.
Document Solutions for Excel Java v9.1.22026年6月11日
修正
Failure to open Workbook JSON when a Cell contains array information and a shared Formula reference.
Security scanner warnings appeared for the Bouncy Castle dependency included with the product.
Incorrect AVERAGEIF calculation results when the criteria range contains both numeric values and blank Cells and the sum range is omitted.
Incorrect Formula results when a Named Range LAMBDA returns a Range through an IFS expression for use in COUNTIFS or MAXIFS.
Document Solutions for Excel Java v9.1.12026年5月21日
修正
Unable to open Workbooks containing defined name formulas that use dynamic array functions and optional LAMBDA parameters.
Unexpected recalculation of some external-link formulas when opening a Workbook, causing cached values to be replaced with #NAME? or recalculated results.
Unable to parse CJK date formats in template language filter DATETIME expressions.
Document Solutions for Excel Java v9.1.0主要版本2026年5月5日
功能
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 template filters.
Added support for date and time values in template filters.
Added the IRange.setCellPicture method to allow inserting pictures in cells.
Added support for expandable cell types and drop-down fields in template cells.
Added support for pivot table styles.
Added support for lossless import and export of the SJS and SSJSON file formats in SpreadJS v19.1.
修正
Fixed the issue of signed Excel files becoming invalid when saved with a PFX certificate.
Fixed the issue of security vulnerabilities and bundled third-party dependencies.
Fixed the issue of images from template data sources appearing in the wrong order.
Fixed the issue of pivot table styles being lost after refresh.
Fixed the issue of pivot table cell alignment being lost after sorting.
Fixed the issue of unexpected memory growth during concurrent report generation.
Fixed the issue of recalculating a workbook after input updates producing inconsistent results.
Fixed the issue where certain SJS files failed to open due to a FormatException triggered by NaN values.
Fixed the issue where the implicit intersection operator (@) was unexpectedly inserted into FORECAST.LINEAR formulas after opening and saving a workbook.
Document Solutions for Excel, Java Edition v9.0.0主要版本2026年1月6日
功能
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.
修正
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 high memory use.
Copying formulas across Worksheets is significantly slower in newer versions.
Range.Copy on very large ranges can be extremely slow.
Enabling the calculation engine after sheet and named-range changes can throw a NullReferenceException.
Opening certain Workbooks can fail on JDK 21+.
XLOOKUP can return incorrect numeric results compared to Excel.
Calling Range.getText() can throw an exception.
LET formulas adding a scalar to very large arrays return values only in the first row and zeros elsewhere.