XMATCH and XOR Functions
With Aspose.Cells for Python via .NET 24.5.0, Linux developers can efficiently locate values based on specific criteria within a range using the XMATCH function and perform logical exclusive OR operations for diverse calculations using the XOR function.
Arrange Data in Range
The latest Python Excel API version allows effortless reorganization of data layouts for improved analysis.
Optimized Property Access and Filtering
You can experience optimized property access and get finer control over filtering configurations in your Python apps running on Linux systems.
Identify ReferredArea
The ability to determine whether a ReferredArea represents an entire row or column is available in this Excel API release.
Improved Floor Function
The floor function lets developers manage #NUM! negative numbers consistently within the spreadsheet manipulation applications.
Aspose.Cells for Python via .NET now allows extracting cell data for inclusion in PDFs, images, and HTML formats on Linux systems.
Delete Pictures from Cells
Easily remove pictures from within workbook cells when modifying cell values programmatically using this version of the Python spreadsheet library.
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.