Released: Dec 14, 2021

Updates in 5.0.0

Features

• Added support for Linked Pictures - Combining charts, data tables, conditional formatting, etc. all in one sheet can be complex. Since the size of these elements is often not uniform, presenting them in a single dashboard sheet can be difficult to accommodate. A linked picture can be created to the actual data/table/chart in your final dashboard.
• Added the ability to print documents directly to a physical Printer.
• Added support for Table expandBoundRows API which sets the policy when the data bound to the table changes.
• Added support for Microsoft Excel threaded comments which allow you to reply to inline or nested comments, as well as string several comments, together to form a conversation style thread.
• Added the Import data function which only imports data from Microsoft Excel files, without loading the whole object model.
• Added support for workbook views.
• Added support for adding dynamic array formulas to Excel files through code using the new Formula2 property.
• Added support for GETPIVOTDATA Function.

Fixes

• The result of NOW() function is incorrect.
• There is a large gap on the top of the cell in exported PDF file.
• NullPointerException is thrown on calling 'Workbook.Open()' method.
• The cell style is lost in the exported JSON file when compared with the original JSON file.
• The pattern fill settings of charts are not rendered in exported PDF file.
• The text with "\n" in charts is shifted in exported PDF file.
• The cell values are incorrect in exported CSV file.
• The cell styles are incorrect in exported Excel file after loading the JSON file.
• The exported Excel file is corrupted when copying a worksheet from another worksheet.
• The result of 'TEXT' function is incorrect.
• ArrayIndexOutOfBoundsException is thrown on calling 'Workbook.ToJson()' method.