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.ExportSharedFormula 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 is very slow.

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

• Fixed the issue of saving a workbook to PDF can trigger a console error.

• Fixed the issue of severe slowdowns and high memory usage when performing formatting and AutoFit on very large reports.

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

• Fixed the issue of Range.Copy may be 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 XLOOKUP may return incorrect numeric results compared to Excel.

• Fixed the issue of accessing Range.Text 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.