Great news for Node.js developers! Aspose.Cells for Node.js via C++ 24.8 is now available for macOS ARM64/M1-powered applications. Integrate improved pivot table functionality, charts, formulas, and more into your Excel data manipulation applications.
Key Highlights
Manipulate Excel Spreadsheets Data on Apple Mac
Upgrade the Node.js spreadsheet processing applications with important Excel data manipulation features using the latest version of our library. Users can now process, create, and edit spreadsheets conveniently on macOS M1-based systems.
Pivot Table Management
You can sort pivot tables by specific items and fields while incorporating pivot tables into your applications with this API update.
Editing formulas with blank spaces is easier than ever with Aspose.Cells for Node.js via C++ 24.8. Accurately calculate YEARFRAC and enrich your portfolio of Node.js spreadsheet solutions.
Render Charts on macOS
Enhanced chart appearance and fidelity are available in the newest library version. Easily render and export charts with high quality on macOS ARM64/M1 using this version.
High-fidelity PDF Export
Developers can accurately convert PDFs in Node.js and experience refined hyperlink management to export their Excel spreadsheets as PDF documents when handling hyperlinks.
Full List of Changes
New Features:
- Conveniently edit formulas with blank spaces in your Node.js apps.
- Support for sorting by specific pivot items is also available.
- We have added support for the
VALUETOTEXT function. - You can now sort pivot tables by pivot field items.
Improvements:
- The worksheet-saving functionality has been optimized to avoid files getting corrupted.
- You can experience enhanced rendering of merged cells and blank rows.
- It is now possible to prevent data loss during pivot table area formatting.
Bug Fixes
In this version of Aspose.Cells for Node.js via C++, we have addressed various issues related to:
- PDF conversion problems, including incorrect character positioning and missing hyperlinks.
- Chart rendering, including missing labels, incorrect alignment, and scattered chart gaps.
- Formula calculation errors.
- Spreadsheet conversion exceptions
- Data import/export problems
- Pivot table refreshing
- Encrypted workbook properties.
Public API and Backwards Incompatible Changes
- Added enum
MergedCellsShrinkType to control merged cell behavior during blank row/column deletion. - Introduced methods to get and set merged cell shrink type in
DeleteBlankOptions. - Added
EquationNodeType enums for LowerLimit, UpperLimit, and Limit functions. - Implemented
EquationNode.ToLaTeX() and EquationNode.ToMathML() methods. - Introduced
SortOrder.Natural enum for preserving original data order in specific scenarios. - Added methods to encrypt/decrypt document properties in SaveOptions.
- Enhanced
SortBy methods for flexible pivot table sorting. - Provided the
GetSortSetting() method in PivotField to retrieve sorting settings. - Added
Clear() method in SlicerCollection to clear all slicers. - Introduced the
GetSourceType() method in PivotTable to get data source type. - Implemented
ShowDatail() method in PivotTable to convert detail to a table. - Added
GetEncodeEntityAsCode() and SetEncodeEntityAsCode() methods in HtmlSaveOptions for HTML encoding control. - Introduced
GetSchemas() and SetSchemas() methods in JsonSaveOptions for JSON schema handling.
You can view the list of all new features, enhancements, and bug fixes introduced in this release by visiting Aspose.Cells for Node.js via C++ 24.8 Release Notes.