Document Solutions for Excel, .NET Edition Releases

Released: Oct 30, 2020

Updates in 3.2.4

Fixes

  • DataValidation does not work for added rows for Table.
  • PivotTable's row field is missing after PivotTable.AddDataField().
  • Exception occurs when exporting Pivot Table to PDF.
  • PivotTable.RowRange throws exception if there is no row fields.
  • Table Resize with one row table lost conditional format and data validation.
  • The printed area does not consider hidden rows and columns.
  • The calculated result of Lookup formula is different with Excel.
  • The IRange.Columns.AutoFit() result is wrong when...

Released: Aug 7, 2020

Updates in 3.2.1

Features

  • Added additional functionalities to existing API to help you generate more secure Microsoft Excel reports with digital signatures, as well as converting them to other formats. The main highlights of this release are:
    • Export Excel spreadsheets and Excel ranges to HTML.
    • Digital signatures support in Excel spreadsheets.
    • Enhanced template support: create Excel reports with tables, sparklines, fixed layout, and PDF forms.
    • More pivot table enhancements.
    • Shape z-order support.
    • More features...

Released: Jul 23, 2020

Updates in 3.2.0

Features

  • Support for generating PDF Forms from Microsoft Excel templates.
  • Support for using sparklines and tables in Microsoft Excel templates.
  • Define fixed layout for Microsoft Excel reports and fill data in a specific range.
  • Support for exporting workbook/worksheet/ranges to HTML.
  • Support for Digital Signatures API: add and sign signature lines, add and sign non-visible signatures, verify signatures, etc.
  • Pivot Table enhancements: create multiple files from one pivot field, defer updating...

Released: Jun 19, 2020

Updates in 3.1.5

Fixes

  • Column width is not correct when workbook is exported to JSON.
  • NullReference exception is thrown while adding row in Table.
  • Background color of some cells is incorrect when rows are deleted on a sheet with background color set in cells.
  • Text is not correctly separated on a specific line when loading tab-delimited text to workbook.
  • Culture property of the Workbook does not respect the value of the cell when opening the CSV file.
  • NumberFormat exception is thrown when importing SSJSON that...

Released: Jun 4, 2020

Updates in 3.1.4

Fixes

  • Exception is thrown when loading Excel file which contains huge amount of inline strings.
  • The data labels are not plotted correctly when exporting Radar chart to PDF.
  • It will take a very long time to process template when there are thousands of data records.
  • Exception is thrown when exporting to PDF.
  • The calculated result of CountIfs function is wrong.

Released: May 18, 2020

Updates in 3.1.3

Fixes

  • Error occurs when adding new row in a table.
  • Cell formatted text is wrong when the number format is "@".
  • Error occurs after calling Workbook.Calculate().
  • Cell font color is not correct when some kind of number formatter is applied.
  • Cell background in the exported PDF is black even though it is "lightgray" in JSON.
  • Error occurs when from JSON.
  • Cell rich text is rendered wrong in the exported PDF when the cell is a combo cell type.
  • Top alignment is changed to bottom in SpreadJS after...

Released: Apr 28, 2020

Updates in 3.1.2

Fixes

  • Exception is thrown when cutting tables.
  • The line style in exported PDF is not same as it is in Microsoft Excel
  • The default date format is not changed by culture.
  • Exception occurs when copying a sheet from another workbook and saving the workbook.
  • There are unexpected lines on top of cell in the exported PDF.
  • The saved Excel file is corrupted.
  • Some values in the exported Excel file are incorrect.
  • It takes a long time to open an Excel with a lot of inline strings.
  • The plot area's boundary...

Released: Apr 13, 2020

Updates in 3.1.1

Fixes

  • Certain cell border lines do not render correctly when exporting to PDF.
  • The order of legend for chart in exported PDF is incorrect if legend across lines.
  • Issue occurs when inserting new row to an existing table.
  • Cell Formatter change after save JSON.
  • In Microsoft Excel, the horizontal break line will be ignored when set the exporting height fit to 1 page(s).
  • IRange.Copy() cannot copy pictures sometimes.
  • Save Excel containing Chart shows different output.
  • The color of DataSeries of Chart...

Released: Mar 18, 2020

Updates in 3.1

Features

  • New Templates Features to Generate Reports - Templates support with comprehensive syntax and API to bind Microsoft Excel documents with data and generate Excel reports with advanced layouts.
    • Insert images from a database in Excel reports.
    • Support conditional formatting when generating reports. All types of conditional formatting rules are supported.
    • Specify default behavior of the Excel template, when it expands, for example - specify default row height/column width, insert extra spaces...

Released: Jan 17, 2020

Updates in 3.0.4

Fixes

  • Exception is thrown when importing ssjson with certain group settings.
  • Exception is thrown when importing ssjson with some null values.
  • Digital signature is lost when an Excel file is modified and saved through GcExcel.
  • Memory leak occurs when using GcExcel in multiple threads.
  • Group can not be expanded in SpreadJS after loading ssjson from GcExcel.
  • Rich text can not be rendered correctly in the exported pdf.
  • The return value of IRange.HasFomula is wrong.