[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

Release Notes for Version 5.1.0

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.