# Release Notes for Version 6.0.0

DsExcel Java is a MESCIUS Documents product that offers a comprehensive library to create, manipulate, convert, and share Microsoft Excel-compatible spreadsheets.

## Content



## Breaking Changes from the previous release

* In DsExcel 5.2.5 and earlier, **XlsxOpenOption.DoNotAutofitAfterOpened** property was used to get or set whether to autofit the row height after opening the file. In DsExcel 6.0, the property name has changed to **XlsxOpenOption.DoNotAutoFitAfterOpened**, where F of Autofit has been capitalized.

## Enhancements from the Previous Release

* Added a LAMBDA function to create custom and reusable function.
* Added Page-size pagination and Count-per-page pagination properties and functions for generating Paginated reports.
* Added new text and array manipulation Excel functions.
* Added support for RowColumnStates in JSON I/O to save the cell state info.
* Added shape text support that refers to with range or defined name.
* Added direct methods for refer shapes or pictures with cell/cell range.
* Added autofit options that control xlsx/xlsm file while opening.
* Added externalReference using cross-workbook formula support in JSON IO.
* Added support for GetUsedRange method to extract used range for the selected area.
* Added support for setting page number and page count formula for groups in template pagination.
* Added support for GenerateReport method that helps you keep original template and return the report workbook instance.
* Added overload of GenerateReport method that helps you process template for specific worksheets in template language.
* Added Intersect, Union, and Offset methods in IRange interface to get the intersection, union, and offset of the current range.
* Added "allSheetsListVisible￣ feature to support all sheets button of SpreadJS in JSON IO.
* Removed support for JDK 7 and older versions. Hence, DsExcel now targets only JDK 8 and above.