GrapeCity Documents for Excel, Java Edition

Programmatically generate, load, modify, and convert Excel .xlsx spreadsheets with ease in your Java applications. GrapeCity Documents for Excel (GcExcel) is a cross-platform high-speed, small-footprint spreadsheet API library that requires no dependencies on Excel. Applications using this spreadsheet API can be deployed to the cloud, Windows, Mac, or Linux. The powerful calculation engine and breadth of features means you'll never have to compromise on design or requirements.

At a glance:

Create, load, edit, and save Excel spreadsheets
Save to .XLSX, PDF, Image, HTML, CSV, and JSON
Based on the Excel Object Model with zero Excel dependencies
Deploy locally, inhouse or to Cloud including Azure and AWS
450+ Excel Functions and custom functions supported to perform complex calculations
Use the Templates to create custom Excel reports
2x+ faster and less memory than Apache POI

Based on the extensive Excel Object Model, the interface-based API allows you to import, calculate, query, generate, and export any spreadsheet scenario. With the VS Tools for Office-style API, you can create custom styles using the same elements as VS Tools for Office.

Using GcExcel, you can create full reports, sorted and filtered tables, sorted and filtered pivot tables, dashboard reports, add charts, slicers, sparklines, conditional formats, import and export Excel templates, convert spreadsheets to PDF and so much more.

GcExcel comes with a full-featured JavaScript Data viewer control (GcDataViewer).

If you'd like to remove the trial watermark and other trial limitations, please email [email protected] to request your 30-day evaluation key.

Complete Client-Server Spreadsheet Solution

You can optionally integrate GcExcel with the SpreadJS JavaScript spreadsheet as a client-side editor/viewer solution when working with Excel files for a complete client-server solution. View the complete supported features list here or download a trial from NPM or the SpreadJS page.

Resources

Directory	Description
gcexcel	Contains the latest GcExcel jar package and its dependency packages
Examples.Library	A collection of Java examples that help you learn and explore the API features
SpringBootDemo/SpringBoot+React	A source project that demonstrates how to use GcExcel Java with SpringBoot + React + Spread.Sheets
SpringBootDemo/SpringBoot+Angular2	A source project that demonstrates how to use GcExcel with SpringBoot + Angular2 + Spread.Sheets

目录	描述
gcexcel	包含最新的GcExcel以及所有依赖的jar包
Examples.Library	示例源码工程，帮助您学习和使用GcExcel Java的每一个API
SpringBootDemo/SpringBoot+React	演示如何在Spring Boot中使用GcExcel Java的源码工程，前端使用React+SpreadJS展示
SpringBootDemo/SpringBoot+Angular2	演示如何在Spring Boot中使用GcExcel Java的源码工程，前端使用Angular2+SpreadJS展示

6.2.1 Fixed

The legend of deleted series in chart are displayed in the exported Excel file.(DOCXLS-8452)
Doughnut charts is lost in the exported PDF file.(DOCXLS-8530)
The wrap position is incorrect when text contains "-" charactor in the exported PDF file.(DOCXLS-8535)
The result of the formula in the defined name is not updated correctly.(DOCXLS-8563)
The font is incorrect in the exported PDF file.(DOCXLS-8575)
The program gets stuck when processing template.(DOCXLS-8578)
The sparklines is incorrect in the exported PDF file.(DOCXLS-8586)
The program gets stuck when processing template.(DOCXLS-8598)
Exception is thrown on exporting PDF file when workbook contains sparklines.(DOCXLS-8603)
Exception is thrown on evaluating LAMBDA function.(DOCXLS-8620)
Exception is thrown on loading particular SSJSON file.(DOCXLS-8633)
Exception is thrown on loading the SSJSON made by customer.(DOCXLS-8654)
Some shape, picture and lines are lost in the exported PDF file.(DOCXLS-8685)
The cell text is not displayed completely in the exported PDF file.(DOCXLS-8686)
Exception is thrown on exporting PDF file when page footer contains special font.(DOCXLS-8692)
Exception is thrown on opening particular Excel file contains unsupported vml drawings.(DOCXLS-8711)
Diagonal lines disappeared in the exported Excel file.(DOCXLS-8713)
Incorrect cell value is returned when EnableCalculation = False.(DOCXLS-8725)
Performance downgradation on calling calculate method.(DOCXLS-8728)
Sheet name is lost after loading the SSJSON file.(DOCXLS-8735)
The pagination result is incorrect in the exported PDF file.(DOCXLS-8744)
Exception is thrown on loading SSJSON file after disable the calculate engine.(DOCXLS-8754)

6.2.0 Added

Set Vertical text direction in a Shape and Chart.(DOCXLS-6334)
Alignment options for Shape Text.(DOCXLS-6793)
Support header reference.(DOCXLS-8055)
Support for SpreadJS .sjs file format.(DOCXLS-8004)

Fixed

The result of XLOOKUP formula is incorrect.(DOCXLS-8542)

6.1.4 Fixed

The result of XIRR func is incorrect.(DOCXLS-8450)
InvalidFormulaException is thrown on opening an Excel file with XLOOKUP formula which refers to external Table formula.(DOCXLS-8478)
The result of reappling filter is incorrect after setting data source.(DOCXLS-8481)
The result of COUNTIFS func is incorrect.(DOCXLS-8483)
The result of dynamic array formula is incorrect when disabling calculation engine the enabling.(DOCXLS-8503)
StackOverFlowException is thrown on processing template when there are circular reference.(DOCXLS-8511)
The size of the QR code is incorrect in the exported PDF file.(DOCXLS-8513)
The multiple fields in the same template cell do not take effect in the exported report workbook.(DOCXLS-8514)
Performance issue on calculating SUMPRODUCT function.(DOCXLS-8516)
The data bar is lost in the exported PDF file.(DOCXLS-8524)
The result of WEEKNUM formula is incorrect.(DOCXLS-8531)
The shape disappears in the exported image after setting rotation.(DOCXLS-8540)
InvalidCastException is thrown on exporting PDF file.(DOCXLS-8542)

6.1.3 Fixed

Performance issue on processing Template file.(DOCXLS-7932)
Exception is thrown on calling IRange.ungroup() method.(DOCXLS-8355)
The result of DATEDIF formula is incorrect in JP culture.(DOCXLS-8378)
Some cell content is lost after processing Template file.(DOCXLS-8385)
Exception is thrown on copying worksheet contains form controls.(DOCXLS-8412)
After refreshing the Pivot Table, the exported SSJSON file size becomes very large.(DOCXLS-8443)
Performance issue on formula calculation.(DOCXLS-8455)
The row height is incorrect when cell has center across selection in the exported PDF file.(DOCXLS-8465)
The row height is incorrect when meger cell has not set wrap text.(DOCXLS-8473)
The transparency setting of shape is lost in the exported Excel file.(DOCXLS-8476)

6.1.2 Fixed

Performance downgradation on using PrintManager to exporting PDF file comparing to old version.(DOCXLS-7599)
The column count is incorrect in the exported PDF file when adding a shape with rotation.(DOCXLS-7724)
The result of cross workbook formula is incorrect in the export Excel file.(DOCXLS-8244)
The calculated item is not savd correctly when some fields are not visible.(DOCXLS-8249)
Performance issue on calling Workbook.calculate() method.(DOCXLS-8260)
The indent of the checkbox list is missing in the exported PDF file.(DOCXLS-8264)
KeyNotFoundException is thrown on exporting PDF file when workbook contains specific chart.(DOCXLS-8268)
The sheet content is incorrect in the exported PDF file.(DOCXLS-8269)
The texts containing line breaks are not output correctly in the PDF file.(DOCXLS-8273)
The custom number format is not applied to cell which has rich text in the exported PDF file.(DOCXLS-8278)
The length of certain shape is incorrect in the exported PDF file.(DOCXLS-8281)
Chart data is lost after merging workbooks containing chart and sheet reference formula.(DOCXLS-8282)
The conditional formattings of cells with fills are not output to PDF file correctly.(DOCXLS-8290)
The result of SUMIF function is incorrect.(DOCXLS-8306)
The stacked series is lost when category axis is date type in the exported PDF file.(DOCXLS-8308)
Exception is thrown on loading some irregular Excel file.(DOCXLS-8336)
Exception is thrown on calling IRange.clear() method.(DOCXLS-8339)
The exported Excel report file is incorrect after processing template.(DOCXLS-8346)
OutOfMemoryError is thrown on refreshing pivot table.(DOCXLS-8349)
Exception is thrown on saving PDF file when the original workbook contains abnormal data.(DOCXLS-8356)
The result of IRange.getUsedRange() method is incorrect.(DOCXLS-8358)

6.1.1 Fixed

Performance issue on calling IRange.merge() method and exporting to Excel file.(DOCXLS-6001)
Exception is thrown on loading particular SSJSON file.(DOCXLS-8071)
The result is incorrect of data binding when the binding path contains the index of array.(DOCXLS-8074)
The tick marks units of charts in the exported PDF file are smaller than ones in Excel file.(DOCXLS-8089)
The margin setting is incorrect in the exported Excel file after loading the SSJSON file.(DOCXLS-8092)
Performance issue on calling calculate method when workbook contains LOOKUP functions.(DOCXLS-8097)
Filter is lost in the exported SSJSON file.(DOCXLS-8115)
The column width of row header is lost in the exported SSJSON file.(DOCXLS-8121)
The exported Excel file is corrupted when the original file contains group shape.(DOCXLS-8125)
The series is incorrect in the exported Excel file when the chart contains references to defined names of other worksheet.(DOCXLS-8139)
The result of the formula is incorrect when formula contains defined name which has volatile function.(DOCXLS-8142)
The result of OR function is incorrect.(DOCXLS-8144)
Unexpected fore color style is in the exported SSJSON file.(DOCXLS-8149)
Performance issue on loading sjs file.(DOCXLS-8152)
The number format is changed in the exported SSJSON file.(DOCXLS-8156)
Some content is lost on loading the particular SSJSON file.(DOCXLS-8190)
The result of VLOOKUP function is incorrect.(DOCXLS-8193)
The cellpadding setting takes no effect on the exported PDF file when cell contains celltype.(DOCXLS-8207)
The fore color is incorrect when cell has number format with colors in the exported SSJSON file.(DOCXLS-8218)
Exception is thrown on loading the particular Excel file then calling ToJson method.(DOCXLS-8219)
Performance issue on calling ToJson method.(DOCXLS-8221)
The drop-down box is lost in the exported SSJSON file.(DOCXLS-8224)
Exception is thrown on loading particular Excel file which contains invalid content.(DOCXLS-8234)
Exception is thrown on exporting Excel file after loading the SSJSON file contains abnormal chart title.(DOCXLS-8237)

6.1.0 Added

Export options in ToImage() method.(DOCXLS-5481)
Copy/move multiple sheets at once.(DOCXLS-6332)
Support for XLTX File Format.(DOCXLS-6343)
Support Form Controls on SpreadJS JSON I/O.(DOCXLS-6872)
Support for allowResize property on SpreadJS JSON I/O.(DOCXLS-6875)

Fixed

Exception is thrown on adding calculated items on Pivot Field.(DOCXLS-7800)
The performance of Workbook.fromJson() method is bad when JSON contains stripped style in big tables.(DOCXLS-7892)
The calculating performance is bad when sheet contains SUMPRODUCT formula.(DOCXLS-7902)
The axis position of chart is incorrect in the exported PDF file.(DOCXLS-7914)
Exception is thrown on loading particular Excel file with chart.(DOCXLS-7922)
The calculated formula of table column is lost in the exported SSJSON file.(DOCXLS-7930)
3D chart is missing in the exported PDF file.(DOCXLS-7984)
The result of MATCH function is incorrect.(DOCXLS-8013)
The result of COUNT function is incorrect.(DOCXLS-8023)
The cell value is not overflowed in the exported PDF file when cell value type is text and has customer number format.(DOCXLS-8025)
The result of some functions is incorrect when they refer to 3D reference.(DOCXLS-8048)
Exception is thrown on exporting PDF file when combo chart's category axis has null value in the workbook.(DOCXLS-8063)

6.0.6 Fixed

Image size is not adjusted with the column width when setting BestFitColumns as true when exporting PDF file.(DOCXLS-7782)
NullReferenceException is thrown on calling the PrintManager.Paginate() method.(DOCXLS-7808)
The text is not wrapped in the exported PDF file.(DOCXLS-7828)
Cell notes lost after saving workbook to a new Excel file.(DOCXLS-7831)
Data binding does not support special symbols.(DOCXLS-7837)
Table filters are not working properly after fetching Table JSON.(DOCXLS-7843)
Table and Slicers are cleared after fetching the table JSON.(DOCXLS-7844)
Exception is thrown on setting particular calculated field formula for Pivot Table.(DOCXLS-7854)
The application gets hanged on loading the XLSX file.(DOCXLS-7856)
The time validation info is wrong in the SSJSON file exported by GcExcel.(DOCXLS-7861)
Bad performance of IRange.RowHeight setter.(DOCXLS-7866)
When the cell with incorrect formula is copied to another workbook, the workbook is corrupted.(DOCXLS-7871)
Defined names are lost in the exported SSJSON file.(DOCXLS-7873)
AutoParse does not take affect when using data binding.(DOCXLS-7874)
Connector shapes are lost in the exported PDF file.(DOCXLS-7884)
The text style is lost in the copied shape when shape has linked text.(DOCXLS-7885)
The chart plot area becomes smaller in the exported PDF file when chart is a grouped item.(DOCXLS-7889)

6.0.5 Fixed

