macOS developers, rejoice! Aspose.Cells for Node.js via C++ 24.8 is here, and it provides multiple updates to pivot tables, charts, formulas, and more. Develop robust Excel data manipulation apps targetting macOS x64 architecture.

Key Highlights

Boost Excel Data Manipulation on MacOS

Update your Node.js applications with this release of our spreadsheet data manipulation API. Developers can conveniently process, create, and modify spreadsheets on macOS x64-based systems.

Manage Pivot Table with Ease

Sort pivot tables by specific items and fields when handling pivot tables in your applications using this upgrade.

Advanced Formula Editing

Edit formulas with blank spaces and accurately calculate YEARFRAC to empower your portfolio of Node.js spreadsheet applications.

Rendering Charts on Apple Mac

Aspose.Cells for Node.js via C++ 24.8 offers enhanced chart appearance and fidelity. Seamlessly render and export charts with high-fidelity on macOS x64 with this version.

Effortless PDF Export

Enjoy accurate PDF conversion and improved hyperlink management to export your Excel spreadsheets as PDF documents while 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.