Document Solutions for Excel, .NET Edition Releases

Released: Sep 5, 2019

Updates in 2.2.5

Fixes

  • The picture name is changed after saving a workbook to json several times.
  • Corrupted Excel file is generated after copying a range containing checkbox control.
  • Cell border is lost in exported pdf file.
  • The auto row height is incorrect in the exported pdf if there is a merged cell and wrap text is true.
  • Exception is thrown when opening a Excel file with a table whose name contains '.'.
  • The marker of data series is changed after saving and loading json.
  • The content should not be wrapped when...

Released: Aug 23, 2019

Updates in 2.2.4

Fixes

  • IndexOutOfRange exception is thrown when the same XLSX file is opened with parallel threads.
  • Exception is thrown after loading ssjson and then save to PDF file.
  • Column width changed after loading ssjson.
  • Unable to fill shape with picture through API.
  • Exception is thrown after loading ssjson and then invoke SetColumnWidth.
  • Some text can not be rendered completely in the exported PDF file.
  • Unable to set a picture fill for shape.
  • The public members can not be evaluated correctly in vs debug...

Released: Aug 8, 2019

Updates in 2.2.3

Fixes

  • Incorrect sparkine is rendered in the exported PDF file.
  • InvalidFormulaException is thrown during loading ssjson.
  • An error occurs while saving to PDF file.
  • Stack overflow occurs while saving to PDF file.
  • Exception is thrown while loading a xlsm file.
  • Cell Style is not correct after GcExcel toJSON and then SpreadJS fromJSON.

Released: Jul 24, 2019

Updates in 2.2.2

Fixes

  • Customer can overwrite current function implementation when registering a new custom function.
  • Exception is thrown when exporting to json.
  • Exception is thrown after adding a lot of hyperlinks then saving to Excel.
  • Some text can not display completely in the exported pdf file.
  • ArgumentOutOfRangeException is thrown on using Calculate method for a Workbook.
  • If calculated result is too large(20+ digits) in the cell, the value acquired by GcExcel is horizontally reversed.
  • There is a difference...

Released: Jun 12, 2019

Updates in 2 Service Pack 2

Features

  • Export spreadsheets with shapes to PDF: Insert arrows, lines, pictures, general shapes, and MS Excel in-built shapes.
  • Control pagination and spreadsheet content export to PDF: Control printing specific Excel portions to PDF documents:
    • Render Excel ranges Inside a PDF
    • Print specific pages of Excel to PDF
    • Group customized data range while exporting to PDF
    • Print multiple worksheets to one page in PDF
    • Manage headers on different pages
  • Export different Excel workbooks into one PDF: Export or...

Released: Apr 19, 2019

Updates in 2.1.4

Features

  • Significantly improved the performance of exporting a single worksheet to PDF.
  • FromJson method was improved when Json contained table style and multiple named styles.
  • GcExcel now sets minimum value of Zoom factor to 10% when exporting spreadsheet to PDF, similar to MS Excel.

Released: Mar 7, 2019

Updates in 2.1.1

Features

  • Added IWorksheet.FixedPageBreaks to control whether to adjust page breaks after inserting/deleting rows or columns.
  • Improved the effect of wrapped text to PDF.

Released: Jan 30, 2019

Updates in 2 Service Pack 1

Features

  • Add rich text to spreadsheet cells - You can set various font properties on the cell text through the API, and rich text is supported during Excel I/O, JSON I/O and PDF exporting. You can create rich text and then configure the font for a range of text characters; or add, enumerate, operate and configure all text runs of the rich text.
  • Load, save, and preserve Excel files containing macros (I/O .xslm) - The macros are not executed, but are preserved when any operation is performed on...

Released: Jun 7, 2018

Updates in 1.5.0.3

Features

  • Documents for Excel performance improvements - GcExcel is now faster than ever, with several major performance enhancements. GcExcel’s enhanced performance includes:
    • Getting/setting value for a single cell
    • Setting an array of double/int/float values to a range, for example, Range.Value = new double[,]{ {1d, 2d}, {3d, 4d}}
    • Getting/setting style for single cell
  • New APIs
    • CellInfo class - While working with a range of cells, several customers have expressed the need to convert columns/rows...