Released: Mar 14, 2025

Updates in V25.3

Features

• Added support for setting multiple ranges for smartmarker.
• Added support for accessing array slicer in Excel smart marker template.
• Added support for calculating XMATCH function with multiple lookup values.
• Added support for accessing array element by index in Excel template.
• Added support for specifying SheetSet while converting XLSX to MD.

Fixes

• Workbook.calculateFormula gives the wrong result.
• LAMBDA functions in shared formula are calculated incorrectly when using relative references.
• XLOOKUP was calculated incorrectly with multiple lookup values and search mode -1.
• XLOOKUP was spilled incorrectly with multiple lookup values and invalid match mode or search mode.
• Issue with text encoding while creating PDF from .xlsb file.
• The specified SheetSet is ignored while converting XLSX to DOCX.
• The text covers the border when saving file to HTML.
• Incorrect cell background when exporting to HTML.
• Database Error/Name Conflict error coming while opening the saved Excel XLSM file.
• Missing random values and some cells colored green for some reason in Excel to PDF conversion.
• Get garbled characters of VBA after calling VbaModule.getCodes() method.
• Issue with rendering an array of objects in JSON data.
• The size of the cell embedding image has changed after resaving sample file and opening it in WPS.
• "com.aspose.cells.CellsException: For input string: '22860100000'" when rendering Excel file to PDF.
• Searching string value in cached cells range for functions such as XLOOKUP/XMATCH sometimes caused NPE.
• ArrayIndexOutOfBoundsException occurs when using JSON data as smartmarker data source.