Released: Mar 17, 2023

Updates in 6.0.5

Fixes

• Exception is thrown on calling calculated or save method when workbook contains dynamic array formulas.
• The error type of formulas are different from Excel.
• The condition format result in the exported PDF file is different Excel.
• The table style is incorrect in the exported Excel file after processing template.
• Exception is thrown on calling fromJson method.
• Lambda function does not return correct result when getting values.
• Exception is thrown on saving workbook when it contains corrupted...

Released: Feb 24, 2023

Updates in 6.0.4

Features

• Added the option to control to export shared formula in SSJSON file.

Fixes

• Exception is thrown on loading particular SSJSON file contains circular reference.
• The calculated result is incorrect from Excel.
• The result of IFNA function is incorrect from Excel.
• The celltype in copied range is not cleared when copying range from other worksheet.
• The column which width is 0 is invisible in the SpreadJS designer.
• The shape is lost in the exported Excel and PDF file after setting the shape...

Released: Feb 3, 2023

Updates in 6.0.3

Fixes

• The calculation result is incorrect when the formula is array formula.
• The number format changes from "General" to "Custom" after loading and exporting SSJSON file.
• The height of plot area and the tick labels are incorrect in the exported PDF file.
• Exception is thrown on inserting rows when worksheet contains data validation.
• Exception is thrown on loading particular SSJSON file contains unexpected binding path content.
• Exception is thrown on loading then saving to another Excel file.
• The...

Released: Jan 6, 2023

Updates in 6.0.2

Fixes

• The marker size, data label and series line color chart are incorrect in the exported PDF file.
• Some row heights are incorrect after processing template.
• The linked cell text color becomes white after loading the SSJSON file then exporting to SSJSON file.
• Exception is thrown on saving Excel file when the file name has only one character.
• The interface Workbook.SetLicenseFile is lost.

Released: Dec 23, 2022

Updates in 6.0.1

Fixes

• Performance issue when using table bindings with 500,000 rows data.
• The exported Excel file is corrupted after processing template.
• The data validation lost after loading the SSJSON file when the applied range is whole column.
• Exception is thrown on exporting PDF file when using data binding.
• PageSetup.Zoom does not take effect on barcode in the exported PDF file.
• "Swiss 721 BT" font is not shown correctly in the exported PDF file.
• Print titles settings are lost in the generated report...

Released: Dec 12, 2022

Updates in 6.0.0

Features

• Added JavaScript-based, client-side viewer that can load and preview data-related documents like XLSX, CSV, and SpreadJS .json files.
• Added support for new Lambda function including help functions.
• Improved Paginated Spreadsheet reports.
• Added new text and array manipulation Microsoft Excel functions.
• Added support for 'RowColumnStates' in JSON I/O.
• You can now add shape text with range reference or defined name.
• You can now add shape/picture to cell/cell range using direct method...

Released: Aug 15, 2022

Updates in 5.2.0

Features

• Added new API to add Microsoft Excel Form Controls.
• Added support for CASCADESPARKLINE formula.
• Added the ability to define Paginated Templates in spreadsheets (with GcExcel Templates).
• Added support for Chart Data Table.
• Added support for LET function.
• GetPivotData Formula now supports spilled data.
• Added the ability to add Calculated Item in Pivot Table.
• Added the ability to get accurate range boundary.
• Added the ability to use JSON as DataSource in data binding.
• Added IsVolatile...

Released: Jul 26, 2022

Updates in 5.1.5

Fixes

• The performance of opening particular Excel file need to be optimized.
• It takes a long time to execute calculating when workbook contains AverageIf formula.
• The calculation result of MIDB formula is incorrect in CJK culture.
• The IMPOWER formula result is incorrect.
• Exception is thrown on calling Workbook.ToJson() method when workbook contains external reference.
• Exception is thrown on loading particular SSJSON.
• The calculation result of SUMIFS formula is inconsistent with Excel.
• Exception...

Released: Jul 7, 2022

Updates in 5.1.4

Fixes

• The rowheight is incorrect after copying worksheet.
• The result of SEARCHB func is different from Excel in Chinese culture.
• The result of autoFit is bad in the exported PDF file.
• Some borders are missing in the exported image after loading particular JSON file.
• Exception is thrown on drawing Pivot Table to PDF file.
• IllegalArgumentException is thrown on exporting image when some fonts are missed in system.
• The texts in the merged cell near the page boundary are not output to PDF file...

Released: Jun 16, 2022

Updates in 5.1.3

Fixes

• The color of cell font is incorrect in exported JSON file.
• Platform dependent characters are incorrect in the exported PDF file.
• NullReferenceException is thrown on exporting PDF file.
• The performance of inserting lots of pictures is bad.
• The value of formula N is incorrect.
• The exported XLSM file is corrupted after deleting some sheet which contains external reference.
• Setting IWorksheetView.ScrollColumn/ScrollRow properties on a worksheet which has freeze pane corrupts the saved Excel...