XMATCH Function

Aspose.Cells for Python via .NET 24.5.0 enables efficiently locating values based on specific criteria within a range using the XMATCH function.

XOR Function

You can now perform logical exclusive OR operations for versatile calculations with the help of the XOR function within your spreadsheet processing apps running on Windows 64-bit.

Transpose Data of The Range

With the latest Python Excel API release, you can effortlessly reorganize data layouts for better analysis.

Enhanced Property Access for Advanced Filtering

Integrate enhanced access and gain greater control over filtering configurations in your Win x64 Python apps.

ReferredArea Determination

This release includes the ability to identify whether a ReferredArea represents an entire row or column.

Floor Function Behavior

Enjoy consistent #NUM! handling for negative numbers within the spreadsheet processing solutions.

Cell Metadata Export

Aspose.Cells for Python via .NET now allows extracting cell data for inclusion in PDF, image, and HTML formats on Windows x64 systems.

Font RGBA Color Processing

Build high-performance applications for manipulating Excel documents and handle font colors with style background colors seamlessly.

Picture Removal in Cells

The latest Python API release for 64-bit Windows helps you easily remove pictures when modifying cell values programmatically.

Improved Format Conversion

We have introduced broader support for various LoadFormat conversions to extensions in this version, which enables flawlessly converting Excel documents.

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.