Release Notes for Version 9.0.0

Enhancements from the Previous Release

• Added support for lossless export/import of Query Table.

• Added support for new Excel functions: VALUETOTEXT and ARRAYTOTEXT.

• Added the XlsxSaveOptions.setExportSharedFormula property to allow controlling SharedFormula export in XLSX export.

• Added support for AI functions, including AI.QUERY, AI.TRANSLATE and AI.TEXTSENTIMENT.

• Added support for SJS/SSJSON import and export of threaded comments.

• Added performance optimizations.

Resolved Issues

• Fixed the issue of copying a worksheet with many formulas being very slow.

• Fixed the issue of opening and profiling a workbook being noticeably slower.

• Fixed the issue of saving a workbook to PDF potentially triggering a console error.

• Fixed the issue of formatting and AutoFit on very large reports causing severe slowdowns and high memory use.

• Fixed the issue of copying formulas across worksheets being significantly slower in newer versions.

• Fixed the issue of Range.Copy being extremely slow on very large ranges.

• Fixed the issue of enabling the calculation engine after sheet and named-range changes may throw a NullReferenceException.

• Fixed the issue of opening certain workbooks failing on JDK 21+.

• Fixed the issue of XLOOKUP may return incorrect numeric results compared to Excel.

• Fixed the issue of calling Range.getText() may throw an exception.

• Fixed the issue of LET formulas adding a scalar to very large arrays return values only in the first row and zeros elsewhere.