Exception is thrown on calling calculated or save method when workbook contains dynamic array formulas.(DOCXLS-7404)
The error type of formulas are different from Excel.(DOCXLS-7593)
The condition format result in the exported PDF file is different Excel.(DOCXLS-7631)
The table style is incorrect in the exported Excel file after processing template.(DOCXLS-7632)
Exception is thrown on calling fromJson method.(DOCXLS-7641)
Lambda function does not return correct result when getting values.(DOCXLS-7649)
Exception is thrown on saving workbook when it contains corrupted ActiveX controls.(DOCXLS-7677)
Sorting with blank rows is not worked correctly.(DOCXLS-7681)
Exception is thrown on exporting PDF file through PrintManager when workbook contains hidden column.(DOCXLS-7716)
Exception is thrown on calling IPivotTable.refresh() method.(DOCXLS-7723)
The text layout is different from the Excel file and the exported PDF file.(DOCXLS-7738)
The character is not escaped in the exported JSON file.(DOCXLS-7746)
The link color of hyperlink is lost in the exported JSON file.(DOCXLS-7755)
Exception is thrown on loading particular JSON file exported by GcExcel.(DOCXLS-7756)
The column width is inconsistent in different pages in the exported PDF file.(DOCXLS-7757)

6.0.4 Added

Option to control if export shared formula in SSJSON file.(DOCXLS-7477)

Fixed

Exception is thrown on loading particular SSJSON file contains circular reference.(DOCXLS-7377)
The calculated result is incorrect from Excel.(DOCXLS-7472)
The result of IFNA function is incorrect from Excel.(DOCXLS-7537)
The celltype in copied range is not cleared when copying range from other worksheet.(DOCXLS-7563)
The column which width is 0 is invisible in the SpreadJS designer.(DOCXLS-7565)
The shape is lost in the exported Excel and PDF file after setting the shape position.(DOCXLS-7598)
Performance downgradation on using PrintManager to exporting PDF file comparing to old version.(DOCXLS-7599)
The transparency effect in the shape text is lost in the exported PDF file.(DOCXLS-7604)
The rotation of the shape is counterclockwise in the exported PDF file.(DOCXLS-7606)
The protection setting is lost in the exported SSJSON file.(DOCXLS-7614)
Stack overflow exception is thrown on calling calculate() method.(DOCXLS-7617)
The exported Excel file is corrupted when original file contains invalid Pivot Table data.(DOCXLS-7633)
IllegalArguments exception is thrown on loading particular Excel file.(DOCXLS-7634)

6.0.3 Fixed

The calculation result is incorrect when the formula is array formula.(DOCXLS-4598)
The number format changes from "General" to "Custom" after loading and exporting SSJSON file.(DOCXLS-6854)
The height of plot area and the tick lables are incorrect in the exported PDF file.(DOCXLS-7076)
Exception is thrown on inserting rows when worksheet contains data validation.(DOCXLS-7364)
Exception is thrown on loading particular SSJSON file contains unexpected binding path content.(DOCXLS-7365)
Exception is thrown on loading then saving to another Excel file.(DOCXLS-7376)
The style of chart's trendline is incorrect in the exported PDF file.(DOCXLS-7381)
The arrow mark is missed in the exported PDF file.(DOCXLS-7383)
Exception is thrown on loading particular SSJSON file.(DOCXLS-7386)
The table formula is lost when loading particular SSJSON file.(DOCXLS-7401)
The checkbox format is different from the SpreadJS designer and exported PDF file.(DOCXLS-7412)
Exception is thrown on loading Excel file contains external reference.(DOCXLS-7429)
Unexpected cell content is shown in the exported PDF file.(DOCXLS-7430)
Exception is thrown on acessing group shape's children using iterator.(DOCXLS-7434)
The "colHeaderVisible" setting is lost after loading the original SSJSON file then exporting to another.(DOCXLS-7435)
Exception is thrown on adding validation which contains INDIRECT function.(DOCXLS-7442)
Exception is thrown on loading irregular Excel file then exporting to SSJSON file.(DOCXLS-7444)
The transparency setting of the text in the shape is lost in the exported PDF file.(DOCXLS-7471)
The underline is lost in the exported PDF file.(DOCXLS-7476)
Exception is thrown on setting Hyperlink funtion in a copied worksheet.(DOCXLS-7510)

6.0.2 Fixed

The marker size, data label and series line color chart in incorrect in the exported PDF file.(DOCXLS-7229)
Some row heights are incorrect after processing template.(DOCXLS-7268)
The linked cell text color becomes white after loading the SSJSON file then exporting to SSJSON file.(DOCXLS-7293)
Exception is thrown on saving Excel file when the file name has only one character.(DOCXLS-7314)
The interface Workbook.SetLicenseFile is lost.(DOCXLS-7315)

6.0.1 Fixed

Performance issue when using table bindings with 500,000 rows data.(DOCXLS-6781)
The exported Excel file is corrupted after processing template.(DOCXLS-6826)
The data validation lost after loading the SSJSON file when the applied range is whole column.(DOCXLS-7082)
Exception is thrown on exporting PDF file when using data binding.(DOCXLS-7094)
PageSetup.Zoom does not take effect on barcode in the exported PDF file.(DOCXLS-7095)
"Swiss 721 BT" font is not shown correctly in the exported PDF file.(DOCXLS-7102)
Print titles settings are lost in the generated report after processing template.(DOCXLS-7126)
The formula result is different from Excel.(DOCXLS-7168)
Exception is thrown on loading particular XLSX file contains invalid data.(DOCXLS-7171)
Exception is thrown on loading SSJSON file then calling Workbook.ToJson() method when JSON contains dupicated named styles.(DOCXLS-7174)
Exception is thrown on calling processing template when data field name contains number.(DOCXLS-7194)
PageSetup.CustomPaperSize method did not working.(DOCXLS-7195)
The DateTimePicker cell button cannot be deleted when deleting row.(DOCXLS-7199)
The cell text is incorrect after loading the Excel file contains rich text.(DOCXLS-7200)
The applied range of conditional formatting is incorrect after coping cell.(DOCXLS-7214)
Exception is thrown on rendering HTML when workbook contains Pivot Table.(DOCXLS-7219)
Exception is thrown on processing template when sheet contains defined names.(DOCXLS-7220)
The calculation result of VARP function differs from Excel.(DOCXLS-7221)
Exception is thrown on loading particular XLSX file contains invalid data.(DOCXLS-7223)

6.0.0 Breaking changes

Changed XlsxOpenOptions.DoNotAutofitAfterOpened to XlsxOpenOptions.DoNotAutoFitAfterOpened(F in caps).(DOCXLS-6428)

Added

Support for new Lambda function including help functions.(DOCXLS-3667)
Paginated Spreadsheet reports new enhancements.(DOCXLS-3829)
New text and array manipulation Excel functions.(DOCXLS-5711)
Support 'RowColumnStates' in JSON I/O.(DOCXLS-5828)
Add shape text with range reference or defined name.(DOCXLS-5829)
Add shape/picture to cell/cell range using direct method.(DOCXLS-6182)
Add option to control Auto Fit.(DOCXLS-6228)
Support cross workbook formula - 'externalReference' in JSON I/O.(DOCXLS-6243)
Get used range in selected area.(DOCXLS-6330)
Support page number and page count for groups in template pagination.(DOCXLS-6374)
Keep original template and return the report workbook instance.(DOCXLS-6417)
Process specific template worksheets in template language.(DOCXLS-6418)
Excel workbook size optimization through save options.(DOCXLS-6441)
Range intersection, union and offset.(DOCXLS-6487)
GcExcel Java now targets JDK 8.(DOCXLS-6650)
Support for 'allSheetsListVisible' field in JSON I/O.(DOCXLS-6696)

5.2.5 Fixed

The column width of exported PDF is inconsistent with SpreadJS.(DOCXLS-6857)
IndexOutOfRangeException is thrown on calling Calculate method twice for a workbook.(DOCXLS-6873)
Performance issue in opening Excel file and saving to JSON when workbook contains lots of comments.(DOCXLS-6886)
The exported report is incorrect when sheet name is bind to the datafield with DataSet as datasource.(DOCXLS-6889)
The layout is incorrect on call the IPivotTable.refresh() method.(DOCXLS-6890)
Field name is missed in the exported report when using the Range and Group feature of template at the same time.(DOCXLS-6892)
The border is lost in the exported SSJSON file.(DOCXLS-6896)
Loading the specific SSJSON file, some node would be discarded.(DOCXLS-6902)
Template is not processed correctly.(DOCXLS-6909)
Table formula is not updated when using template.(DOCXLS-6916)
The exported SSJSON file is incorrect comparing with the original one.(DOCXLS-6970)
Performance issue with Add function in dynamic array.(DOCXLS-6979)
Exception is thrown on loading Excel file which contains irregualr content.(DOCXLS-6981)
Exception is thrown on loading particular SSJSON file with Pivot Table.(DOCXLS-6982)
InvalidOperationException is thrown on getting cell value twice from a workbook.(DOCXLS-6988)
The number format is missed when data source contains date value.(DOCXLS-6996)
The row height is incorrect after calling autofit method.(DOCXLS-7005)
The cell value is incorrect when workbook contains cross workbook reference.(DOCXLS-7008)
Exception is thrown on loading particular SSJSON file contains conditional format with entire column reference.(DOCXLS-7024)
The SUMIF function result is incorrect.(DOCXLS-7032)

5.2.4 Fixed

Incorrect results with iterative calculations after loading the particular Excel file.(DOCXLS-6444)
When the url wrapped in a cell is exported to pdf, it breaks in the wrong position.(DOCXLS-6547)
Performance issue when setting the hidden property of the row.(DOCXLS-6588)
CharSet of the QR code is missed in the exported pdf file.(DOCXLS-6765)
NullPointerException is thrown on setting cell values in worksheet which contains iterative calculation.(DOCXLS-6779)
Exception is thrown on calculating MIDB function in CJK culture.(DOCXLS-6791)
The hidden rows are unhidden after loading the SSJSON file.(DOCXLS-6806)
Bad performance when loading SSJSON file contains lots of named styles.(DOCXLS-6821)
Print area is lost after loading the ssjson file.(DOCXLS-6824)
VBA project digital signature is lost in the exported Excel file.(DOCXLS-6831)
The style is incorrect after calling the copy() method.(DOCXLS-6853)
The column width of exported PDF is inconsistent with SpreadJS.(DOCXLS-6857)
The path in external link is not encoded correctly.(DOCXLS-6862)
The program would not exit if the repeat area is large when exporting PDF file.(DOCXLS-6866)
The count of Pivot items is incorrect.(DOCXLS-6867)
Exception is thrown on loading particular SSJSON file contains #SPILL!.(DOCXLS-6874)
IndexOutOfRangeException is thrown on copying a sheet from one workbook to another.(DOCXLS-6878)
Merged cells unmerged after processing the template.(DOCXLS-6882)
When cells with long wrapped texts are autofitted and exported to PDF file, the row heights are not adjusted.(DOCXLS-6883)
The position of barcode is incorrect in the exported PDF file.(DOCXLS-6884)
Print range and margin settings are lost in the exported report when pagination mode is on.(DOCXLS-6888)
Exception is thrown on exporting SSJSON file when workbook contains particular defined names.(DOCXLS-6901)

5.2.3 Fixed

Performance issue when exporting the Excel file to JSON when workbook contains lots of table with striped styles.(DOCXLS-5242)
The result of IPivotItem.Visible is incorrect when the option "select multiple items" is checked.(DOCXLS-6385)
The result of INDEX function is not spilled correctly.(DOCXLS-6483)
When Excel file including "Add-ins" is loaded and saved, "Add-ins" is lost.(DOCXLS-6535)
The cell value is not formatted correctly in the exported HTML file.(DOCXLS-6555)
An OutOfMemoryError occurs when exporting specific Excel file to image.(DOCXLS-6577)
There would be #Ref error when the sheet name starts with number.(DOCXLS-6580)
The file is bigger after exported.(DOCXLS-6595)
Performance issue when calculating lots of formulas.(DOCXLS-6597)
The result of get hidden columns is incorrect when the Excel is exported by other product.(DOCXLS-6639)
ArrayIndexOutOfBoundsException is thrown on exporting Excel file.(DOCXLS-6640)
The EUDC font could not be displayed correctly in the exported PDF file.(DOCXLS-6670)
The picture is lost in the exported PDF file.(DOCXLS-6671)
Json parse error is thrown when the row count or column count is string in conditional format.(DOCXLS-6679)
InvalidFormulaException is thrown on refreshing data in the PivotTable.(DOCXLS-6697)
The position of the bent connector's arrow is incorrect in the exported image file.(DOCXLS-6699)
"This Year" setting in conditional format is not supported after loading JSON file.(DOCXLS-6712)
Floating object is lost in the exported JSON file.(DOCXLS-6721)
The layout of databar is incorrect in the exported HTML file.(DOCXLS-6725)
Performance issue when exporting to PDF file when condition format contains whole column reference.(DOCXLS-6730)
The cell type on table column is lost after loading the JSON file.(DOCXLS-6741)
Exception is thrown on loading particular Excel file.(DOCXLS-6748)

5.2.2 Fixed

NumberFormatException is thrown on loading the particular excel file.(DOCXLS-6134)
Bad Performance when exporting PDF.(DOCXLS-6428)
Exception is thrown on deleting the series collection of chart.(DOCXLS-6442)
Font color changed when importing SSJSON file to workbook and saving back to Excel file.(DOCXLS-6455)
The result of INDEX function is not spilled correctly.(DOCXLS-6483)
ArgumentOutOfRange exception is thrown on copying a sheet from one workbook to another.(DOCXLS-6485)
NumberFormatException is thrown on loading the particular excel file.(DOCXLS-6489)
Z-order of pictures is changed when loading SSJSON file and exporting to Excel file.(DOCXLS-6496)
The result of IRange.Text is incorrect when showzero is false.(DOCXLS-6525)
Invalid key data exception is thrown when adding jakarta.json dependency.(DOCXLS-6545)
Exception is thrown on loading SSJSON file when conditional format contains gradient color.(DOCXLS-6556)
The exported Excel file is corrupted when calling IRange.sort() method.(DOCXLS-6565)
Twill pattern of conditional format would be lost after loading SSJSON file.(DOCXLS-6578)
Grouped shapes do not move with cells.(DOCXLS-6584)
Exception is thrown on loading particular Excel file.(DOCXLS-6636)
Exception is thrown on exporting to PDF file when workbook contains charts.(DOCXLS-6638)

