[]
        
(Showing Draft Content)

Release Notes for Version 6.0.0

Breaking Changes from the previous release

  • In GcExcel 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 GcExcel 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.