Experience flawless Excel data manipulation with Aspose.Cells for Node.js via C++ 24.8 on Linux x64. Equip your Node.js applications with dynamic pivot table handling, charts, formulas, and more.

Key Highlights

Manipulate Excel Data on Linux

Supercharge your applications with the latest release of the Node.js spreadsheets API. This update helps developers effortlessly process, generate, and edit Excel spreadsheets on Linux x64-based systems.

Pivot Table Management

The capability to easily sort pivot tables by specific items and fields is introduced in the latest release, providing flexibility when managing pivot tables in your applications.

Empowered Formula Editing

Seamlessly edit formulas with blank spaces and accurately calculate YEARFRAC to improve your portfolio of spreadsheet manipulation Node.js solutions.

Refined Chart Rendering

Aspose.Cells for Node.js via C++ 24.8 boasts fine-tuned chart appearance and fidelity. You can view and export high-fidelity charts on Linux x64-powered machines with this update.

Matchless PDF Export

Enjoy unmatched PDF conversion accuracy and hyperlink handling, to accurately export your spreadsheets as high-quality PDFs while easily handling hyperlinks.

Full List of Changes

New Features:

• Conveniently edit formulas with blank spaces in your Node.js apps.
• 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.

Improvements:

• The worksheet-saving functionality has been optimized to avoid files getting corrupted.
• It is now possible to prevent data loss during pivot table area formatting.
• 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:

• 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.