# Release Notes for Version 6.0.0

DsExcel is a Document Solutions 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.