# 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/dot-net-excel-api/docs/online/formula-reference/text-functions/valuetotext) and [ARRAYTOTEXT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/arraytotext).
* Added the [XlsxSaveOptions.ExportSharedFormula](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.XlsxSaveOptions.ExportSharedFormula.html) property to [allow controlling SharedFormula](/document-solutions/dot-net-excel-api/docs/online/ManageFileOperations/ImportAndExportxlsxDocument#shared-formula-export-options) export in XLSX export.
* Added support for [AI functions](/document-solutions/dot-net-excel-api/docs/online/Features/ai-assistant/ai-functions), including [AI.QUERY](/document-solutions/dot-net-excel-api/docs/online/Features/ai-assistant/ai-functions/aiquery), [AI.TRANSLATE](/document-solutions/dot-net-excel-api/docs/online/Features/ai-assistant/ai-functions/aitranslate) and [AI.TEXTSENTIMENT](/document-solutions/dot-net-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 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](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IRange.Copy.html) 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](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IRange.Text.html) 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.