Release Notes for Version 2.1.0

Enhancements from the Previous Release

The following features has been added with this version of the product.

• The support for .NET Framework 4.6.1 Target Framework has now been added to the package.
• Users can now import and export spreadsheets that contain macros. While these will not be executed, the macros will now be preserved when saving.
• The support for loading and saving SpreadJS JSON files with shapes have been added.
• Users can now set rich text format in the cells by applying different styles to the textual information entered in the cell.
• While working with custom named styles, users can now modify an existing style and add it to the Styles collection.
• Users can now export Excel files with vertical text to PDF.
• Now, users can insert any background image to the worksheet including their organization logo, custom watermark or a wallpaper of their choice without any issues.
• The pivot table has been enhanced in order to support the date field group in Excel 2016.
• Some overloads have been added for Open and Save methods to avoid passing file format.

Resolved Issues

The following issues have been resolved since the last release.

• The Workbook.Calculate() method now evaluates the cell values correctly.
• While saving an Excel file to open XML format, the logical value of the cell is now calculated without any errors.
• After configuring the Workbook.FontsFolderPath property, the text in the file completely renders to PDF without any issues.
• Loading SSJSON file with null values no longer throws an exception.
• While saving an Excel file to PDF, the merged range in a table now renders appropriately without any issues.
• Loading the SSJSON file now renders hidden rows correctly while saving an Excel file to PDF.