Upgrade your Node.js (legacy) Excel data manipulation applications with pivot table handling, enriched charts, formulas, and more with Aspose.Cells for Node.js (legacy) via C++ 24.8 release.

Key Highlights

Excel Data Manipulation Boost

Boost your (legacy) Node.js applications with the latest release of our spreadsheet processing library. With this update, developers can easily process, generate, and edit Excel spreadsheets on Linux x64-based systems.

Handle Pivot Table with Ease

Conveniently sort pivot tables by particular items and fields with the latest Node.js Excel manipulation API release. Handle pivot tables dynamically in your applications with this upgrade.

Formula Editing Made Easy

Modify formulas with blank spaces and precisely calculate YEARFRAC to enhance your portfolio of Node.js spreadsheet solutions.

Render Charts in Linux Applications

Aspose.Cells for Node.js (legacy) via C++ 24.8 delivers refined chart appearance and fidelity. You can render and export high-fidelity charts on Linux x64 with this version.

High-performance PDF Export

Experience fine-tuned PDF conversion accuracy and hyperlink management, to seamlessly export your Excel spreadsheets as professional-looking PDFs 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.