5.2.1 Fixed

The results of IWorksheet.FreezeColumn/FreezeRow are incorrect.(DOCXLS-6299)
Exception is thrown on processing template if the data source name is number and Japanese.(DOCXLS-6300)
The result of Search function is incorrect when it contains the wild char "*".(DOCXLS-6361)
Poor performance and high memory footprint when loading particular Excel file.(DOCXLS-6362)
The exported Excel file is corrupted when workbook contains bubble chart.(DOCXLS-6372)
The slicer in the exported ssjson file is different from the original JSON file.(DOCXLS-6384)
The layout and the data field value of pivot table in exported XLSX file is incorrect.(DOCXLS-6406)
The data field result of pivot table is not filterd in the exported XLSX file.(DOCXLS-6412)
The result of INames.Contains() is incorrect.(DOCXLS-6429)
Exception is thrown on loading SSJSON file when font name contains unexpected characters.(DOCXLS-6436)
Repeated loading and saving of an existing file corrupts the saved Excel file.(DOCXLS-6470)

5.2.0 Added

New API to add Excel Form Controls.(DOCXLS-2532)
Support for CASCADESPARKLINE formula.(DOCXLS-3562)
Define Paginated Templates in spreadsheets (with GcExcel Templates).(DOCXLS-3829)
Support for Chart Data Table.(DOCXLS-4438)
Support for LET function.(DOCXLS-5185)
GetPivotData Formula supports spilled data.(DOCXLS-5390)
Add Calculated Item in Pivot Table.(DOCXLS-5437)
Get accurate range boundary.(DOCXLS-5473)
Support JSON as DataSource in data binding.(DOCXLS-5499)
IsVolatile property support in Custom function.(DOCXLS-5714)
Debug mode in GcExcel Templates.(DOCXLS-5715)
Debug better with additional details in InvalidFormulaException.(DOCXLS-5744)
Support for adding and rendering SVG image.(DOCXLS-5817)

5.1.5 Fixed

The performance of opening particular Excel file need to be optimized.(DOCXLS-6038)
It takes a long time to execute calculating when workbook contains AverageIf formula.(DOCXLS-6055)
The calculation result of MIDB formula is incorrect in CJK culture.(DOCXLS-6112)
The IMPOWER formula result is incorrect.(DOCXLS-6173)
Exception is thrown on calling Workbook.toJson() method when workbook contains external reference.(DOCXLS-6177)
Exception is thrown on loading particular SSJSON.(DOCXLS-6189)
The calculation result of SUMIFS formula is inconsistent with Excel.(DOCXLS-6197)
Exception is thrown on calling IRange.fromJson() method.(DOCXLS-6199)
The calculation result of AGGREGATE formula is incorrect.(DOCXLS-6209)
The allowDynamicArray setting is lost in the exported SSJSON file.(DOCXLS-6210)
One static row is missing after processing the template using GcExcel.(DOCXLS-6212)
The ignore blank setting of DataValidation is changed after loading the SSJSON file.(DOCXLS-6217)

5.1.4 Fixed

The rowheight is incorrect after copying worksheet.(DOCXLS-5845)
The result of SEARCHB func is different from Excel in Chinese culture.(DOCXLS-5994)
The result of autoFit is bad in the exported PDF file.(DOCXLS-6028)
Some borders are missing in the exported image after loading particular JSON file.(DOCXLS-6097)
Exception is thrown on drawing Pivot Table to PDF file.(DOCXLS-6110)
IllegalArgumentException is thrown on exporting image when some fonts are missed in system.(DOCXLS-6123)
The texts in the merged cell near the page boundary are not output to PDF file.(DOCXLS-6137)
ArgumentException is thrown on saving Excel file when workbook contains some special characters.(DOCXLS-6138)
Invalid Argument exception is thrown on loading csv from URL stream.(DOCXLS-6142)
The last cell of column is incorrect when a column is deleted.(DOCXLS-6144)
The rows are hidden in the exported JSON file.(DOCXLS-6153)
NullReferenceException is thrown on saving to Excecl file.(DOCXLS-6155)
IllegalArgumentException is thrown on loading particular JSON file.(DOCXLS-6158)
The texts in merged cell are not exported in the PDF file.(DOCXLS-6159)
Exception is thrown on saving to PDF file if workbook contains corrupted image.(DOCXLS-6164)
ArgumentException is thrown on loading a particular JSON file contains different slicer with same name.(DOCXLS-6166)
IndexOutOfRangeException is thrown on getting some cell's value.(DOCXLS-6168)
The exported Excel file is corrupted after refreshing the Pivot Table.(DOCXLS-6174)

5.1.3 Fixed

