GrapeCity Documents for Excel, Java Edition 新版本发表

Released: Sep 3, 2021

4.2.1 中的更新

功能

  • Added support for exporting charts to image/HTML.
  • Enhanced Range.AutoFit(bool considerMergedCell).
  • Added dynamic array and workbook URI links to formula parser.

修补程序

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

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

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]Support...

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

Released: Dec 10, 2020

4.0.0 中的更新

功能

  • Added support for new PDF Form custom input types in Microsoft Excel Templates with advanced input and validation settings.
  • Added support for modifying, deleting and adding Pivot Charts in Excel documents.
  • Added support for iterative calculations in Excel documents.
  • Added support for adding barcodes while exporting to PDF, HTML or Image file formats.
  • Added support for cross-workbook formulas.
  • Added support for setting the default value for a template cell.
  • Added support for getting range...

Released: Oct 30, 2020

3.2.4 中的更新

修补程序

  • 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

3.2.1 中的更新

功能

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

Released: Jul 23, 2020

3.2.0 中的更新

功能

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