Document Solutions for Excel, Java Edition Versioni

Scopri le novità in ogni release, con dettagli su funzionalità, miglioramenti e problemi risolti.

gen
feb
mar
apr
mag
giu
lug
ago
set
ott
nov
dic
Document Solutions for Excel Java v9.1.424 lug 2026
Correzioni
  • 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.32 lug 2026
Correzioni
  • 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.211 giu 2026
Correzioni
  • 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.121 mag 2026
Correzioni
  • 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.0Versione principale5 mag 2026
Funzionalità
  • 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.
Correzioni
  • 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.0Versione principale6 gen 2026
Funzionalità
  • 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.
Correzioni
  • 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.