Breaking Changes

• Removed System.Drawing.Common package dependency.
• Duplex property of PrintOutOptions class has been changed to netstandard2.0 and net6.0.

Enhancements from the Previous Release

• Added support for asynchronous IMAGE function.
• Added support for Label and Value filters in Pivot Table.
• Added support for pixel-based rendering in PDF and image export.
• Added support for the UID attribute when loading and saving an Excel file.
• Added support for filtering data from single or multiple data sources in Template Language.
• Added support for the display of a filter button in the column header for SJS and SSJSON export.
• Added support for LINESPARKLINE, COLUMNSPARKLINE, and WINLOSSSPARKLINE functions.
• Added support for Goal Seek functionality.
• Added support for customizing border style in PDF export.
• Added support for FromSJSJson API to load a single SJS JSON file.

Resolved Issues

• The image size is not the same as the PDF file exported by SpreadJS.
• The exported XLSM file is corrupted when opened in MSExcel.
• When a specific xlsx file is loaded and saved, the saved file is corrupted.
• Wrapped text cannot be fully displayed in the exported PDF file.
• The pagination results in the exported PDF file are inconsistent with SpreadJS.
• The rotated circular shapes are distorted in the exported image files.
• The line breaks in the exported PDF file are inconsistent with the PDF file exported by SpreadJS.
• The size of the QR code in the exported PDF file is not the same as in SpreadJS.
• The borders of some cells are lost in the exported Excel file after loading the SJS file.
• The cell format is changed in the exported SJS file and Excel file after loading the original SJS file.
• The cell format is changed in the exported SJS file after inserting specific rows.
• The page margins in the exported PDF file are inconsistent with SpreadJS.
• The seal is stretched in the exported PDF file.
• The cell background image is inconsistent with SpreadJS in the exported PDF file.
• The filtering status of PivotTable in the exported Excel file is changed.
• The table border in the exported PDF file is thicker than the PDF exported by SpreadJS.
• Some whitespace characters are missing in the exported PDF file.
• The table style is changed in the exported SJS file.
• The border style is changed in the exported SJS file.
• Exception is thrown on saving an Excel file containing charts to a PDF file with Norway culture.
• Exception is thrown on refreshing the PivotTable.
• The font size is changed in the exported SJS file after loading the original SJS file.
• The conditional format is incorrect in the exported SJS file.
• Incorrect value returned from array formula when calculation engine is off.
• The table style in the exported PDF file is incorrect.
• Some cell values are not exported in the Excel file when the license is not set.
• The result of the LOG function is incorrect.
• Exception is thrown on setting the orientation of PivotField to column field and row field.
• The result of the SEARCH function is incorrect.