The color of cell font is incorrect in exported JSON file.(DOCXLS-5945）
Platform dependent characters are incorrect in the exported PDF file.(DOCXLS-5971）
NullReferenceException is thrown on exporting PDF file.(DOCXLS-5996）
The performance of inserting lots of pictures is bad.(DOCXLS-6009)
The value of formula N is incorrect.(DOCXLS-6010)
The exported xlsm file is corrupted after deleting some sheet which contains external reference.(DOCXLS-6012)
Setting IWorksheetView.ScrollColumn/ScrollRow properties on a worksheet which has freeze pane corrupts the saved Exel file.(DOCXLS-6026）
Series lines in a chart are not exported to PDF file.(DOCXLS-6030)
The zoom scale of the worksheet changes from 90% to 100%.(DOCXLS-6042)
The exported Excel file is corrupted when the rows are deleted in the worksheet which has freeze pane.(DOCXLS-6054)
Using copy method to copy range will throw System.NullReferenceException if pasteType value is NumberFormats.(DOCXLS-6056)
Exception is thrown on opening the Excel file exported by GcExcel.(DOCXLS-6066)
The cell value is disordered after calling IRange.Clear() method when workbook contains phonetic text.(DOCXLS-6083)

5.1.2 Fixed

The chart in the exported ssjson file is different from the ssjson exported by SpreadJS.(DOCXLS-5753）
Data binding does not support multi-layer level.(DOCXLS-5875）
The result of IRange.toImage() is incorrect.(DOCXLS-5884）
The exported xlsx file is corrupted when copying range from one sheet to another.(DOCXLS-5888）
[Template Language]The generated xlsx file is corrupted when template file has multiple sheets.(DOCXLS-5889)
Some cell values are #REF! after using data binding.(DOCXLS-5913）
The size of exported chart image is smaller than the original chart in MSExcel.(DOCXLS-5938)
The exported xlsx file is corrupted when comment contains special characters.(DOCXLS-5942）
The cell value is #REF! when calculating SUMIF function.(DOCXLS-5944)
The position of chart's tick labels are incorrect in the exported xlsx file.(DOCXLS-5946)
The rowcount is incorrect after loading CSV file from stream.(DOCXLS-5951)
Performance degradation comparing with old versions.(DOCXLS-5952)
The cell content is incorrect when the alignment is distributed and indent in exported PDF file.(DOCXLS-5953)
The exported image is corrupted when the range is entire column/row.(DOCXLS-5990)

5.1.1 Fixed

[Template language]The layout is incorrect when rendering list of data with dynamic object in both right and down direction.(DOCXLS-4727)
When shapes with text are exported to the PDF file, shapes are not the same as Excel file.(DOCXLS-5723)
Illegal access warning occurs when using JDK9 or above.(DOCXLS-5752)
ArgumentOutOfRangeException or NullReferenceException is thrown on using GcExcel API in multi-threaded environment when there's TEXT function in workbook.(DOCXLS-5784)
The picture's position is incorrect in the exporting PDF file when some column is hidden.(DOCXLS-5798)
Some borders are lost in the exported Excel file after loading SSJSON file.(DOCXLS-5813)
The fontsize of cell is incorrect after loading the JSON file.(DOCXLS-5818)
NullPointerException is thrown on loading JSON file.(DOCXLS-5821)
The bottom border is lost in the exported PDF file.(DOCXLS-5838)
The tick labels' orientation of chart is changed in the exported Excel file.(DOCXLS-5840)
[Template language]Chart is incorrect after processing template in the exported Excel file.(DOCXLS-5844)
#REF! error occurs when calculating OFFSET function.(DOCXLS-5847)
NullPointerException is thrown on calling IPivotTable.refresh() method.(DOCXLS-5850)
The first space of cell text is not preserved in the exported Excel file if the cell value is calculated by formula.(DOCXLS-5851)
The result of COUNT function is incorrect.(DOCXLS-5859)
The exported Excel file is corrupted after processing template.(DOCXLS-5876)
The program would be stuck when exporting to JSON when there's filter in workbook.(DOCXLS-5879)
ArrayIndexOutOfBoundsException is thrown on calling Workbook.toJson() method.(DOCXLS-5883)
The exported Excel file is corrupted after loading specific xlsx file containing chart.(DOCXLS-5887)

5.1.0 Added

[Pivot Table] Specify 'ShowValuesAs' Option for 'Values' Field.(DOCXLS-738)
Add Numbers Fit Mode of overflow/mask.(DOCXLS-3696)
Modify Password of Excel Documents.(DOCXLS-4076)
[Pivot Table] Support for Calculated Field.(DOCXLS-4211)
Support JSON data source for template language.(DOCXLS-4359)
Support for "Show #N/A as an empty cell" in Chart.(DOCXLS-4442)
Convert Table to Range.(DOCXLS-4601)
Support CELL function.(DOCXLS-4645)
CSV Custom Parser.(DOCXLS-5162)
Support for Pivot table views (JSON I/O).(DOCXLS-5221)
Import Data Function to Import Table, Range, or Worksheet from Excel Files.(DOCXLS-5276)
Support for TableSheet (JSON I/O).(DOCXLS-5487)

Fixed

Converting the imported Excel to Json breaks all formulas in it.(DOCXLS-3840)
[Template language]Out of memory exception is thrown on using template in multi-thread.(DOCXLS-4449)
[Template language]The layout is incorrect in the exported xlsx file when using template with cross table.(DOCXLS-4756)
[Template language]The result of sum function is incorrect in the exported xlsx file.(DOCXLS-4827)
[Template language]The cell values are not expected in the exported Excel file.(DOCXLS-4888)
[Template language]The IF formula is lost in the exported xlsx file.(DOCXLS-5224)
[Template language]The formula is not expanded correctly in exported xlsx file.(DOCXLS-5239)
IndexOutOfRangeException is thrown on exporting radar chart to PDF file.(DOCXLS-5262)
[Template language]The result of sum function is incorrect in the exported xlsx file.(DOCXLS-5485)
The legend of series is not shown in the exported PDF file if the datapoints of the series are empty.(DOCXLS-5569)
InvalidFormulaException is thrown on creating table when there is "'" in the table column's name.(DOCXLS-5690)
Extra characters are exported in data validation in the exported JSON file.(DOCXLS-5734)
NullReferenceException is thrown on setting series formula which contains bubble size info.(DOCXLS-5751)
The layout of checkbox list is incorrect in the exported PDF file.(DOCXLS-5754)

5.0.5 Fixed

Bad performance when calculating formulas in a specific Excel file.(DOCXLS-5501)
The position of the frozen pane is changed after JSON I/O.(DOCXLS-5525)
The layout of checkbox list in the exported pdf file is different from SpreadJS designer.(DOCXLS-5544)
Performance is bad when calling method toJSON with particular Excel file.(DOCXLS-5564)
When the chart is exported to PDF, the pattern fill of the legend symbol is not correct.(DOCXLS-5567)
The layout of the list object in the exporting pdf is not correct.(DOCXLS-5590)
The checkbox is unchecked when the cell value is set.(DOCXLS-5624)
Open csv file with double quote, the records would be lost.(DOCXLS-5639)
ParseException is thrown on opening particular excel file with threaed comment.(DOCXLS-5643)
Exception is thrown on setting Workbook.Culture property when workbook contains Hyperlink named style.(DOCXLS-5649)
Exception is throws when opening loading specific JSON file.(DOCXLS-5656)
Exception is thrown on calling Workbook.SetLicenseKey method in multi-thread.(DOCXLS-5660)
The result of IRange.LastColumn is not correct in some Excel file.(DOCXLS-5668)
The plot area of chart is not updated in the exported pdf file when enabling/disabling calculation.(DOCXLS-5682)
Custom named style are not exported to JSON or Excel file if it is not used in any range.(DOCXLS-5683)
Font "Noto Sans JP" is not shown correctly in the exported pdf.(DOCXLS-5701)
Exception is thrown on opening an Excel file.(DOCXLS-5704)
Exception is thrown on opening an Excel file with ActiveX control.(DOCXLS-5706)
NullPointerException is thrown on calling Calculate method after loading JSON file.(DOCXLS-5709)

5.0.4 Fixed

[Template Language] Cell style is incorrect after calling IWorkbook.ProcessTemplate().(DOCXLS-5206)
IndexOutOfRangeException is thrown on exporting pdf file when sheet contains hidden columns.(DOCXLS-5263)
Column width is changed when importing JSON file exported by SpreadJS.(DOCXLS-5314)
IndexOutOfBoundsException is thrown on exporting JSON file for specific Excel file.(DOCXLS-5377)
Exception is thrown on saving an Excel file exported by GcExcel.(DOCXLS-5393)
The exported Excel file is corrupted when it contains specific linked objects.(DOCXLS-5402)
The exported Excel file is corrupted when it contains dynamic array formulas.(DOCXLS-5409)
NullReferenceException is thrown on opening some excel files with waterfall chart.(DOCXLS-5418)
Font in shape is changed in exported Excel file.(DOCXLS-5422)
The linked picture does not change along with the refered range.(DOCXLS-5439)
The tab of active sheet is not displayed in the tab strip.(DOCXLS-5441)
The formula value is incorrect in the exported Excel file.(DOCXLS-5444)
The exported Excel file is corrupted when copying range with dynamic array formula.(DOCXLS-5459)
The row height changes after inserting rows.(DOCXLS-5465)
Format settings are not copied when copying entire rows contains merge area.(DOCXLS-5472)
Formula result is different from Excel in Chinese culture.(DOCXLS-5488)
NullPointerException is thrown on calling toJson method for user specific excel.(DOCXLS-5523)
The result of function "=NOW()" is not precise when time goes by.(DOCXLS-5524)
When the BarChart is exported to PDF, the order of the legends is reversed.(DOCXLS-5536)
XMLStreamException is thrown on saving Excel to JSON file.(DOCXLS-5540)
An error occurred while copying sheet with threaded comment.(DOCXLS-5546)
Binding result is incorrect when using bigdecimal as data source.(DOCXLS-5547)
Particular headers and footers are not output to PDF correctly.(DOCXLS-5554)
The style is incorrect in the exported PDF file when copying sheet with conditional format.(DOCXLS-5557)
Exception of index out of range is thrown on exporting PDF file if the workbook contains specific conditional format.(DOCXLS-5588)
LET function changed in the exported Excel file.(DOCXLS-5593)
InvalidFormulaException is thrown on opening a workbook with specific charts.(DOCXLS-5596)
The result of formula calculation is different with Excel.(DOCXLS-5598)
Exception is thrown on exporting chart to image.(DOCXLS-5626)

5.0.3 Breaking changes

Support option to control whether treat BigDecimal as double for cell value.(DOCXLS-5364)

Added

Add ability to add filter without condition using IRange.AutoFilter().(DOCXLS-2435)
Add options to control if serialize workbook to JSON without worksheets.(DOCXLS-5357)

Fixed

Formulas are lost in exported Excel file.(DOCXLS-5371)
ToJson method generates invalid json file when Excel file having multi-line comments.(DOCXLS-5384)
Cell value is incorrect when evaluating formula using GcExcel.(DOCXLS-5385)
The cell style is incorrect in exported Excel file after loading the JSON exported by SpreadJS.(DOCXLS-5389)
Exception is thrown on calling workbook.toJson() method.(DOCXLS-5398)
Performance degradation when evaluating values from the particular Excel file.(DOCXLS-5400)
The formula result of SUBSTITUTE is incorrect.(DOCXLS-5408)

5.0.2 Fixed

Default column width changes when exporting to Excel file.(DOCXLS-5161)
The method IRange.Autofit() would not take effect when adjacent cell is set wrapping.(DOCXLS-5264)
Exception is thrown on saving Excel file when the formula2 in data validation is empty.(DOCXLS-5266)
Exception is thrown on saving PDF file when workbook contains specific chart.(DOCXLS-5274)
InvalidFormulaException is thrown on opening particular Excel file contains special characters in table column.(DOCXLS-5277)
OutOfMemory exception is thrown on exporting the Excel file with shape object to HTML.(DOCXLS-5278)
It takes a long time on calling Workbook.ToJson() method.(DOCXLS-5302)
Some KR demo resources are missing.(DOCXLS-5317)
Exception is thrown on loading the JSON file exported by GcExcel.(DOCXLS-5321)
Exception is thrown on exporting PDF file when workbook contains specific Pivit Table.(DOCXLS-5325)
StackOverFlow exception is thrown on opening specific Excel file.(DOCXLS-5328)
Shape border is changed in the exported HTML file when resaving it.(DOCXLS-5335)
Temporary file is created after opening the Excel file using GcExcel API.(DOCXLS-5396)

5.0.1 Fixed

The alignment style is lost in the exported JSON file.(DOCXLS-5198)
The formula is incorrect in the exported Excel file when using template language to generate report.(DOCXLS-5205)
Unexpected borders are shown in exported image.(DOCXLS-5209)
FormatRows setting of worksheet protection is lost in the exported Excel file.(DOCXLS-5213)
System.AggregateException is thrown on saving Excel file to multiple PDF files in parallel.(DOCXLS-5222)
Hidden rows are shown in the exported JSON file.(DOCXLS-5225)
IndexOutOfRangeException is thrown on calling 'Workbook.Calculate()' method.(DOCXLS-5227)
The cell color is incorrect in the exported Excel file.(DOCXLS-5229)
The QRCode which has connection symbol is not output to the PDF file correctly.(DOCXLS-5230)
The radar chart is incorrect in the exported Excel file.(DOCXLS-5238)
Unexpected borders are output in the exported PDF file if the cell is merged.(DOCXLS-5248)
NullPointerException is thrown on calling 'Workbook.ToJson()' method.(DOCXLS-5253)
The exported Excel file is corrupted when copying a sheet with name length is 31.(DOCXLS-5256)

5.0.0 Added

Support for Linked Picture.(DOCXLS-625)
Support for Table expandBoundRows API.(DOCXLS-3447)
Support for Excel threaded comments.(DOCXLS-3989)
Enhance license system.(DOCXLS-4181)
Import data function.(DOCXLS-4758)
Support for workbook views.(DOCXLS-4760)
New Formula2 property to set Dynamic Array Formula.(DOCXLS-4949)
Support for GETPIVOTDATA Function.(DOCXLS-5200)

Fixed

The result of NOW() function is incorrect.(DOCXLS-3721)
There is a large gap on the top of the cell in exported PDF file.(DOCXLS-4218)
NullPointerException is thrown on calling 'Workbook.Open()' method.(DOCXLS-4886)
The cell style is lost in the exported JSON file when compared with the original JSON file.(DOCXLS-4999)
The pattern fill settings of charts are not rendered in exported PDF file.(DOCXLS-5071)
The text with "\n" in charts is shifted in exported PDF file.(DOCXLS-5072)
The cell values are incorrect in exported CSV file.(DOCXLS-5153)
The cell styles are incorrect in exported Excel file after loading the JSON file.(DOCXLS-5154)
The exported Excel file is corrupted when copying a worksheet from another worksheet.(DOCXLS-5155)
The result of 'TEXT' function is incorrect.(DOCXLS-5173)
ArrayIndexOutOfBoundsException is thrown on calling 'Workbook.ToJson()' method.(DOCXLS-5196)

4.2.6 Fixed

The cell formula and value are lost in exported JSON file.(DOCXLS-5089)
It takes too much time on calling method 'Workbook.ProcessTemplate()'.(DOCXLS-5094)
Exception is thrown on calling 'Workbook.ToJson()' method.(DOCXLS-5098)
The cell style is incorrect in the exported Excel file.(DOCXLS-5099)
Exception is thrown on calling 'Workbook.FromJson()' method.(DOCXLS-5112)
The result of 'Round' formula is incorrect in German culture.(DOCXLS-5117)
IlleagalArguement and NumberFormat exception would be thrown on opening particular excel file using GcExcel.(DOCXLS-5118)
The formula in exported JSON by GcExcel is not the same as original JSON.(DOCXLS-5122)
The floating object is lost in the exported JSON file.(DOCXLS-5125)
Exception is thrown on opening particular excel file.(DOCXLS-5129)
Exception is thrown on calling method 'Workbook.ToJson()' when workbook contains PivotTable.(DOCXLS-5140)
Theme color is incorrect in the exported Excel file.(DOCXLS-5144)
The version is incorrect in the exported JSON file.(DOCXLS-5145)
Exception is thrown on calling method 'Workbook.FromJson()' when JSON contains conditional format.(DOCXLS-5149)

4.2.5 Fixed

It takes too much time on calling method 'GetUsedRange'.(DOCXLS-4552)
It takes too much time on copying range with formulas.(DOCXLS-4884)
Exception is thrown on calling IRange.FromJson.(DOCXLS-4922)
The formula is not correct after cutting range to another position.(DOCXLS-4979)
The exported Excel file is corrupted after copying a range from one workbook to another.(DOCXLS-4985)
The number format is changed after setting cell's value.(DOCXLS-4987)
Exception is thrown on calling 'ToJson' method in Mac environement.(DOCXLS-4997)
Macros are not preserved when an xlsm file with OLE objects is loaded and saved.(DOCXLS-5027)
The exported Excel file is corrupted after copying a worksheet from one workbook to another.(DOCXLS-5043)
OLE Objects are broken in exported Excel file.(DOCXLS-5047)
NumberFormatException is thrown on opening an Excel file which contains Pivot Table.(DOCXLS-5051)
The filter result is incorrect in exported JSON file.(DOCXLS-5059)
Extra characters are added to the comments in exported Excel file.(DOCXLS-5060)
The rows that should be hidden are shown in exported Excel file.(DOCXLS-5061)
Exception is thrown on calling 'workbook.calculate()' method.(DOCXLS-5079)
It takes too much time on calling method 'IWorksheet.FromJson()'.(DOCXLS-5084)

4.2.4 Fixed

IGraphic.LockAspectRatio didn't take effect when adding picture or changing picture size.(DOCXLS-4175)
An error would be thrown when loading the JSON file exported by GcExcel in SpreadJS designer.(DOCXLS-4778)
Exception is thrown on opening excel file exported by YARG using GcExcel.(DOCXLS-4874)
The exported JSON could not be validated.(DOCXLS-4900)
InvalidFormulaException is thrown on opening an Excel file.(DOCXLS-4901)
Exception is thrown on copying range.(DOCXLS-4903)
Exception is thrown on loading JSON file exported by GcExcel.(DOCXLS-4908)
Formula is lost after loading JSON and exporting to Excel file.(DOCXLS-4924)
(Duplicate)InvalidFormulaException is thrown on opening an Excel file.(DOCXLS-4947)
The comments are lost in exported JSON file.(DOCXLS-4953)
ConcurrentModificationException is thrown on copying workbook range.(DOCXLS-4965)
Exception is thrown on saving Excel file using GcExcel.(DOCXLS-4988)

4.2.3 Enhanced

Internal compatibility additions with GcExcel .NET

4.2.2 Enhanced

Support XlsmOpenOptions and XlsmSaveOptions.(DOCXLS-4747)
Upgrade the pdfbox version to 2.0.24.(DOCXLS-4787)

Fixed

Exception is thrown on copying a worksheet to another workbook.(DOCXLS-4737)
The checkbox is lost in the exported PDF file.(DOCXLS-4744)
The cell value is incorrect after using setValue method to set the cell value.(DOCXLS-4781)
Print Area is different from the original JSON file in the exported JSON.(DOCXLS-4789)
Exception is thrown on reading the JSON file.(DOCXLS-4798)
The exported Excel file is corrupted after deleting rows using GcExcel API.(DOCXLS-4799)
It takes too much time on calling the ToJson method.(DOCXLS-4803)
The cell value is incorrect on using setValue method when the value is a BigDecimal.(DOCXLS-4806)
Exception is thrown on calling the toJson method when the margin of the printinfo is null.(DOCXLS-4808)
The formula result "=EDATE(NOW(),1)" calculated by GcExcel is different from Excel.(DOCXLS-4816)
NumberFormatException is thrown on loading a particular excel file with user.language=de.(DOCXLS-4817)
It takes too much time on opening a workbook.(DOCXLS-4818)
The grouped result using GcExcel is different from Excel.(DOCXLS-4823)
Exception is thrown on calling the IRange.Group()and workbook.Save() methods.(DOCXLS-4824)
NullPointerException is thrown on calling the toJson method for specific Excel using GcExcel API.(DOCXLS-4829)
NullPointerException is thrown on copying a range from a specific Excel file to a new workbook using GcExcel API.(DOCXLS-4838)
The result in exported Excel file is incorrect after using IWorksheet.Outline.ShowLevels() method.(DOCXLS-4871)
The cell style is incorrect in the exported PDF file.(DOCXLS-4876)

4.2.1 Added

Support for exporting charts to Image/HTML.

Enhanced

Enhancement of Range.AutoFit(bool considerMergedCell).
Add dynamic array and workbook URI link to formula parser.

Fixed

ITickLabels.NumberFormat is not applied when saving a workbook to PDF/Image/HTML file.(DOCXLS-4143)
When IAxis.MajorUnit is set, tick labels are duplicated in exported PDF/Image/HTML file.(DOCXLS-4144)
When the chart series is added, orders of series and legends are incorrect in exported xlsx file.(DOCXLS-4165)
Values of category axis are incorrect in exported PDF/Image/HTML file.(DOCXLS-4274)
Exception is thrown on saving PDF/Image/HTML file, if ISeries.Formula is set.(DOCXLS-4275)
The exported file is incorrect after deleting columns by GcExcel.(DOCXLS-4606)
Exception is thrown on using Formula parser if syntax contains '.'.(DOCXLS-4642)
Exception is thrown on opening an Excel file.(DOCXLS-4643)
Cell's numberformat is different from the original JSON file in exported JSON.(DOCXLS-4653)
The exported CSV file is incorrect when Range.Value contains '\n'.(DOCXLS-4655)
Exception is thrown on opening an Excel file(exported by an unknown program).(DOCXLS-4662)
The font style is not correct in exported PDF file.(DOCXLS-4670)
Exception should be thrown when setting Worksheet.Name which contains invalid characters.(DOCXLS-4676)
The text in the textbox is not exported to PDF correctly.(DOCXLS-4678)
The result of row height is incorrect in Range.RowHeight using GcExcel.(DOCXLS-4699)
The exported JSON file by GcExcel is too large.(DOCXLS-4700)
Exception is thrown on adding table.(DOCXLS-4702)
Fallback font is not used after FontFolderPath is set when exporting to PDF file on Linux.(DOCXLS-4713)
The result in exported Excel file is not correct after delete columns/rows.(DOCXLS-4728)

4.2.0 Added

Dynamic Array Formulas along with the new functions: FILTER/RANDARRAY/SEQUENCE/SINGLE/SORT/SORTBY/UNIQUE.
Support for new Calc Engine functions: WEBSERVICE/FILTERXML/ASC/DBCS/JIS/XLOOKUP/XMATCH.
External workbook links from the web.
Document properties for workbook.
Retrieve the row and column grouping information.
Copy hidden rows to new range.
Control the size of the exported json file.
Support for margin settings for text in a shape.
Expand or Collapse grouped items in a Pivot Table.
More features for SpreadJS integration: RowCount or ColumnCount, get URL of a picture, Pivot Table for json I/O, etc.
Support for exporting charts to PDF.

Fixed

NullReference exception is thrown while adding a row in a table.(DOCXLS-2504)
When MarkerStyle.None is set for ISeries.MarkerStyle, the chart is not exported correctly in Excel.(DOCXLS-4071)
When a JSON file is opened and exported to another JSON file, the picture floating object is lost.(DOCXLS-4098)
Exported xlsx file does not meet the OpenXml standard if it contains a picture shape.(DOCXLS-4213)
Exception is thrown on saving an Excel file.(DOCXLS-4215)
When the pagebreak of template properties is set as true, page breaks are added before the field.(DOCXLS-4307)
Dynamic array formula does not generate the correct value.(DOCXLS-4433)
Exception is thrown on opening a JSON file.(DOCXLS-4599)
Exception is thrown on calling the 'ToJson' method.(DOCXLS-4611)

4.1.4 Fixed

The exported PDF is different from SpreadJS designer.(DOCXLS-4152)
Throws an exception on saving a PDF file.(DOCXLS-4407)
Program stucks on using the 'copy' method of IRange.(DOCXLS-4414)
'CellInfo.GetRangeBoundary' method generates incorrect result.(DOCXLS-4424)
Zoomfactor info is lost in the exported JSON.(DOCXLS-4427)
The page footer in exported PDF is incorrect with the '&D' format.(DOCXLS-4432)
The number format of PivotTable's data field is lost in the exported Excel file.(DOCXLS-4445)
Throws an exception on using the 'IWorksheet.FromJson' method.(DOCXLS-4448)
Treemap and Sunburst charts are not created by referring the data from another worksheet.(DOCXLS-4522)
Drop-down list is lost in the exported JSON file.(DOCXLS-4551)

4.1.3 Fixed

Throw NumberFormatException when opening the Excel file.(DOCXLS-4146)
Method 'toJson' fails while using Cube Formulas and OLAP Tools.(DOCXLS-4162)
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.(DOCXLS-4174)
PivotTable's data field NumberFormat lost after exporting to Excel file.(DOCXLS-4214)
Exception on opening an Excel file.(DOCXLS-4266)
SetValue method throws exception.(DOCXLS-4273)
An exception is thrown when opening an Excel file.(DOCXLS-4277)
When the existing combination chart is copied in an Excel, saved xlsx file is corrupted.(DOCXLS-4287)
Formula result calculated by GcExcel is different from Excel.(DOCXLS-4317)
The row tags were lost in exported JSON.(DOCXLS-4321)
The hyperlink address is incorrect in exported JSON.(DOCXLS-4322)
Formula displays #value in GcExcel.(DOCXLS-4360)
Opening a certain Excel file throws an Illegalargumentexception.(DOCXLS-4361)
After copying the sheet with 'fromjson', the drop-down is lost in exported JSON.(DOCXLS-4367)
When an xlsx file containing shape with link of a relative path is loaded and saved, saved file is corrupted.(DOCXLS-4370)
The drop-down menu is incorrect in exported JSON.(DOCXLS-4371)
When range is copied and Workbook.ToJson() is executed, an exception is thrown.(DOCXLS-4374)
The cell padding style is lost in exported JSON.(DOCXLS-4391)
The textDecoration field is missing in exported JSON when compare with the original JSON.(DOCXLS-4393)
The JSON with cell background graph cannot be imported on loading from 'fromjson' method.(DOCXLS-4394)

Enhanced

Reduce the size of exported json file.(DOCXLS-4281)
Optimize the performance of import and export json file.(DOCXLS-4372)

4.1.2 Fixed

Performance Issue in reading formula from Excel file using GcExcel API with compare to Spread.(DOCXLS-3974)
Range Value not getting after loading file in GcExcel.(DOCXLS-4128)
Performance issue in accessing the cell when using Slicer in the Excel sheet.(DOCXLS-4187)
FormulaResult is not correct if the Evaluate returns null.(DOCXLS-4190)
Saved Workbook corrupted after copying sheet with invalid cell format from existing workbook.(DOCXLS-4221)
GcExcel for java takes too long to import ssjson.(DOCXLS-4158)
ToJSON throw Index out of bound exception.(DOCXLS-4161)
[I/O Lossless]Support SpreadJS table expandBoundRows.(DOCXLS-4191)
FromJSON throw error.(DOCXLS-4212)
The font of the exported Excel file is bold.(DOCXLS-4054)
Setting the chart axis not to have gridlines is not applied.(DOCXLS-4100)
Formula result is different from SpreadJS.(DOCXLS-4135)
Program would be stuck while executing exporting pdf.(DOCXLS-4141)
StackOverflowError occurs when importing ssjson with fromJson.(DOCXLS-4170)
Result of exported xlsx file contains ENCODEURL function is not correct.(DOCXLS-4171)
The value obtained by the gettext method is incorrect.(DOCXLS-4178)
ToJSON is not including the pivotTable info.(DOCXLS-4229)
FromJSON throws error.(DOCXLS-4235)
After deleting a column, the getlastcolumn method does not get the correct result.(DOCXLS-4246)
When xlsx file saved with GcExcel is loaded and saved again, number becomes incorrect.(DOCXLS-4260)

4.1.1 Fixed

Shape Color changed after saving Excel file using GcExcel API.(DOCXLS-3918)
Invalid formula error when opening particular Excel using GcExcel API.(DOCXLS-3919)
Behaviors of pivot table changed after saving using GcExcel API.(DOCXLS-3973)
INDEX function value in returning "Ref" when opening excel using GcExcel API with DoNotRecalculateAfterOpened= false.(DOCXLS-3987)
Collapsed grouping shows "-" sign when opening exported excel from GcExcel, in SpreadJs.(DOCXLS-4039)
Value is returning "Ref" for the output fields after calling Calculate method of GcExcel.(DOCXLS-4099)
The cell with ";;;" NumberFormat shouldn't be shown in pdf.(DOCXLS-3939)
Formula Cells referencing Date Cells with Empty or Zero as a value are erasing the numberFormat property value after assigning a value.(DOCXLS-3990)
The ComboBox is lost after gcexcel loading given ssjson file.(DOCXLS-4008)
Exception was thrown when loaing the ssjson file.(DOCXLS-4027)
Gradient fill is displayed as solid fill in the exported HTML.(DOCXLS-3896)
The cell value would be lost if the column's width is 1px when exporting HTML.(DOCXLS-3906)
The drop down items is not correct in exported ssjson file.(DOCXLS-3947)
The sheet would be lost when exporting to ssjson file.(DOCXLS-3979)
Could not delete the custom style of GcExcel.(DOCXLS-3980)
NullPointerException would be thrown when saving to excel file.(DOCXLS-3982)
When an xlsx file that contains shapes is exported to pdf/image/HTML, shapes are not output correctly.(DOCXLS-3985)
Exporting is not processed correctly when the workbook containing shapes with the same name is exported to HTML.(DOCXLS-3982)
NullPointerException would be thrown when loaing ssjson file which contains hyperlink.(DOCXLS-3993)
Hyperlink info would be lost in exported ssjson file.(DOCXLS-3995)
Some exceptions would be thrown when exporting to json.(DOCXLS-4024)
Drop down style is disorder in exported ssjson by GcExcel.(DOCXLS-4036)
Prompt issues when open exported xlsx file by MSExcel(DOCXLS-4049).
Infinite loop when 'PrintManager.Paginate' called with specific parameters.(DOCXLS-4056)

4.1.0 Added

Parse formula string into a syntax tree.
Ignore Formulas when saving Excel files.
Support open action script on PdfSaveOptions.
New overload method to load JSON.
More Features for SpreadJS Integration: RangeTemplate cell type, get/set custom object as cell value.
New ToJson and FromJSON methods to Workbook elements.

Enhanced

Performance improvements in Excel Template processing.
Improved Calculation Engine's performance when setting values.

Fixed

Performance issue when updating data in Excel using GcExcel API.(DOCXLS-3912)
When the worksheet contains a shape, the row height cannot be changed.(DOCXLS-3909)
The formula =TEXT("12345","[dbnum2]") not work.(DOCXLS-3900)
The font is bold after exporting to PDF.(DOCXLS-3895)
ROUNDUP result is different with Excel.(DOCXLS-3870)
GcExcel formula result is different with Excel.(DOCXLS-3866)
COUNTIF result is different with Excel.(DOCXLS-3860)
After saving to Excel, the hidden rows are displayed.(DOCXLS-3848)
Conditional Format is not coming in PDF/HTML.(DOCXLS-3846)
The position of radio button list is wrong in the exported PDF.(DOCXLS-3815)
After setting the cell style in two ways, the results are different.(DOCXLS-3787)
Using IRange.HasFormula and IRange.Value together, degrades performance.(DOCXLS-3164)
Mixed order of Set and Get cell values degrades performance.(DOCXLS-3163)

4.0.5 Fixed

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

4.0.4 Fixed

Generating SSJSON takes longer time.(DOCXLS-3598)
Insert Range shows Invalid Operation Exception in certain cases.(DOCXLS-3638)
ArrayIndexOutOfBoundsException while opening the file.(DOCXLS-3712)
File takes 17min to open unless shapes disabled.(DOCXLS-3725)
Taking longer time to get value from a cell.(DOCXLS-3736)
Getting cell value take more time after copying it to another sheet.(DOCXLS-3738)
Setting formula fails with exception.(DOCXLS-3742)
Copying range fails with exception.(DOCXLS-3743)
Getting value from source after copying takes more than 5 minutes.(DOCXLS-3744)
Excel with pivot table corrupted after saving using GcExcel API.(DOCXLS-3747)
NullPointerException when saving copy.(DOCXLS-3750)
Excel corrupted after hiding columns using GcExcel API.(DOCXLS-3751)
IndexOutOfBoundsException when saving workbook.(DOCXLS-3752)
Cannot read formula in copied file.(DOCXLS-3765)
Broken file produced during copy.(DOCXLS-3766)
Removing formula in copied workbook fails with exception.(DOCXLS-3767)
ProtectionOptions setting lost after saving to json using GcExcel.(DOCXLS-3772)
Cached value lost in sourceSheet after copying range, Different behavior when copying range and sheet.(DOCXLS-3773)
Calculation hangs in workbook copied using ssjson.(DOCXLS-3805)
Structured references in table cells not calculating after range copy/paste between worksheets.(DOCXLS-3806)
ArgumentOutOfRangeException occurs when calculating excel file with External Links.(DOCXLS-3471)
Unexpected border in PivotTable in the exported Pdf.(DOCXLS-3770)
Exception occurs after calling IPivotTable.Update().(DOCXLS-3797)
Problem exporting PDF with text orientation.(DOCXLS-3455)
IllegalArgumentException on opening attached Excel file.(DOCXLS-3472)
Copy result is not correct if copy entire single row to multi rows and target rows contains entire merge areas.(DOCXLS-3538)
Java API column setHidden() method is not working properly.(DOCXLS-3563)
After the excel file toJson, data validation is lost.(DOCXLS-3649)
After GCExcel imports and exports ssjson，the chart type has changed.(DOCXLS-3650)
Invalid values after calculation with Release 4.0.2.(DOCXLS-3669)
IRange.Find won't work while the search string end with "~".(DOCXLS-3708)
Sheet password does not work after saving by GCExcel.(DOCXLS-3715)
Exception of type 'GrapeCity.Documents.Excel.InvalidFormulaException' was thrown when Cutting a range in sheet to another workbook.(DOCXLS-3720)
Getting the background color of entire column is wrong.(DOCXLS-3740)
When pareto chart and funnel chart are exported to a PDF, NullReferenceException occurs.(DOCXLS-3781)
Cells Text Orientation is not deserialised to Json.(DOCXLS-3816)
Incorrect JSON gets exported for grouped Columns.(DOCXLS-3821)

4.0.3 Fixed

Exception occurs when save as HTML if the background image's name is null.(DOCXLS-3578)
The line spacing becomes too big in the saved Pdf document.(DOCXLS-3524)
When IRange.Font is getten in multi-thread processing, System.InvalidOperationException will occur.(DOCXLS-3567)
Chart plot area in the exported Pdf is not the same as in Excel.(DOCXLS-2375)
Some lines disappear in the exported Html.(DOCXLS-3374)
Opening workbook fails with "Invalid argument: Number" exception.(DOCXLS-3503)
Double underline is not exported to Pdf correctly.(DOCXLS-3507)
Background image should not stretch in exported Html with settings "ImageLayout.None".(DOCXLS-3535)
ClassCastException occurs when process template.(DOCXLS-3539)
Add a picture to the sheet, and the text will not display completely in the exported Pdf.(DOCXLS-3541)
After opening an Excel file and converting it to a json file, the word wrapping is lost.(DOCXLS-3586)
Exception on getting formula after copying a worksheet.(DOCXLS-3587)
Some rows are not auto-fitted in the exported Pdf.(DOCXLS-3588)
The margins of rich text cell are not correct in the exported Pdf.(DOCXLS-3589)
Opening file throws exception.(DOCXLS-3597)
When a PDF form field without font name is exported to a PDF, this PDF shows an error message.(DOCXLS-3599)
The font of cells with conditional format has changed in PDF.(DOCXLS-3602)
ArrayIndexOutOfBoundsException in reading attached xlsx files.(DOCXLS-3628)
When a shape is copied, horizontal alignment of text on copied shape is cleared.(DOCXLS-3630)
Garbled text will show in some enhanced text fields.(DOCXLS-3648)
java.lang.IllegalStateException occurs when open a xlsx file which is exported by POI.(DOCXLS-3569, DOCXLS-3572, DOCXLS-3575)
javax.xml.stream.XMLStreamException occurs when open a xlsx file which is exported by POI.(DOCXLS-3570)
NullPointerException occurs when open a xlsx file which is exported by POI.(DOCXLS-3571)
java.lang.ArrayIndexOutOfBoundsException occurs when open a xlsx file which is exported by POI.(DOCXLS-3577)

4.0.2 Fixed

Image position is wrong after importing ssjson then export to PDF.(DOCXLS-3431)
Pivot Table's border is lost in the exported PDF when there are banded rows/columns.(DOCXLS-3450)
Exception occurs when opening certain Excel file.(DOCXLS-3479)
Freezing range changed after saving existing excel via GcExcel API.(DOCXLS-3488)
The image can not display when opening GcExcel exported Html in QQ and outlook mailbox.(DOCXLS-3367)
The image border is wrong in the exported HTML.(DOCXLS-3343)
Null exception is thrown after calling calculate method.(DOCXLS-3428)
It becomes slow if you update cell tag in custom function.(DOCXLS-3426)
Rows can not be deleted after calling IRange.delete method.(DOCXLS-3460)
Open and then save an Excel with auto filter, an error occurs.(DOCXLS-3468)
IRR formula calculation result is different with Excel.(DOCXLS-3487)
Cell B2's value is different with Excel.(DOCXLS-3510)
Gradient and pattern fill are lost after GcExcel load ssjson.(DOCXLS-3527)
Copy pasting with intersecting merged cells throws exception.(DOCXLS-3161)
When GcExcel copys whole rows/columns to other one with merged area, an invalid operation exception will occur.(DOCXLS-3205)
The line disappears in exported image.(DOCXLS-3374)
Sheet background image can not be exported to Html.(DOCXLS-3398)
When the cell adjacent to the cell set the C template property is entered value or formatted, generated data is incorrect.(DOCXLS-3410)
It takes a long time to load a ssjson.(DOCXLS-3433)
Cell value is wrong when opening Excel with DoNotCalculateAfterOpened is true.(DOCXLS-3443)
Exception is thrown after opening and saving Excel file.(DOCXLS-3444)
When TemplateOptions.KeepLineSize is set true, row heights in generated xlsx file are not the same as the original template file.(DOCXLS-3448)
ArgumentOutOfRangeException occurs when GcExcel get the cell value which can't be converted to DateTime.(DOCXLS-3457)
ArgumentOutOfRangeException occurs when the max value of DateTime is set in a cell.(DOCXLS-3470)
Hyperlink is not generated in exported Html when the cell is set a Hyperlink function.(DOCXLS-3475)
Broken file created when copying sheet (related to Comments).(DOCXLS-3504)
Cell formats are lost after SpreadJS load the ssjson generated by GcExcel.(DOCXLS-3522)
Webdings font does not take effect in the exported PDF.(DOCXLS-3536)

4.0.1 Fixed

#REF! error occurs when copying formula between workbooks.(DOCXLS-3313)
Broken xlsx file is generated after copying sheet between workbooks.(DOCXLS-3316,DOCXLS-3329,DOCXLS-3330)
Hyperlinks are not exported to the PDF correctly.(DOCXLS-3335)
Exception is thrown when saving to Excel with Pivot Table.(DOCXLS-3297)
The col tag is not correct in the saved Html.(DOCXLS-3370)
After saving to Html, the total value in Pivot Table shows a lot of #.(DOCXLS-3344)
Exception is thrown during from json.(DOCXLS-3361)
ConcurrentModificationException is thrown when saving to Excel file.(DOCXLS-3362)
NullException is thrown when opening an Excel file.(DOCXLS-3401)
NumberFormatException is thrown when an Excel file.(DOCXLS-3403)
DataValidation will not work in SpreadJS after loading the ssjson exported by GcExcel.(DOCXLS-3405)
Error occurs when opening a xlsx file which is saved by GcExcel.(DOCXLS-3408)
IllegalStateException is thrown during from ssjson.(DOCXLS-3424)
Column width is wrong in SpreadJS after loading the ssjson exported by GcExcel.(DOCXLS-3430)
Can not navigate to destination address when click hyperlink in exported PDF file.(DOCXLS-3265)
NullPointerException is thrown when copying sheet between workbooks.(DOCXLS-3315)
Workbook.SelectedSheets doesn't reset after FromJson.(DOCXLS-3356)
Error popping up while opening an Excel file having the pivot.(DOCXLS-3360)
NullReferenceException will occur when Workbook.ToJson() is used.(DOCXLS-3366)
When saving as Html, the text with format ";;;" should not be export to Html.(DOCXLS-3372)
The custom data validation can be added without the formula.(DOCXLS-3379)

4.0.0 Added

Support for new PDF Form custom input types in Excel Templates with advanced input and validation settings.
Support for adding, modifying and deleting Pivot Charts in Excel documents.
Support for iterative calculations in Excel documents.
Add Barcodes on PDF, HTML or Image Export
Support cross-workbook formula.
Support setting default value for template cell.
Get range address to get cell's address.
Add page printing events to track progress of Excel to PDF conversion.
Select multiple worksheets.
Get special cells in a range.
Disable auto grouping for date/times in PivotTable.
Add more features for GrapeCity SpreadJS integration: cell buttons, radio and checkbox list cell type, etc.

Fixed

PivotTable MergeLabel's merged area is incorrect.(DOCXLS-3181)
PivotTable.DataBodyRange throws exception.(DOCXLS-3283)
Can't open the xlsx when the pivot source contains null values.(DOCXLS-3285)
Failed to export an Excel with pivot table.(DOCXLS-3297)
Program does not end and CPU utilisation is 100% when exporting to PDF.(DOCXLS-2744)
Broken Excel file is generated when copying a sheet.(DOCXLS-3252)
ArrayIndexOutOfBoundsException when generating JSON.(DOCXLS-3165)
When margins are set to the same value, the rendering position is not the same in PDF.(DOCXLS-3211)
Labels does not merge in exported xlsx file.(DOCXLS-3262)
SUM is calculated incorrectly when using GcExcel template functionality.(DOCXLS-3267)
PDF form is not displayed when 'printed' and 'hidden' settings are false in form field.(DOCXLS-3275)
Rows are not repeating while using GcExcel Template.(DOCXLS-3278)
Null exception is thrown during loading ssjson.(DOCXLS-3290)
Null exception is thrown when calling Workbook.Calculate.(DOCXLS-3299)
The text in exported image is wrong.(DOCXLS-3314)
The pivot table label does not merge in exported xlsx file.(DOCXLS-3262)

3.2.4 Fixed

DataValidation does not work for added rows for Table.(DOCXLS-3158)
PivotTable's row field is missing after PivotTable.AddDataField().(DOCXLS-3174)
Exception occurs when exporting Pivot Table to PDF.(DOCXLS-3176)
PivotTable.RowRange throws exception if there is no row fields.(DOCXLS-3179)
Table Resize with one row table lost conditional format and data validation.(DOCXLS-3194)
The printed area does not consider hidden rows and columns.(DOCXLS-3206)
The calculated result of Lookup formula is different with Excel.(DOCXLS-3177)
The IRange.Columns.AutoFit() result is wrong when wrapping text.(DOCXLS-3178)
PivotTable column fields' vertical alignment is wrong after setting MergeLabels to true.(DOCXLS-3180)
Import ssjson and export to PDF, the program is blocked.(DOCXLS-3216)
InvalidFormulaException is thrown when importing ssjson.(DOCXLS-3242)
IRange.AutoFit() does not consider ConditionalFormatting's icon size.(DOCXLS-3117)
It takes over 40 seconds to export to json.(DOCXLS-3138)
The calculated result is wrong when array formula and custom function work together.(DOCXLS-3141)
Richtext is lost in the exported image.(DOCXLS-3142)
Null reference exception is thrown while exporting to json.(DOCXLS-3166)
Null reference exception is thrown while opening an Excel with chart.(DOCXLS-3167)
CloneNotSupportedException when copying sheet with Top/Bottom % conditional formatting rule.(DOCXLS-3169)
Column width is not autofit correctly when Autofit() method is applied to a cell with full-width characters entered.(DOCXLS-3172)
Grouped rows displayed in UI even after calling showLevels(1,0) after exporting to ssjson.(DOCXLS-3173)
PivotTable's border style is wrong in the exported PDF.(DOCXLS-3175)
The calculated style of conditional formats is wrong in the exported PDF.(DOCXLS-3234)
NullPointerException in ArrayList occurs when copying a single cell after opening Excel File.(DOCXLS-3235)
The Pivot Table label's resource should be "值" instead of "Values".(DOCXLS-3236)
When workbook is exported to PDF, value axis' maximum scale in radar chart are changed.(DOCXLS-3239)
The quote prefix is lost in the exported ssjson.(DOCXLS-3240)
PdfSaveOptions is not applied to the output PDF when IWorksheet.Save() is used.(DOCXLS-3246)
Spans are lost after fromJSON.(DOCXLS-3250)

3.2.3 Fixed

The generated Excel report is wrong with GcExcel teplates.(DOCXLS-2999)
Performance issue when setting value to single cell.(DOCXLS-3029)
The calculated result of SUMIFS formula is wrong.(DOCXLS-3033)
Data validations are lost after expanding table ranges.(DOCXLS-3075)
The exported xlsx can not be opened if there is an empty column in Pivot Table source.(DOCXLS-3127)
Open a xlsx and save it back, the saved xlsx can not be opened.(DOCXLS-3131)
The 'General' number formatter is lost in the exported ssjson.(DOCXLS-3132)
Pagination is different between PrintManager and Workbook.Save().(DOCXLS-2801)
Error occurs when importing JSON with some null values.(DOCXLS-3046)
The cell text color in Pivot Talbe is wrong in the exported PDF.(DOCXLS-3130)
The cell font size is lost after loading ssjson with Conditional Formattings.(DOCXLS-3046)
Error occurs when loading a ssjson which contains cell value of empty array.(DOCXLS-3115)
Cell's display color is wrong when a color number formatter is applied.(DOCXLS-3114)
The calculated result should be #DIV/0! like Excel, but #NUM! now in GcExcel.(DOCXLS-3012)
Out of memory occurs during processing templates.(DOCXLS-3031)
GcExcel fails to open workbook with a checkbox wherein Excel is created using Aspose(DOCXLS-3019)
It seems that rounding of a number does not take effect in the exported PDF.(DOCXLS-3095)
Invalid range error occurs when setting print area.(DOCXLS-3136)
Excel takes a long time to open a large xlsx generated by GcExcel.(DOCXLS-3128)

3.2.2 Fixed

Plot area's size and location in the exported PDF are not same as Excel.(DOCXLS-2673)
Date/Time fields are always groupped in Pivot Table.(DOCXLS-2790)
DataValidation does not work for added rows at 0 index for Table.(DOCXLS-2868)
InvalidFormulaException is thrown when importing some Excel file.(DOCXLS-2889)
Exception is thrown after processing templates and then to json.(DOCXLS-2961)
Processing templates and exporting to json is very slow.(DOCXLS-2965)
Incorrect settings for Protected Sheet for exported JSON from GcExcel.(DOCXLS-2977)
Data Validation with any type in SpreadJS can't be read via GcExcel.(DOCXLS-2982)
Error occurs when importing JSON with pictures of gif.(DOCXLS-2992)
FM=overwrite does not work correctly when G=R in Templates.(DOCXLS-2871)
Column width in SpreadJS is changed after GcExcel JSON I/O.(DOCXLS-2873)
The cell with HYPERLINK formula does not display as hyperlink in the exported Excel.(DOCXLS-2914)
Error occurs when GcExcel imports its own exported JSON .(DOCXLS-2967)
Borders are lost in the exported PDF.(DOCXLS-2994)
The used range becomes very large after from JSON.(DOCXLS-299)
There are some weird lines in the exported PDF.(DOCXLS-2795)
Chart type is changed in the exported Excel.(DOCXLS-2870)
FM=overwrite does not work in cross-table.(DOCXLS-2872)
The calculated result of formula "=2^10000" should be CalcError.Num.(DOCXLS-2899)
The text of ITextRun is wrong.(DOCXLS-2902)
The formatted text is not same as Excel with formatter "0.00E+00".(DOCXLS-2892)
IllegalArgumentException is thrown during to JSON.(DOCXLS-2874)
Error occurs during opening xlsx which is generated by GcExcel.(DOCXLS-2983)
A lot of empty rows are generated after prcossing templates.(DOCXLS-2985)
Table filter changes after saving to Excel.(DOCXLS-2962)
Charts are changed after inserting a picture.(DOCXLS-2980)

3.2.1 Fixed

Templates markers are not cleared after processing template.(DOCXLS-2675)
Collapsed groups are not exported correctly to ssjson.(DOCXLS-2762)
Chart type is changed after loading a XYScatter chart from Excel.(DOCXLS-2643)
Table Resize method does not carry over the Formula, Style and Conditional Formatting.(DOCXLS-2665)
The exported PDF is wrong after setting best-fit-columns to true.(DOCXLS-2700)
The exported Excel can not be opened correctly after setting IPivotTable.MergeLabels to true.(DOCXLS-2739)
Cell text orientation is lost after importing from ssjson.(DOCXLS-2764)
Exception is thrown when there are some special characters and exporting to PDF.(DOCXLS-2769)
Program does not end and CPU utilisation is 100% after calling auto-fit on entire column.(DOCXLS-2785)
Excpetion is thrown after importing a ssjson and then exporting to PDF.(DOCXLS-2789)
The result of conditional format is wrong in the exported PDF.(DOCXLS-2685)
The saved password-protected Excel file can not be opened when there is more than 15M data.(DOCXLS-2690)
The height of cell(with wrapped text) is changed after importing ssjson and then saving to xlsx.(DOCXLS-2735)
RowCount and ColumnCount in exported ssjson is incorrect after deleting some rows/columns.(DOCXLS-2741)
Text can not be pasred correctly when current culture is en-GB.(DOCXLS-2745)
The calculated result is "∞" in GcExcel, which is #DIV/0! in Excel.(DOCXLS-2747)
Exception is thrown when opening an Excel with gradient unscaled fill.(DOCXLS-2761)
The accounting format is rendered wrong in the exported PDF.(DOCXLS-2765)
Exception is thrown when importing ssjson with an invalid "cap" value.(DOCXLS-2786)
Range.Text is incorrect when number format is #,##0.00,,.(DOCXLS-2788)
IRange.Clear() doesn't clear tags.(DOCXLS-2794)
The calculated results of “=0^-x” and “=0^0” are not same as Excel.(DOCXLS-2855)

3.2.0 Added

Support for generating PDF Form from Excel Templates.
Support using sparklines and tables in Excel Templates.
Support defining Fixed layout for Excel report and fill data in specific range.
Support exporting workbook/worksheet/range to HTML.
Support 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, Field layout settings, etc.
Support adjustment of shape z-order.
Support image quality when exporting to PDF.
Support Picture Transparency when adding Images to Excel.
Support more SpreadJS features: show or hide horizontal and vertical grid lines, freeze trailing rows/columns, etc.

Fixed

Object reference error on converting the Workbook to JSON with DataValidation definitions.(DOCXLS-2659)
ToJSON method throws error when cell has formatter on Linux.(DOCXLS-2679)
FromJSON method takes long time to import ssjson file using GcExcel.(DOCXLS-2656)
Some content displays incompletely in exported PDF.(DOCXLS-2737)
Program does not end and CPU utilisation is 100% when exporting to PDF.(DOCXLS-2744)
There is messy code in exported image generated by sheet toImage() method on Linux OS.(DOCXLS-2478)
Program does not end and CPU utilisation is 100% when exporting to PDF.(DOCXLS-2744)
There is messy code in exported image generated by sheet toImage() method on Linux OS.(DOCXLS-2478)

3.1.5 Fixed

Column width is not correct when workbook is exported to JSON.(DOCXLS-2497)
NullReference exception is thrown while adding row in Table.(DOCXLS-2504)
Background color of some cells is incorrect when rows are deleted on a sheet with background color set in cells.(DOCXLS-2530)
Text is not correctly separated on a specific line when loading tab-delimited text to workbook.(DOCXLS-2559)
Culture property of the Workbook does not respect the value of the cell when opening the CSV file.(DOCXLS-2566)
NumberFormat exception is thrown when importing ssjson that contains specific conditional formats.(DOCXLS-2575)
BlackAndWhite setting does not work for picture fill.(DOCXLS-2593)
Rannge of the Formula is updating incorrectly when inserting row in the sheet.(DOCXLS-2595)
The margin values in exported Excel file are slightly different with the values in ssjson.(DOCXLS-2598)
InvalidOperationException occurs when calling Calculate method in the excel containing COUNTIFS function.(DOCXLS-2609)
It takes a long time to set values in a loop.(DOCXLS-2610)
Workbook.TagJsonSerializer is null when used.(DOCXLS-2606)
processTemplate() takes a long time to execute.(DOCXLS-2526)

3.1.4

Fixed

Exception is thrown when loading Excel file which contains huge amount of inline strings.(DOCXLS-2480)
The data labels are not plotted correctly when exporting Radar chart to PDF.(DOCXLS-2516)
It will take a very long time to process template when there are thousands of data records.(DOCXLS-2526)
Exception is thrown when exporting to PDF.(DOCXLS-2541)
The calculated result of CountIfs function is wrong.(DOCXLS-2549)

3.1.3

Fixed

Error occurs when adding new row in a table.(DOCXLS-2366)
Cell formatted text is wrong when the number format is "@".(DOCXLS-2406)
Error occurs after calling Workbook.calculate().(DOCXLS-2430)
Cell font color is not correct when some kind of number formatter is applied.(DOCXLS-2432)
Cell background in the exported pdf is black even though it is "lightgray" in json.(DOCXLS-2438)
Error occurs when from json.(DOCXLS-2440)
Cell rich text is rendered wrong in the exported pdf when the cell is a combo cell type.(DOCXLS-2443)
Top alignment is changed to bottom in SpreadJS after loading json from GcExcel .(DOCXLS-2469)
Error occurs when importing Excel file with a lot of inline strings.(DOCXLS-2473)
The saved Excel is corrupted when creating a Pivot table with SubTotalType.None.(DOCXLS-2470)

Changed

Depends on the latest PDFBox library-2.0.19

3.1.2

Fixed

Exception is thrown when cutting tables.(DOCXLS-2288)
The line style in exported pdf is not same as it is in Excel.(DOCXLS-2297)
The default date format is not changed by culture.(DOCXLS-2318)
Exception occurs when copying a sheet from another workbook and saving the workbook.(DOCXLS-2334)
There are unexpected lines on top of cell in the exported pdf.(DOCXLS-2339)
The saved Excel file is corrupted.(DOCXLS-2345)
Some values in the exported Excel file are incorrect.(DOCXLS-2352)
It takes a long time to open an Excel with a lot of inline strings.(DOCXLS-2353)
The plot area's boundary is incorrect in the exported pdf.(DOCXLS-2356)
ToJson would take a very long time.(DOCXLS-2364)
The content is incorrect in the exported pdf.(DOCXLS-2365)
Font files will be kept opening event after saving pdf.(DOCXLS-2372)
RepeatSetting doesn't work if there is only one row on the last page.(DOCXLS-2376])
Picture is not clear after exporting to PDF.(DOCXLS-2384)
Column width changes in the exported Excel.(DOCXLS-2385)
The calculated result is incorrect.(DOCXLS-2387)
Exception is thrown during from json.(DOCXLS-2390)

Changed

General formatter is used when invalid number format was found during getting cell text, previous behavior is throwing exception.

3.1.1

Fixed

Certain cell border lines do not render correctly when exporting to PDF.(DOCXLS-713)
The order of legend for chart in exported pdf is incorrect if legend across lines.(DOCXLS-1579)
Issue occurs when inserting new row to an existing table.(DOCXLS-1936)
Cell Formatter change after saveJson. (DOCXLS-2013)
In Excel, the horizontal break line will be ignored when set the exporting height fit to 1 page(s).(DOCXLS-2097)
IRange.Copy() cannot copy pictures sometimes.(DOCXLS-2153)
Save Excel containing Chart shows different output.(DOCXLS-2155)
The color of DataSeries of Chart is incorrect in exported pdf.(DOCXLS-2160)
Name is lost after cutting table.(DOCXLS-2169)
Stack overflow occus after cutting table.(DOCXLS-2170)
Data validation is lost after sheet json.(DOCXLS-2175)
Sometimes, the print area does not work.(DOCXLS-2176)
Error occurs when fromJSON. (DOCXLS-2182)
BackgroundPicture don't update after reset width and height if use Tile in BackgroundImageLayout. (DOCXLS-2186)
After export PDF, a minus number is not red when use format like "0.00_;[Red]-0.00". (DOCXLS-2188)
Picture don't update after reset width and height afert export PDF.(DOCXLS-2208)
Formula does not change after inserting row or binding data.(DOCXLS-2220)
The row becomes hidden after inserting row and save to json. (DOCXLS-2222)
Error occurs during fromJSON. (DOCXLS-2227)
ArrayIndexOutOfBounds exception occurs when cutting table.(DOCXLS-2235)
Picture don't update after duplicating operation. (DOCXLS-2241)
Copying a sheet containing a chart to another workbook corrupts the book.(DOCXLS-2247)
Calculation result is incorrect if different reference methods are used together in SUBTOTAL function.(DOCXLS-2257)
After export to PDF, some text can not display completely.(DOCXLS-2258)
Error occurs after opening Excel file saved by GcExcel.(DOCXLS-2261)
Error occurs during from json.(DOCXLS-2262)
Formulas is incorrectly marked as array formulas.(DOCXLS-2266)
Data is lost after importting an Excel. (DOCXLS-2268)
After enable PageSetup.BestFitRows, there maybe exception when save to PDF.(DOCXLS-2291)
After enable PageSetup.BestFitRows, the exported PDF is strange.(DOCXLS-2292)
Exception is thrown during saving to PDF when you set gradient color fill in background picture.(DOCXLS-2293)
Background picture's gradient fill is not correct in exported PDF file.(DOCXLS-2296)
The cell value is incorrect in the exported PDF.(DOCXLS-2303)
Hidden row becomes visible after save JSON.(DOCXLS-2308)
Chart markers are not drawn correctly in exported PDF.(DOCXLS-2309)
Incorrect calculation for CountIF formula.(DOCXLS-2310)
There is an exception When exportting PDF.(DOCXLS-2314)
ComboBox CellType throw errors when fromJSON.(DOCXLS-2315)
BackgroundPicture's gradient fill is not right after export PDF.(DOCXLS-2316)
Cell vertical alignment is changed after from JSON.(DOCXLS-2331)
Error occurs during from JSON. (DOCXLS-2337)
The large currency number is wrong in the exported PDF.(DOCXLS-2338)
Error occurs when importing JSON with chart.(DOCXLS-2342)

3.1.0

Added

Support for charts/images/conditional formatting in Templates.
Support exporting formulas in Templates.
Support global settings in Templates.
Support converting Excel objects(chart/shape) to image formats.
Support password protected workbook and worksheet.
Support adding Error Bars in Chart.
Support text angle of chart title/axis tick label/data label.
Support alignment of Shape's TextFrame.
Add image to specific range.
Support Gradient Fill Type enum in Shapes.
Support creating chart/shape/pictures with a custom name.
Enhanced Background image support for printing to PDF.
Get pagination info for printing to PDF.
Support Transparent Cell Background color in PDF.
Support worksheet JSON I/O.
Support Outline column to display hierarchical data in saved PDF.
Support data binding of Range, Table and Worksheet.
Return errors from JSON Import in GcExcel.

Fixed

Filtered data cannot be re-displayed after JSON(made by SJS) I/O in GcExcel.(DOCXLS-1646)
Exception occurs on loading specific ssjson.(DOCXLS-2158)
Exception may occur on exporting certain Excel sheets with charts to PDF (DOCXLS-2094)
Hiding fixed columns and rows causes incorrect display in Excel file.(DOCXLS-2020)
Pagination is inconsistent with SpreadJS when the form is exported to PDF.(DOCXLS-2159)
JSON file size is bigger when converted using GcExcel vs Online designer tool.(DOCXLS-1905)
The Value property value of the ComboBox cell is lost after JSON I/O.(DOCXLS-2029)
NullPointerException may occur on loading certain Excel file and saving it. (DOCXLS-2041)
Conditional formatting is lost if the rule references another sheet.(DOCXLS-2093)

3.0.4

Bugs Fixed

Exception is thrown when importing ssjson with certain group settings.(DOCXLS-1998)
Exception is thrown when importing ssjson with some null values.(DOCXLS-1959)
Digital signature is lost when an Excel file is modified and saved through GcExcel.(DOCXLS-1988)
Memory leak occurs when using GcExcel in multiple threads.(DOCXLS-1950)
Group can not be expanded in SpreadJS after loading ssjson from GcExcel.(DOCXLS-1870)
Rich text can not be rendered correctly in the exported pdf.(DOCXLS-1906)
The return value of IRange.HasFomula is wong.(DOCXLS-1940)

3.0.3

Bugs Fixed

Exception is thrown when importing xlsx file with certain conditional formatting.(DOCXLS-1844)
Hyperlink included in ssjson, does not display when exported to PDF. (DOCXLS-1858)
The column formula is not expanded after adding new rows in Table.(DOCXLS-1865)
Exception is thrown when importing ssjson with data validations.(DOCXLS-1860)
When the tag of the copied sheet is changed, the tag of the copy source is also changed.(DOCXLS-1862)
Exception is thrown when importing ssjson with grouping.(DOCXLS-1882)
Extra Border is drawn around an image in the header, when xlsx is printed.
Text styles are lost after copying worksheet and exporting to PDF.(DOCXLS-1814)
Formulas do not work in generated xlsx file from JSON.(DOCXLS-1847)
Unable to import specific xlsx file in GcExcel.(DOCXLS-1848)
Placement.MoveAndSize does not work after exporting to PDF.(DOCXLS-1856)
External link can not work in the exported PDF when the external file's name contains Chinese characters.(DOCXLS-1867)
Borders are lost in SpreadJS after importing ssjson generated from GcExcel.(DOCXLS-1885)

3.0.2

Bugs Fixed

Exception is thrown when importing ssjson that contains duplicated table names.(DOCXLS-1733)
Null reference exception is thrown when exporting to ssjson.(DOCXLS-1734)
Index out of range exception is thrown when exporting to pdf.(DOCXLS-1784)

3.0.1

Bugs Fixed

The font color is changed in SpreadJS after importing the ssjson exported by GCExcel.(DOCXLS-1729)
The hidden rows and columns are visible in SpreadJS after importing the ssjson exported by GCExcel.(DOCXLS-1729)
Shape name is changed after copying worksheet.(DOCXLS-1728)
GcExcel can not load some kind of ssjson correctly. (DOCXLS-1726)
Some rich text is overlapped after exporting to Pdf.(DOCXLS-1724)
Exception is thrown during exporting to pdf if the machine is German locale.(DOCXLS-1707)
Import ssjson containing data validaiton style and then export,the validation style will be lost in the exported ssjson.(DOCXLS-1692)
Chart type is changed after importing xlsx file.(DOCXLS-1686)
Null reference exception is thrown after loading xlsx then exporting to Pdf.(DOCXLS-1684)
Some shapes are lost after importing ssjson.(DOCXLS-1656)
"_xlfn" prefix is added before Days formula after exporting to ssjson.(DOCXLS-1655)
Formula of conditional format is changed after copying a range.(DOCXLS-1636)

3.0.0

New Features

Templates support to generate Excel reports.
Support conversion of Excel spreadsheets having slicers to PDF.
Support new Excel 2016 chart types.
Support security options when saving to PDF.
Support document properties when saving to PDF.
Protect workbook.
Support chart sheet.
Support shape with hyperlink.
Group/Ungroup shapes.
Calculate outline subtotal.
Get precedents and dependents of formula cell.
Add pivot table's grand totals and report layout options similar to Excel.
Support shape adjustment.
Support sheet background image to PDF.
Export Excel files with multiple images to PDF with reduced file size.
Support license workbook instance.
Rename pivot fields and Data Fields.
Support cell tags of GrapeCity SpreadJS.
Support cell types of GrapeCity SpreadJS.
Support best fit rows/columns feature of GrapeCity SpreadJS.

Bugs Fixed

Unable to set Icon for IconCriteria.(DOCXLS-1531s)
"_xlfn" prefix added before IFNA formula while converting to JSON.(DOCXLS-1537)
The precision of calculated result is incorrect.(DOCXLS-1547)
Exception is thrown when setting cell value with localDateTime.now().(DOCXLS-7532)
Text is displayed incompletely in exported PDF document.(DOCXLS-1539)
DiagonalDown border is lost in exported json.(DOCXLS-1577)

2.2.7

Enhancements

Customer can detect if there is custom Icon for a cell in specified range.(DOCXLS-1555)

Bug Fixed

Null exception is thrown when opening Excel file.(DOCXLS-1377)
Unable to set Icon for IconCriteria.(DOCXLS-1531)
"_xlfn" prefix is added before IFNA formula for ToJSON method.(DOCXLS-1537)
Characters display incompletely in the exported PDF.(DOCXLS-1539)
Diagonal down border is lost in the exported ssjson.(DOCXLS-1577)

2.2.6

Enhancements

Improve the opening time of large spreasheet when it contains shape and auto-fit rows.
JP built-in named styles are supported.

Bug Fixed

The formula result is not precise which leads to the conditional checking failed.(DOCXLS-1453)
The location and size of shapes are incorrect after opening the saved Excel under JP culture.(DOCXLS-1361)
The content of exported pdf is incorrect.(DOCXLS-1315)

2.2.5

Bug Fixed

The picture name is changed after saving a workbook to json several times.(DOCXLS-1427)
Corrupted Excel file is generated after copying a range containing checkbox control.(DOCXLS-1446)
Cell border is lost in exported pdf file..(DOCXLS-1450)
The auto row height is incorrect in the exported pdf if there is a merged cell and wrap text is true.(DOCXLS-1429)
Exception is thrown when opening a Excel file with a table whose name contains '.'.(DOCXLS-1451)
The marker of data series is changed after saving and loading json.(DOCXLS-1444, DOCXLS-1273)
The content should not be wrapped cell's value is a number.(DOCXLS-1430)

2.2.4

Bug Fixed

IndexOutOfRange exception is thrown when the same XLSX file is opened with parallel threads.(DOCXLS-1368)
Exception is thrown after loading ssjson and then save to PDF file.(DOCXLS-1382)
Column width changed after loading ssjson.(DOCXLS-1371)
Unable to fill shape with picture through API.(DOCXLS-1376)
Exception is thrown after loading ssjson and then invoke SetColumnWidth.(DOCXLS-1378)
Some text can not be rendered completedly in the exported PDF file.(DOCXLS-1404)
Unable to set a picture fill for shape.(DOCXLS-1376)
Exception is thrown when saving a worksheet to PDF file two time.(DOCXLS-1415)
The calculation result of INDIRECT function is different with Excel.(DOCXLS-1335)

2.2.3

Bug Fixed

Incorrect sparkine is rendered in the exported PDF file.(DOCXLS-1242)
InvalidFormulaException is thrown during loading ssjson.(DOCXLS-1266)
An error occurs while saving to PDF file.(DOCXLS-1303)
Out of memerory occurs while loading an Excel file.(DOCXLS-1279)
Stack overflow occurs while saving to PDF file.(DOCXLS-1315)
Exception is thrown while loading a xlsm file.(DOCXLS-1335)
Calculation results from GCExcel doesn't match the results from MSExcel.(DOCXLS-1322, DOCXLS-1323)
Cell Style is not correct after GcExcel toJSON and then SpreadJS fromJSON.(DOCXLS-1334)

2.2.2

Enhancements

Customer can overwrite current function implementation when registering a new custom function.(DOCXLS-1146)

Bug Fixed

Exception is thrown when exporting to json.(DOCXLS-1120)
Exception is thrown after adding a lot of hyperlinks then saving to Excel.(DOCXLS-1154)
Some text can not display completely in the exported pdf file.(DOCXLS-1156)
ArgumentOutOfRangeException is thrown on using Calculate method for a Workbook.(DOCXLS-1211)
If calculated result is too large(20+ digits) in the cell, the value acquired by GcExcel is horizontally reversed.(DOCXLS-1127)
There is a difference between the Excel display value and the Text value acquired by GcExcel.(DOCXLS-1128)
When a cell referenced by a formula is moved by "Cut" method, the formula is not automatically updated.(DOCXLS-1210)
The exported pdf and Excel file is corrupted when using GcExcel in multiple threading. (DOCXLS-1208)

2.2.1

Bug fixed

GcExcel throws exception when loading ssjon with invalid image source.(DOCXLS-1115)
Exception is thrown when opening an Excel with a lot of conditional formatting.(DOCXLS-1047)
Unable to export to PDF with a specified culture.(DOCXLS-1043)
The exported Excel file does not open correctly after loading ssjson.(DOCXLS-1076)
Redundant lines are rendered while exporting to PDF.(DOCXLS-1068)
SSJSON is not exported correctly if there are charts with duplicate names.(DOCXLS-1067)
PrintInfo.firstPageNumber in ssjson is always 1 even though it is not set for IWorksheet.PageSetup.(DOCXLS-1107)
Exception is thrown when opening certain Excel file.(DOCXLS-1104)
Exception is thrown when loading a ssjson containing font with line height.(DOCXLS-1110)
Leading apostrophe in a cell value is displayed as part of the cell text (not consistent with Excel behavior).(DOCXLS-1041)
Exception is thrown when loading ssjson with custom function.(DOCXLS-1044)
Copy behavior is inconsistent with Excel when the target range is larger than the source range.(DOCXLS-844)
Exception is thrown after opening certain Excel file and then export to ssjson.(DOCXLS-1116)
GcExcel can not export text with Simhei bold font.(DOCXLS-937).
Load ssjson with combobox cells and then export to Excel, the cell value of combobox cell is wrong in the exported Excel file.(DOCXLS-1106)

2.2.0

New Features

Export Excel files with shapes to pdf.
Cut/copy ranges between different workbooks.
Copy/move worksheet between different workbooks.
Control whether to adjust page breaks after inserting/deleting rows/columns.
Customize the row/column/cell delemiter when loading or saving csv file.
Set the tail repeated rows and right repeated columns when saving to pdf.
Support for paste options during copy and paste ranges.
Support IRange.find() and IRange.replace() methods.
Show or hide different kinds of pivot table styles.
Support for exporting pivot table styles to pdf.
Support setting the number format for each pivot field.
Japanese ruby can now be preserved after Excel I/O.
Get and customize each page settings before saving to pdf file.
Render any sheet range inside a pdf file.
Keep rows/columns togother when saving to pdf.
Save multiple workbooks to one pdf file.
Export specific pages from spreadsheet to pdf
Save multiple spreadsheet pages into one pdf page.
Support IRange.autoFit method to fit rows/columns.
Support IRange.FormulaArrayR1C1 property to get or set array formula in R1C1 format.
Support more import flags during open an Excel file.
OLEObject will be preserved after Excel I/O.
Support Shrink to fit, wrapped text while saving to pdf.

Bug fixed

GcExcel ignores 'ignore_empty' parameter in TEXTJOIN formula.(DOCXLS-970)
Large JSON file generated when using ToJson on a particular Workbook.(DOCXLS-968)
UsedRange.Value sets improper values to the range when Formula is set to Empty.(DOCXLS-956)

2.1.5

Bug Fixed

The column width, font size and picture's left position changes after JSON I/O with GcExcel.(DOCXLS-902)
The cell font changes after JSON I/O with GcExcel.(DOCXLS-921)
Visible property of secondary category axis returns incorrect value.(DOCXLS-849)
The major and minor units of value axis of stacked area chart return incorrect value.(DOCXLS-805)
The major and minor units of value axis for 100% stacked chart return incorrect value.(DOCXLS-800)
The data label's text returns incorrect value when Axis.DisplayUnit is set. (DOCXLS-768)
Exception is thrown on opening json file that contains invalid formula.(DOCXLS-948)

2.1.4

Enhancements

Performance of exporting a single worksheet to PDF was improved significantly.
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 setting.

Bug Fixed

The TintAndShade property does not work as expected if Color is set.(DOCXLS-872)
Cells containing SUBTOTAL formula do not return correct values.(DOCXLS-881)
InvalidFormulaException is thrown when opening Excel files saved by Open XML SDK.

2.1.3

Bug fixed

Image size specified in code does not apply on the image in the generated excel file (DOCXLS-787)
Setting formulas using @ symbol trims the column name.(DOCXLS-804)
Data label's separator does not return correct value.(DOCXLS-830)
Cell's value always return 0 when workbook.getEnableCalculation() is false.(DOCXLS-834)
Improve the performance of lookup functions when looking up string values.

2.1.2

Bug fixed

GcExcel is unable to load an Excel file consisting SUMPRODUCT formula.(DOCXLS-733)

2.1.1

Enhancements

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

Bug fixed

Page breaks are not adjusted after inserting/deleting rows or columns.(DOCXLS-728)
NullReferenceException is thrown after calling IRange.ClearContents().(DOCXLS-731)
NullReferenceException occurs on editing and saving XML generated by ClosedXML.(DOCXLS-726)
Refreshing a PivotTable through code and saving it, corrupts the generated Excel file.(DOCXLS-739)
ArgumentOutOfRangeException thrown on refreshing PivotTable present in some *.xlsx file.(DOCXLS-740)
On deleting the active sheet and saving the Excel file, an error dialog is observed on opening the saved Excel file.(DOCXLS-747)
StackOverflowException is thrown on invoking SetSourceData for Chart.(DOCXLS-724)
Color.Empty leaves black color on a cell.(DOCXLS-722)
Error is thrown while using FromJson method.(DOCXLS-734)
Using MAXIFS function results in #NAME? error in cell.(DOCXLS-749)

2.1.0

New Features

The performance of workbook.fromJson() method has been enhanced when the JSON file contains multiple styles.
Users can now import and export spreadsheets that contain macros. While these will not be executed, the macros will now be preserved when saving.
The support for loading and saving GrapeCity SpreadJS JSON files with shapes have been added.
Users can now set rich text format in the cells by applying different styles to the textual information entered in the cell.
While working with custom named styles, users can now modify an existing style and add it to the Styles collection.
Users can now export Excel files with vertical text to PDF.
Now, users can insert any background image to the worksheet including their organization logo, custom watermark or a wallpaper of their choice without any issues.
PDFBox can now be installed automatically for all versions of Eclipse Maven plugin.
Extensive support for the new Date Time API that has been introduced recently with JDK 8 has been provided.
The pivot table has been enhanced in order to support the date field group in Excel 2016.
Some overloads have been added for Open and Save methods to avoid passing file format.

Bug fixed

The Workbook.calculate() method now evaluates the cell values correctly.
While saving an Excel file to open XML format, the logical value of the cell is now calculated without any errors.

2.0.1

Enhancements

Improved the performance of Workbook.fromJson method, when json file contains lot of styles.
PDFBox now can be installed automatically for all versions of eclipse maven plugin.

Bug fixed

Exception thrown when Workbook opens the stream returned by HttpServletRequest.getInputStream().
Null pointer exception is thrown on saving to PDF, if the font used is null.
GcExcel throws exception on loading ssjson file with null values.
Merged range in table couldn't be rendered to pdf.
The hidden rows are still rendered to pdf after loading ssjson file.

Other Resources

Product Home Site: https://www.grapecity.com/documents-api-excel
Demo Site: https://www.grapecity.com/documents-api-excel/demos/
中文主页: https://www.grapecity.com.cn/developer/grapecitydocuments
中文示例站点: https://demo.grapecity.com.cn/documents-api-excel-java/demos/
Maven Repo Address: https://search.maven.org/artifact/com.grapecity.documents/gcexcel/

x-oss-byte / gcexcel-java Goto Github PK

gcexcel-java's Introduction

GrapeCity Documents for Excel, Java Edition

Resources

Other GrapeCity Document API Solutions

6.2.1

Fixed

6.2.0

Added

Fixed

6.1.4

Fixed

6.1.3

Fixed

6.1.2

Fixed

6.1.1

Fixed

6.1.0

Added

Fixed

6.0.6

Fixed

6.0.5

Fixed

6.0.4

Added

Fixed

6.0.3

Fixed

6.0.2

Fixed

6.0.1

Fixed

6.0.0

Breaking changes

Added

5.2.5

Fixed

5.2.4

Fixed

5.2.3

Fixed

5.2.2

Fixed

5.2.1

Fixed

5.2.0

Added

5.1.5

Fixed

5.1.4

Fixed

5.1.3

Fixed

5.1.2

Fixed

5.1.1

Fixed

5.1.0

Added

Fixed

5.0.5

Fixed

5.0.4

Fixed

5.0.3

Breaking changes

Added

Fixed

5.0.2

Fixed

5.0.1

Fixed

5.0.0

Added

Fixed

4.2.6

Fixed

4.2.5