Breaking Changes from the Previous Release

• The new interface Workbook.ImportData(string fileName, string sourceName) overwrites the previous ImportData(string fileName, string worksheetName).

  • When source is mentioned directly in the form of worksheet name, the code remains compatible with the previous implementation.
  • After version upgrade, if the method is called along with the parameter name "worksheetName: "xxxx"", the compilation fails and user needs to modify the parameter name to "sourceName".

Enhancements from the Previous Release

• Added ‘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 password 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 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 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 IF formula was lost in the exported xlsx file.
• Resolved a template language issue where formula was not expanded correctly in the exported xlsx file.
• Resolved a template language issue where 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 incorrect layout of a checkbox list in exported excel file.