Enhancements from the Previous Release
The following features have been added with this version of the product:
- 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.
The following performance enhancements have been done in this version of the product:
- Excel Template processing performance has been improved.
- Calculation Engine's performance has been improved while setting values.
Resolved Issues
The following issues have been resolved since the last release.
- Performance issue when updating data in Excel using GcExcel API.
- When the worksheet contains a shape, the row height cannot be changed.
- The formula =TEXT("12345","[dbnum2]") does not work.
- The font is bold after exporting to PDF.
- ROUNDUP result is different with Excel.
- GcExcel formula result is different with Excel.
- COUNTIF result is different with Excel.
- After saving to Excel, the hidden rows are displayed.
- Conditional Format is not exported in PDF/HTML.
- The position of radio button list is wrong in the exported PDF.
- After setting the cell style in two ways, the results are different.
- Using IRange.HasFormula and IRange.Value together, degrades performance.
- Mixed order of Set and Get cell values degrades performance.