Released: Jan 7, 2022

Updates in V22.1

Features

• Added support for returning original indices of sorted rows/columns.
• Added the ability to set print job name, with PrinterSettings, while rendering to printer.
• Added the ability to ignore hidden rows and columns when getting Cells.MaxDisplayRange.

Fixes

• Incorrect result for calculating FREQUENCY function in array formula.
• Unsupported function: CUBESET.
• Different behavior about collapsing and expanding multi level groups.
• BMP image files don’t display in header/footer.
• XLS to PDF: Conversion stalls with Out of Memory.
• The line spacing becomes narrower - Excel to PDF conversion.
• Cell colors disappear after conversion to PDF.
• How to add bubble next to Chart title & Chart Axis Text.
• Rich text values of cells may get lost with MemoryPreference mode.
• The name of the cells is changed during recording.
• Local range name property FullText is not escaped if parent worksheet has an apostrophe.
• GridWeb fails to load /save from cache for .csv file.
• Printing Excel file renders two pages instead of one page.
• Worksheet contents are not rendered properly in Excel to PDF conversion.
• The print position goes up as the page is followed - Excel to PDF conversion.
• The characters are missing - Excel to PDF conversion.
• Wrong max/min value calculated from charts by Aspose.Cells.
• The output chart is not displayed correctly after changing the series type.
• Legend in the Waterfall Chart can’t be deleted or hidden.
• Different behavior regarding collapse and expand multi level row groups.
• XLSX to HTML undeclared variable “node” in script.
• AutoFitMergedCellsType.EachLine is not working for Auto fitting columns.
• Phonetic Guide Font is changed after saving the file.
• Some text are lost when saving as HTML.
• Exception on opening the XSLB file.
• StackOverflowException while deleting empty columns.
• Conversion to HTML exception “Unsupported function: CUBESET”.
• Exception on opening the XSLX file via Aspose.Cells.
• NullReferenceException when comparing FillFormat.
• Exception on opening an XLSB file.
• Chart to EMF incorrect axis values.