Released: Mar 10, 2022

Updates in V22.3

Features

• Added support for sorting PivotFields using the values in a selected row/column.
• Added support for re-calculating cells that reference a defined name.
• Added SaveFormat.Ots and SaveFormat.Xlt enums.
• Added support for setting range borders.

Fixes

• Pivot table not sorting on refresh.
• Deleting worksheet deletes Slicers.
• Regression: After copying range of cells formulas are lost.
• Conditionally formatted fields are not colored in the right color.
• Formulas were not calculated correctly.
• Range to PNG: output not as expected.
• Regression: XLS to PDF: header not rendered correctly.
• Converting .XLSX to PDF takes long time and produces extra pages.
• Numeric values or numbers followed by line items are not visible in the resultant pdf.
• Workbook.ExportXml returns only first row of Table data.
• Xml Import unhides previously hidden columns in template.
• Content is not rendered properly in Excel to PDF conversion.
• Wrapped Texts do not work on Charts when generating PDF.
• Horizontal axis labels of chart are not rendered properly in the output PDF.
• Issue with Collapse and Expand multi level groups.
• ODS to PDF conversion incorrect.
• Custom “Text” formatting is not applied in the XLS file.
• ImportTableOptions.IsHtmlString property is not outputting links correctly.
• Load HTML in workbook not working.
• Issue with color for conditionally formatted cells in the output XLSX file.
• Issue when setting embedded license to Produce Single file in .NET 6.0 application.
• No forward slashes but backward slashes for external links with URL.
• System.ArgumentException: Row number or column number cannot be zero when importing JSON data as table.
• ArgumentOutOfRangeException while trying to get Formula of a cell.