Enhancements from the Previous Release

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

• Dynamic Array Formulas along with the new functions:
  • FILTER
  • RANDARRAY
  • SEQUENCE
  • SINGLE
  • SORT
  • SORTBY
  • UNIQUE
• Support for new Calc Engine functions:
  • WEBSERVICE
  • FILTERXML
  • ASC
  • DBCS
  • JIS
  • XLOOKUP
  • XMATCH
• External workbook links from the web.
• Document properties for workbook.
• Retrieve the row and column grouping information.
• Copy hidden rows to new range.
• Control the size of the exported json file.
• Support for margin settings for text in a shape.
• Expand or Collapse grouped items in a Pivot Table.
• More features for SpreadJS integration: RowCount or ColumnCount, get URL of a picture, Pivot Table for json I/O, etc.

Resolved Issues

The following issues have been resolved since the last release.

• NullReference exception is thrown while adding a row in a table.
• When MarkerStyle.None is set for ISeries.MarkerStyle, the chart is not exported correctly in Excel.
• When a JSON file is opened and exported to another JSON file, the picture floating object is lost.
• Exported xlsx file does not meet the OpenXml standard if it contains a picture shape.
• Exception is thrown on saving an Excel file.
• When the pagebreak of template properties is set as true, page breaks are added before the field
• Dynamic array formula does not generate the correct value.
• Exception is thrown on opening a JSON file.
• Exception is thrown on calling the 'ToJson' method.