Document Solutions for Excel, .NET Edition Releases
Released: May 26, 2023
Updates in 6.1.1
Fixes
- Performance issue on calling IRange.Merge() method and exporting to Excel file.
- Exception is thrown on loading particular SSJSON file.
- The result is incorrect of data binding when the binding path contains the index of array.
- The tick marks units of charts in the exported PDF file are smaller than ones in Excel file.
- The margin setting is incorrect in the exported Excel file after loading the SSJSON file.
- Filter is lost in the exported SSJSON file.
- The column width of row header is lost in...
Released: May 9, 2023
Updates in 6.1.0
Features
- Added support for SpreadJS .sjs file format.
- Added export options in ToImage() method.
- Added the ability to copy/move multiple sheets at once.
- Added support for XLTX file format.
- Added support for Form Controls on SpreadJS JSON I/O.
- Added support for allowResize property on SpreadJS JSON I/O.
Fixes
- Exception is thrown on adding calculated items on Pivot Field.
- The performance of Workbook.FromJson() method is bad when JSON contains stripped style in big tables.
- The calculating...
Released: Apr 7, 2023
Updates in 6.0.6
Fixes
- Image size is not adjusted with the column width when setting BestFitColumns as true when exporting PDF file.
- NullReferenceException is thrown on calling the PrintManager.Paginate() method.
- The text is not wrapped in the exported PDF file.
- Cell notes lost after saving workbook to a new Excel file.
- Data binding does not support special symbols.
- Table filters are not working properly after fetching Table JSON.
- Table and Slicers are cleared after fetching the table JSON.
- Exception is thrown...
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.
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...