# Release Notes for Version 9.2.0

## Content

## Breaking Changes

* The following types have been removed from the public API.
    * IAutoCorrect
    * FormFieldSubmitFormatType
    * ICellCollection
    * HeaderFooterPosition
    * HeaderFooterType
    * ITableStyleInfo
    * ILegendKey
    * ILeaderLines
    * GraphicColorType
    * RangeFindReplace.FindReplaceImpl.FindMatch
    * RangePartialClasses.FindReplaceImpl.FindMatch

>type=note
> **Note**: The types listed above represented internal implementation details and were not intended for direct use. They could not be instantiated or obtained through any supported public API. Their removal does not affect supported functionality or applications that use supported public APIs.

## Enhancements from the Previous Release

* Added support for [rendering Japanese Ruby text](/document-solutions/java-excel-api/docs/online/ManageFileOperations/ExporttoaPDFFile/ExportText#export-ruby-text) when exporting workbooks to PDF.
* Added support for preserving equation symbols when loading and saving XLSX workbooks.
* Added support for [preserving grouped Excel form controls](/document-solutions/java-excel-api/docs/online/Features/excel-form-controls#form-control-shapes) when opening workbooks.
* Added support for [retaining pivot table group information](/document-solutions/java-excel-api/docs/online/Features/UsePivotTable/PivotTableSettings/group-pivot-table-fields) after pivot tables are refreshed.
* Added the [Workbook.getCustomXmlParts](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/Workbook.html#getcustomxmlparts) method to support [embedding and reading Custom XML data](/document-solutions/java-excel-api/docs/online/Features/ManageWorkbook/custom-xml-parts) in Excel workbooks.
* Introduced a [performance demonstration site](https://developer.mescius.com/document-solutions/java-excel-api/demos/performancebenchmarkdemo) for evaluating large-workbook scenarios involving large amounts of data.
* Improved [API documentation](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/package-summary.html) with usage examples and detailed parameter descriptions.
* Added the [CsvSaveOptions.setEscapeFormulaLikeValues](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/CsvSaveOptions.html#setescapeformulalikevalues) method to help [prevent formula injection](/document-solutions/java-excel-api/docs/online/ManageFileOperations/ImportandExportCSVFile#prevent-csv-formula-injection) in CSV files.
* Added support for rendering File Upload cell types in exported PDFs, including image attachments, non-image file names, and empty upload states.
* Added support for rendering [Pareto charts and Histogram charts](/document-solutions/java-excel-api/docs/online/ManageFileOperations/ExporttoaPDFFile/export_charts_to_pdf#histogram-chart) when exporting workbooks to PDF.
* Added support for [preserving AI function formulas](/document-solutions/java-excel-api/docs/online/Features/ai-assistant/ai-functions#spreadjs-compatibility) when importing from or exporting to SJS or SSJSON files with SpreadJS.
* Added the [IName.setVisible](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/IName.html#setvisible) method to support [preserving hidden named ranges](/document-solutions/java-excel-api/docs/online/Features/DefinedNames#show-or-hide-defined-names) in workbooks.
* Added support for lossless import and export of SJS and SSJSON files in SpreadJS v19.2.
* Added support for configuring [how invalid formulas are handled when opening Excel workbooks](/document-solutions/java-excel-api/docs/online/ManageFileOperations/ImportandExportExcelOptions#handle-invalid-formulas-when-opening-excel-files).

## Resolved Issues

* Fixed the issue of incorrect pivot table group names in exported Excel files after a pivot table refresh.
* Fixed the issue of certain formulas returning incorrect results.
* Fixed the issue of DateTime values generated from a template not following the cell number format defined in the template.