Document Solutions for Excel, Java Edition 출시

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일

기능

수정 사항

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.

Document Solutions for Excel, Java Edition 릴리스