Released: May 18, 2020

3.1.3 での更新項目

不具合の修正

• 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

3.1.2 での更新項目

不具合の修正

• 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

3.1.1 での更新項目

不具合の修正

• 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

3.1 での更新項目

機能

• 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 in...

Released: Jan 17, 2020

3.0.4 での更新項目

不具合の修正

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

Released: Jan 7, 2020

3.0.3 での更新項目

不具合の修正

• Exception is thrown when importing xlsx file with certain conditional formatting.
• Hyperlink included in ssjson, does not display when exported to PDF.
• The column formula is not expanded after adding new rows in Table.
• Exception is thrown when importing ssjson with data validations.
• When the tag of the copied sheet is changed, the tag of the copy source is also changed.
• Exception is thrown when importing ssjson with grouping.
• Extra Border is drawn around an image in the header, when xlsx...

Released: Dec 13, 2019

3.0.2 での更新項目

不具合の修正

• Exception is thrown when importing ssjson that contains duplicated table names.
• Null reference exception is thrown when exporting to ssjson.
• Index out of range exception is thrown when exporting to PDF.

Released: Oct 30, 2019

3 での更新項目

機能

• Create Microsoft Excel Reports using Templates - GcExcel introduces new template support with a comprehensive syntax and API to bind Excel documents to data to generate Excel reports with advanced layouts. Key Features:
  • Simple language syntax
  • Define data expansion direction
  • Define Context for data expansion
  • Define range of data
  • Add data from multiple data sources
  • Group your data
  • Outline Group
  • Specify nested data fields
  • Define Formula functions
  • Define Sort expression
  • Define Expression fields...

Released: Sep 30, 2019

2.2.6 での更新項目

機能

• Improved opening time of large spreadsheets containing shape and auto-fit rows.
• Added support for JP built-in named styles.

不具合の修正

• Formula result is not precise which leads to conditional checking failure.
• The location and size of shapes are incorrect after opening the saved Microsoft Excel spreadsheet under JP culture.
• The content of exported PDF is incorrect.

Released: Sep 5, 2019

2.2.5 での更新項目

不具合の修正

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