Utilize XMATCH and XOR Functions on Apple Mac

Users working on the macOS ARM64/M1 platforms can now find 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.

Range Data Management

Aspose.Cells for Python via .NET 24.5.0 allows developers to reorganize data layouts effortlessly for improved analytics

Filtering Optimizations

We have added enhanced property access in this Python Excel API update giving you finer control over filtering configurations in Python apps running on macOS M1 machines.

ReferredArea Identification

Determine whether a ReferredArea represents an entire row or column in this update.

Floor Function Improvements

Various updates have been added to the floor function, helping developers manage #NUM! negative numbers consistently within the spreadsheet manipulation applications.

Exporting Metadata of Cells

Version 24.5.0 of the Aspose.Cells for Python via .NET API extracts cell data for inclusion in PDFs, images, and HTML formats on macOS ARM64 systems.

Deleting Pictures from Cells

Easily purge workbook cells of pictures when editing cell values programmatically using this release of the Python spreadsheet library.

Format Conversion Enhancements

This release delivers support for various LoadFormat conversions, 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.