XMATCH and XOR Functions

Developers working on the macOS x64 platform can now locate values based on specific criteria within a range using the XMATCH function and perform logical exclusive OR operations for diverse calculations with the XOR function.

Data Management in Range

Aspose.Cells for Python via .NET 24.5.0 allows effortless reorganization of data layouts for improved analysis.

Enhanced Filtering with Property Access

Experience enhanced property access and get finer control over filtering configurations in Python apps running on macOS x64 systems.

ReferredArea Identification

Identify whether a ReferredArea represents an entire row or column in the latest Python Excel API update.

Floor Function Enhancements

Different improvements have been added to the floor function, which lets developers manage #NUM! negative numbers consistently within the spreadsheet manipulation applications.

Export Cell Metadata

Aspose.Cells for Python via .NET v24.5.0 supports extracting cell data for inclusion in PDFs, images, and HTML formats on macOS x64 systems.

Deleting Pictures from Cells

You can easily remove pictures from within the cells when editing cell values programmatically using this version of the Python spreadsheet library.

Upgraded Format Conversion

This Python API release includes support for various LoadFormat conversions to extensions has been extended, enabling flawless Excel document export.

Bug Fixes:

• Addressed SmartArt inner shape property issues during Excel to PDF rendering.
• Corrected text box height calculation for Japanese text.
• Resolved SVG parsing errors when converting HTML to XLSX.
• Enhanced chart rendering accuracy during XLSX to PDF conversion.
• Fixed INDEX(FILTER(?);1) behavior within LAMBDA functions.
• Ensured correct currency formatting for negative Canadian values.
• Rectified ISNA(INDIRECT()) calculation behavior.
• Improved formula evaluation accuracy.
• Addressed issues with Workbook.RefreshDynamicArrayFormulas().
• Prevented character truncation in lightweight mode.
• Corrected typos in API for range merging.
• Resolved chart display errors during SheetRender.ToImage calls.
• Maintained consistent text rendering when converting charts to images.
• Fixed Excel Combo chart control rendering issues.
• Addressed chart title rendering inconsistencies with FarEastName and LatinName.
• Enabled conditional formatting color scale display in GridWeb.
• Preserved image headers when saving Excel files as PDFs.
• Improved Excel page splitting behavior in PDF output.
• Enhanced skewed cell rendering during HTML conversion.
• Resolved HTML table element conversion issues when loading HTML.

You can view the list of all new features, enhancements, and bug fixes introduced in this release by visiting Aspose.Cells for Python via .NET 24.5.0 Release Notes.