Enhancements from the Previous Release

• Added the ‘ShowValuesAs’ option for the ‘Values’ field in Pivot Table.
• Added NumbersFitMode enumeration to provide an option to either mask or show the entire number or date.
• Added support for modifying passwords of Excel documents.
• Added support of calculated fields in Pivot Table.
• Added support for JSON data source for template language.
• Added support for showing #N/A as an empty cell in charts.
• Added convertToRange method to convert a table into regular ranges without losing table style and data.
• Added support for Cell function.
• Added ICsvParser interface which uses the Parse method to define custom rules for parsing the text.
• Added support for Pivot Table views.
• Added support for importing data functions of Table/Range/Sheet.
• Added support to include TableSheet in the list of supported SpreadJS features.

Resolved Issues

• Resolved an issue of formulas while converting the imported Excel to JSON.
• Resolved a template language issue where an "Out of memory" exception was thrown while using a template in multi-thread.
• Resolved a template language issue of the layout being incorrect while the xlsx file is exported using a template.
• Resolved a template language issue of incorrect sum function when exported to the xlsx file.
• Resolved a template language issue for the cell values which are not expected in the exported Excel file.
• Resolved a template language issue where the IF formula was lost in the exported xlsx file.
• Resolved a template language issue where the formula was not expanded correctly in the exported xlsx file.
• Resolved a template language issue where the result of the sum function was exported incorrectly.
• Resolved an issue where IndexOutOfRangeException was thrown on exporting radar chart to PDF file.
• Resolved an issue where the legend of the series was not shown in the exported PDF file.
• Resolved an issue where InvalidFormulaException is thrown on creating a table when “’” was there in the table column’s name.
• Resolved an issue for exporting extra characters in data validation in an exported JSON file.
• Resolved an issue for throwing NullReferenceException on setting series formula which contains bubble size info.
• Resolved an issue of getting the incorrect layout of a checkbox list in exported excel file.