Browse our Products

Aspose.Cells for Node.js via C++ 24.10 Release Notes

KeySummaryCategory
CELLSCPP-1108Supports for implementing custom functions through Aspose.Cells API using AbstractCalculationEngine functionality.New Feature
CELLSCPP-1109Supports using Object type objects as function parametersNew Feature
CELLSCPP-1110Supports functions that return Object type objectsNew Feature
CELLSNET-56659Rows covered by shapes are deleted when deleting blank rowsNew Feature
CELLSNET-56727Support to delete blank rows/columns between user specified rangeNew Feature
CELLSNET-56780Support to get the source of the pivot table from corresponding external connectionNew Feature
CELLSNET-56781Support to get the source of DataModelConnectionNew Feature
CELLSNET-56827Support creating compact pivot tablesNew Feature
CELLSNET-56472Writing to range causes hang if automatic calculating formulasEnhancement
CELLSNET-56784Invalid cell name exception occurs when parsing OleObjectEnhancement
CELLSNET-56807Support formatting date as 1900-2-29 to mimic ms excel’s behaviorEnhancement
CELLSNET-55260Enahance converting pivot area to rangeEnhancement
CELLSNET-56793Append file protocol to the address of shared directory/file when setting hyperlinkEnhancement
CELLSNET-56866Corrupted xlsx file when converting from xls with olap pivot tablesEnhancement
CELLSNET-56696Lock aspect ratio is still not selected when setting the IsAspectRatioLocked property to trueBug
CELLSNET-56785Shape to image error when converting file to pdfBug
CELLSNET-56671Custom function not parsed into formula when loading excel fileBug
CELLSNET-56774Custom Format is removing negative sign for a value fieldBug
CELLSNET-56775Generated xls file is corrupted after re-saving from xlsxBug
CELLSNET-56864Default value of DeleteBlankOptions.MergedCellsShrinkType is expected as KeepHeaderOnly but actually was NoneBug
CELLSNET-56865Changing DeleteBlankOptions.EmptyFormulaValueAsBlank takes no effectBug
CELLSNET-56879SUM with XLOOKUP function disappears in sheet after calling Workbook.CalculateFormula methodBug
CELLSNET-56880Workbook.RefreshDynamicArrayFormulas issue(s)Bug
CELLSNET-56920MATCH function does not give the correct value when search value in result of HSTACK functionBug
CELLSNET-56921Calculated results of some formulas are different from ms excelBug
CELLSNET-56614Histogram cannot display correctly when converting files to PDFBug
CELLSNET-56615Column chart cannot display correctly when converting files to PDFBug
CELLSNET-56628Bubble chart axis display error when converting file to PDFBug
CELLSNET-56743Chart.Calculate did not populate all points DataLabels Text with UpdateAllPoints=trueBug
CELLSNET-56761Text and chart overlap when converting chart to emfBug
CELLSNET-56778Chart was not rendered properlyBug
CELLSNET-56797Combo Chart was not rendered properlyBug
CELLSNET-56757Horizontal lines disappeared and text overlapped when converting Excel file to PDFBug
CELLSNET-56776Adding a bookmark with SecurityOptions creates a garbled text PDF bookmarkBug
CELLSNET-56777Setting a multiline watermark to the PDF with \n or \r\n does not work properlyBug
CELLSNET-56794Save as HTML places shape on different placeBug
CELLSNET-56108Lost OLAP pivottables when converting xlsb to xlsxBug
CELLSNET-56650Some issues with Excel spreadsheet to .ODS formatBug
CELLSNET-56726Excel repairs workbook after copying and saving itBug
CELLSNET-56760Regression: Changing ExternalLink DataSource corrupts XLSX files in versions later than 24.2Bug
CELLSNET-56779Resaving Workbook corrupts OpenXML structureBug
CELLSNET-56782Worksheet UniqueId is unreliable for XLSB filesBug
CELLSNET-56806ArgumentException occurs when saving file to dif formatBug
CELLSNET-56850Date format lost when saving an ODS file as CSVBug
CELLSNET-56853Invalid pivot area format after converting xlsx to xlsbBug
CELLSNET-56881Protection lost on chart sheet when file saved in XLSX or XLSMBug
CELLSNET-56882CategoryAxis AxisLine.Color is not working properly.Bug
CELLSNET-56899This pivot field has more unique items than can be used in a pivot table when calling AddFieldToArea methodBug
CELLSNET-56908The function of data pivot field lost when loading ods fileBug
CELLSNET-56909Invalid location of pivot field when loading ods fileBug
CELLSNET-56910Incorrect pivot table of xls fileBug
CELLSNET-56848IndexOutOfRangeException when calling Workbook.CalculateFormula() methodException
CELLSNET-56783IndexOutOfRangeException when calculating Pivot TableException

Public API and Backwards Incompatible Changes

The following is a list of any changes made to the public API such as added, renamed, removed or deprecated members as well as any non-backward compatible change made to Aspose.Cells for C++. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.

Changes some behaviors of Cells::DeleteBlankRows()/Cells::DeleteBlankColumns().

In old versions, those two methods have different behaviors for drawing objects: when deleting rows, those objects will not be checked and may be deleted togather with blank rows. When deleting columns, those objects will be checked and columns under them will not be taken as blank. Starting from 24.10 we have unified the behavior of those two methods and by default we do not check drawing objects. If user needs to keep those objects and corresponding rows/columns, please use DeleteBlankOptions with false value for DrawingsAsBlank property. And for such kind of situation, with old versions user’s code may be simple like:

cells.DeleteBlankColumns();

with new versions please use code like:

    DeleteBlankOptions options;
    options.SetDrawingsAsBlank(false);
    cells.DeleteBlankColumns(options);

Changes some behaviors of PivotTable::RefreshData().

In the old versions, an Exception will be thrown when refreshing pivot table with external data source.We change to return refreshing state to avoid breaking programs.

Adds two methods in Cell.

Sets specified formula for one cell, with user specified options for parsing formula.

Adds six methods in DeleteBlankOptions.

Obsoletes ExternalConnection::GetConnectionId() method.

Use ExternalConnection.GetId() method instead.

Adds some methods in ExternalConnection.

Adds two methods in OdsLoadOptions.

Indicates whether loading pivot table of ods file as classic pivot table of Excel 97-2003

Adds two methods in OdsSaveOptions.

Indicates wheher saving pivot tables to ods file.

Adds PivotRefreshState class.

Rresents result state of refreshing pivot table.

Adds two methods in PivotTableCollection.

Supports adding classic and compact pivot table.

Obsoletes some methods in PivotTable.

Adds some methods in PivotTable.

Adds FileFormatType::Chm and LoadFormat::Chm enum.

Represents a CHM file.