Released: Feb 14, 2025

Updates in V25.2

Features

• Added support for calculating INDIRECT where ref text of defined name is "#".
• Provided all sheet names which reference multiple worksheets in a formula.
• Added support for setting a cell to rich text when saving a workbook with LightCells.
• Provided async APIs for time-consuming operations when loading, saving and during formula calculation.
• Added support for reading DIF format files.
• Added support for reading and writing DBF (dBase) format files.
• Added support for WPS compatible embedded images.
• Added support for keeping comments from the query formula.
• Enhanced applying rules of pivot table conditional formatting.

Fixes

• Position of bentConnector shape is incorrect.
• Text on shape displaced when converted to Image.
• Data source of Web Pivot was returned with https instead of what is stored in the file.
• The program gets stuck when converting file to PDF.
• Incorrect text position in curved arrow.
• Data table not calculating correctly after calling CalculateFormula method.
• CalculateFormula causes "#VALUE!" error which is not seen in MS Excel.
• Criteria for range data in array formula was not calculated correctly.
• CELL function gave different value from MS Excel when the "reference" parameter has not been specified.
• NullReferenceException at Workbook.CalculateFormula() method.
• XLookup formulas are not calculating correctly.
• Rank formula showing #VALUE when a non-consecutive ref range is used.
• HTML rich text containing bullets or next line not working with LightCellDataProvider in the output Excel file.
• Incorrect data validation rule value for large number.
• Chart's alignment and gridlines issue.
• Optimize the display position of datalabels in chart.
• Optimize the axis line color of the x-axis and y-axis.
• Fixed the color of the PlotArea border for chart to image.
• Callouts in chart are misaligned when converting Chart to image.
• Rectangles inside chart are not positioned correctly in SVG.
• Y-axis labels alignment is wrong when it is more than one line while converting chart to PNG.
• Data label has line break error when converting chart to image.
• Aspose.Cells 25.1.1 doesn't work on AlmaLinux/Redhat Enterprise 8.10.
• Double underline is not doubled (Excel to XPS conversion).
• Words are not super-scripted in Excel to XPS conversion.
• Appearance differs depending on the pattern in Excel to XPS conversion.
• Invalid vertical alignment of text in converted HTML.
• Incorrect function type and items for PowerQuery.
• Conditional format was applied to unexpected field.
• Saving XLSX creates corrupted file in Excel.
• Placing the picture is disorienting the Excel file.
• Unable to generate the PDF from XLSX file.
• Power Queries lost after saving Workbook.
• Custom function defined in Name with LAMBDA caused Exception when skipping calculation by custom calculation engine.
• Exception "Index was outside the bounds of the array" when saving the Excel file to PDF.
• NullReferenceException while reading PowerQuery.
• Exception "Invalid Power query formula definition" while retrieving PowerQuery from the workbook.