Released: Jan 10, 2023

Updates in V23.1

Features

• You can now 'interrupt' when calculating formulas.
• Change the default style of a row/column without changing the style of existing cells.
• Support for new functions: HSTACK and VSTACK.
• Added support for reading the author and date/time of revisions.
• Added support for CHOOSECOLS and CHOOSEROWS Microsoft Excel 365 formulas.
• Enhanced 'SaveOptions.HasHeaderRow' when converting XLSX to JSON.

Fixes

• JSON value is missing when a sheet is empty.
• JsonSaveOptions.SkipEmptyRows is not working properly.
• Always export Excel as JObject when converting Excel to JSON.
• Shape fill is not right while converting to PDF.
• Shapes and pictures are deformed in Excel to PDF rendering after copying sheet.
• Incorrect shadow when converting image to PDF.
• Arrow sign shift error when converting Excel file to PDF.
• SUMIF returns 4 instead of 0 by Aspose.Cells formula calculation engine.
• Image converted by chart is not same as MS Excel.
• Security Vulnerability - CVE-2021-24112.
• Image to SVG - Text is overlapped for the horizontal bar for Date labels of the chart image.
• Thicker lines and missing border when saving XLSB to an Image.
• Excel file (XLS) is corrupted upon re-saving via Aspose.Cells.
• Support filter criteria when opening and saving HTML.
• The range of the pivottable is not same as MS Excel when converting pivottable to PDF.
• The contents and formatting of the sheets are changed while copying.
• Exception “Item has already been added. " on saving XLS to XLSX.
• Object reference not set to an instance of an object. exception when open ODS file.
• Index out of range exception occurs after copying sheet and converting to PDF.
• Exception “File is corrupted” when loading an XLSX file having a hyperlink.