Enhancements from the Previous Release

The following features has been added with this version of the product:

• Support for charts, images and conditional formatting in Templates.
• Support exporting formulas in Templates
• Support global settings in Templates.
• Support converting Excel objects(chart or 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 and 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.

Resolved Issues

The following issues have been resolved since the last release.

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