Released: Oct 4, 2021

4.2.3 での更新項目

機能

• Updated README.md file.

Released: Sep 24, 2021

4.2.2 での更新項目

機能

• Added support for XlsmOpenOptions and XlsmSaveOptions.

不具合の修正

• "Justify distributed" setting is lost in the exported PDF file.
• Exception is thrown on copying a worksheet to another workbook.
• The checkbox is lost in the exported PDF file.
• The cell value is incorrect after using setValue method to set the cell value.
• Print Area is different from the original JSON file in the exported JSON.
• Exception is thrown on reading the JSON file.
• The exported Excel file is corrupted after deleting rows...

Released: Sep 3, 2021

4.2.1 での更新項目

機能

• Added dynamic array and workbook URI links to formula parser.
• Enhanced Range.AutoFit(bool considerMergedCell).

不具合の修正

• ITickLabels.NumberFormat is not applied when saving a workbook to PDF/Image/HTML file.
• When IAxis.MajorUnit is set, tick labels are duplicated in exported PDF/Image/HTML file.
• When the chart series is added, orders of series and legends are incorrect in exported XLSX file.
• Values of category axis are incorrect in exported PDF/Image/HTML file.
• Exception is thrown on saving PDF...

Released: Aug 16, 2021

4.2 での更新項目

機能

• Dynamic Array Formulas
  • GcExcel adds extensive support for adding dynamic array formulas to Microsoft Excel files through code. The new workbook.AllowDynamicArray will allow you to enable/disable the dynamic array formula in the worksheet. Once enabled, you can use these seven new functions and the dynamic array formula to give the results desired by your applications:
    • FILTER.
    • RANDARRAY.
    • SEQUENCE.
    • SINGLE.
    • SORT.
    • SORTBY.
    • UNIQUE.
  • Two new errors have also been added:
    • #Spill! - Indicates that a...

Released: Jul 29, 2021

4.1.4 での更新項目

不具合の修正

• The exported PDF is different from SpreadJS designer.
• Throws an exception on saving a PDF file.
• Program stuck on using the 'copy' method of IRange.
• 'CellInfo.GetRangeBoundary' method generates incorrect result.
• Zoomfactor info is lost in the exported JSON.
• The page footer in exported PDF is incorrect with the '&D' format.
• The number format of PivotTable's data field is lost in the exported Excel file.
• Throws an exception on using the 'IWorksheet.FromJson' method.
• Treemap and Sunburst...

Released: Jul 9, 2021

4.1.3 での更新項目

機能

• Reduces the size of exported json files.
• Optimizes the performance of importing and exporting json files.

不具合の修正

• Throw NumberFormatException when opening the Microsoft Excel file.
• Method 'toJson' fails while using Cube Formulas and OLAP Tools.
• When the connector which is set as arrow head style is exported to JSON file, it is not displayed correctly on importing that JSON file in SpreadJS.
• PivotTable's data field NumberFormat lost after exporting to Microsoft Excel file.
• Exception on opening...

Released: Jun 16, 2021

4.1.2 での更新項目

不具合の修正

• Performance Issue in reading formula from Excel file using GcExcel API with compare to Spread.
• Range Value not getting after loading file in GcExcel.
• Performance issue in accessing the cell when using Slicer in the Excel sheet.
• FormulaResult is not correct if the Evaluate returns null.
• Saved Workbook corrupted after copying sheet with invalid cell format from existing workbook.
• GcExcel for Java takes too long to import SSJSON.
• ToJSON throw Index out of bound exception.
• [I/O Lossless...

Released: May 20, 2021

4.1.1 での更新項目

不具合の修正

• Shape Color changed after saving Excel file using GcExcel API.
• Invalid formula error when opening particular Excel using GcExcel API.
• Behaviors of pivot table changed after saving using GcExcel API.
• INDEX function value in returning "Ref" when opening Excel using GcExcel API with DoNotRecalculateAfterOpened= false.
• Collapsed grouping shows "-" sign when opening exported Excel from GcExcel, in SpreadJs.
• Value is returning "Ref" for the output fields after calling Calculate method of...

Released: Apr 30, 2021

4.1 での更新項目

機能

• Performance improvements in Microsoft Excel Template processing.
• Parse formula strings into a syntax tree.
• Ignore formulas when saving Excel files.
• Support open action script on PdfSaveOptions.
• New overload method to load JSON.
• Improved Calculation Engine performance when setting values.
• More features for SpreadJS integration:
  • Support for RangeTemplate cell type.
  • Apply custom objects on CheckboxList and RadioButtonList cell type.
  • Added new ToJson and FromJSON methods to Workbook elements.
  • Get...

Released: Apr 9, 2021

4.0.5 での更新項目

不具合の修正

• When workbook is exported to PDF on AWS Lambda, TypeInitializationException will be thrown.
• Structured references in table cells not calculating after range copy/paste between worksheets.
• Incorrect value when using COUNT function with comma at last in GcExcel.
• NullPointerException when Deleting the Sheet from workbook using GcExcel API.
• Workbook corrupted after saving using GcExcel API.
• GCExcel fails to create json from the excel file.