Released: Feb 11, 2022

Updates in V22.2

Features

• Added the ability to extract all the NameCollections of a particular worksheet.
• Added StandardHeightInch property to Cells class.

Fixes

• Various formatting and other shapes rendering issues in PDF and HTML of Excel file.
• Some shapes are not rendered properly in Excel to PDF conversion.
• Invalid value for external reference in DataSource field of Pivot Table.
• Regression: CSV to PDF conversion not working.
• Empty CellsArea array returned for CSV/TSV files.
• Finnish language - Numbers formatted as Percentage are missing the space before the percent symbol.
• Aspose.cell failed to collect workbook revision logs.
• Missing page after conversion of an Excel file to PDF.
• Cell type is wrong after exporting to html and reloading the exported html.
• Chart.ToImage() Thread Safety Issue.
• Regression: Converting to HTML numbers not rendered correctly.
• Cell background becomes black after converting to pdf.
• Chart legend is reverted when saving Excel to PDF.
• By inserting rows in the sheet, the series of the charts loose their XValues.
• Chart.SetChartDataRange(area, false) does not recognize merged cells.
• Range to PNG: output not as expected.
• Unprotected OLE Objects on a protected sheet becomes protected after save.
• Detect the file format of special html file.
• ActiveX control buttons are converted to shapes and file is corrupted for XLS to XLSM and then back to XLS.
• Table column lines missing when converting specific files to HTML.
• Cells.RemoveDuplicates throws “System.IndexOutOfRangeException: Index was outside the bounds of the array”.
• Input string was not in a correct format. exception when open XLS file.
• This file’s format is not supported or you don’t specify a correct format. exception when open XLS file.
• ExportXml with XML Map throws “NullReferenceException” for another complex file.
• NullReferenceException while converting XLSM file to XLS.