Released: Aug 26, 2023

6.2.1 での更新項目

不具合の修正

• The legend of deleted series in chart are displayed in the exported Excel file.
• Doughnut charts is lost in the exported PDF file.
• The wrap position is incorrect when text contains "-" charactor in the exported PDF file.
• The result of the formula in the defined name is not updated correctly.
• The program gets stuck when processing template.
• The sparklines is incorrect in the exported PDF file.
• The program gets stuck when processing template.
• Exception is thrown on exporting PDF file when...

Released: Aug 7, 2023

6.2.0 での更新項目

機能

• Added support for double-sided printing.
  • GcExcel .NET supports the Duplex enum in PrintOutOptions class to enable/disable double-sided printing on a page.
  • There are four options in the enum that the user can use accordingly to print the workbook:
    • Duplex.Default indicates the printer's default duplex setting.
    • Duplex.Simplex indicates Single-sided printing.
    • Duplex.Vertical indicates the Double-sided, vertical printing.
    • Duplex.Horizontal indicates the Double-sided, horizontal printing.
• Added the...

Released: Jul 21, 2023

6.1.4 での更新項目

不具合の修正

• Requested Registry access is not allowed error occur on setting the impersonate in the web.config for web app.
• The result of XIRR func is incorrect.
• InvalidFormulaException is thrown on opening an Excel file with XLOOKUP formula which refers to external Table formula.
• The result of reappling filter is incorrect after setting data source.
• The result of dynamic array formula is incorrect when disabling calculation engine the enabling.
• StackOverFlowException is thrown on processing template...

Released: Jul 7, 2023

6.1.3 での更新項目

不具合の修正

• Performance issue on processing Template file.
• Exception is thrown on calling IRange.Ungroup() method.
• The result of DATEDIF formula is incorrect in JP culture.
• Some cell content is lost after processing Template file.
• Some text is incomplete in the exported PDF file.
• Exception is thrown on copying worksheet contains form controls.
• Exception is thrown on loading the particular Excel file.
• After refreshing the Pivot Table, the exported SSJSON file size becomes very large.
• Performance issue...

Released: Jun 16, 2023

6.1.2 での更新項目

不具合の修正

• Performance downgradation on using PrintManager to exporting PDF file comparing to old version.
• The column count is incorrect in the exported PDF file when adding a shape with rotation.
• The result of cross workbook formula is incorrect in the export Excel file.
• The calculated item is not saved correctly when some fields are not visible.
• Performance issue on calling Workbook.Calculate() method.
• The indent of the checkbox list is missing in the exported PDF file.
• KeyNotFoundException is...

Released: May 26, 2023

6.1.1 での更新項目

不具合の修正

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

Released: May 9, 2023

6.1.0 での更新項目

機能

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

不具合の修正

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

Released: Apr 7, 2023

6.0.6 での更新項目

不具合の修正

• 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

6.0.5 での更新項目

不具合の修正

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

Released: Feb 24, 2023

6.0.4 での更新項目

機能

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

不具合の修正

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