Aspose.Cells for Node.js via C++ 24.8 (Windows 64-bit) is packed with new features and enhancements to enable precision and speed in manipulating Excel spreadsheets. This release brings robust functionalities for pivot tables, charts, formulas, and more.

Key Highlights

Excel Data Manipulation

Build feature-rich Excel data manipulation apps with the latest Node.js spreadsheets API release. It allows developers to seamlessly process, create, and modify Excel spreadsheets on Win64-based systems.

Pivot Table Enhancements

We have introduced the capability to easily sort pivot tables by specific items and fields, offering flexibility while handling pivot tables in your applications.

Formula Support

You can now edit formulas with blank spaces and accurately calculate YEARFRAC to enhance your portfolio of spreadsheet processing Node.js solutions.

Chart Rendering

Chart appearance and fidelity have been fine-tuned in Aspose.Cells for Node.js via C++ 24.8. This update ensures you can view and export high-quality charts on Win x64-powered machines.

PDF Export

PDF conversion accuracy and hyperlink handling features are enriched with updated functionality. You can save the spreadsheets as high-quality PDFs while handling hyperlinks with ease.

Full List of Changes

New Features:

• We have added support for the VALUETOTEXT function.
• You can now sort pivot tables by pivot field items.
• Support for sorting by specific pivot items is also available.
• Conveniently edit formulas with blank spaces in your Node.js apps.

Improvements:

• It is now possible to prevent data loss during pivot table area formatting.
• The worksheet-saving functionality has been optimized to avoid files getting corrupted.
• You can experience enhanced rendering of merged cells and blank rows.

Bug Fixes

In this version of Aspose.Cells for Node.js via C++, we have addressed various issues related to:

• Chart rendering, including missing labels, incorrect alignment, and scattered chart gaps.
• PDF conversion problems, including incorrect character positioning and missing hyperlinks.
• 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.