# Release Notes for Version 9.0.0

## Content

## Enhancements from the Previous Release

* Added support for lossless export/import of Query Table.
* Added support for new Excel functions: [VALUETOTEXT](/document-solutions/java-excel-api/docs/online/formula-reference/text-functions/valuetotext) and [ARRAYTOTEXT](/document-solutions/java-excel-api/docs/online/formula-reference/text-functions/arraytotext).
* Added the [XlsxSaveOptions.setExportSharedFormula](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/XlsxSaveOptions.html#setexportsharedformula) property to [allow controlling SharedFormula](/document-solutions/java-excel-api/docs/online/ManageFileOperations/ImportAndExport.xlsxDocument#shared-formula-export-options) export in XLSX export.
* Added support for [AI functions](/document-solutions/java-excel-api/docs/online/Features/ai-assistant/ai-functions), including [AI.QUERY](/document-solutions/java-excel-api/docs/online/Features/ai-assistant/ai-functions/aiquery-), [AI.TRANSLATE](/document-solutions/java-excel-api/docs/online/Features/ai-assistant/ai-functions/aitranslate) and [AI.TEXTSENTIMENT](/document-solutions/java-excel-api/docs/online/Features/ai-assistant/ai-functions/aitextsentiment).
* 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](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/IRange.html#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()](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/IRange.html#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.