Aspose.Cells for .NET 22.10 Release Notes

KeySummaryCategory
CELLSNET-42037PivotTable Timeline Filter disappears after loading excel document and updatingNew Feature
CELLSNET-51963Support for CRTX filesNew Feature
CELLSNET-51952MAXIFS formulas take long time to be calculatedEnhancement
CELLSNET-52064It’s not allowed to push non-empty cells off the end of the worksheet error when using Cells.InsertRows methodEnhancement
CELLSNET-52029Translate legend entries labels in accordance with locale/regional settingsEnhancement
CELLSNET-51419External Link of Pivot table got deleted when converting XLS file to XLSMBug
CELLSNET-51984XLSX file with PivotTable file is corrupted after re-saveBug
CELLSNET-51987Issue with some Smart Markers (inserted) in the PivotTable and Pivot chartBug
CELLSNET-52065Wrong external data connections when converting external connectionsBug
CELLSNET-52088Extra row is added when creating classic pivot tableBug
CELLSNET-52018GetValidationValue incorrect using NotBetween operatorBug
CELLSNET-52069Decimal values in the result of Cell.Formula may be different from what ms excel showsBug
CELLSNET-52078Style.SetPatternColor(BackgroundType,Color,Color) does not take effectBug
CELLSNET-52105LightCellsDataHandler.StartSheet(Worksheet) cannot skip the sheet when returning false for xlsb template fileBug
CELLSNET-46764Missing chart title on convert to pdfBug
CELLSNET-52049XLSX to PDF: Text not formatted properlyBug
CELLSNET-52073Issue regarding Arial Tur font in Excel to PDF renderingBug
CELLSNET-52083Some cells with the Accounting number format are rendered as #####.Bug
CELLSNET-52091When setting the worksheet contents to black and white, it is still printed in color & borders are displayed unnecessarilyBug
CELLSNET-51972Worksheet containing button objects are not recognized properly when copying the sheetBug
CELLSNET-51973Html table to Excel sheet not converted properlyBug
CELLSNET-52001Re-saving an XLSX file generated corrupt fileBug
CELLSNET-52015Unable to load power query formula from Excel fileBug
CELLSNET-52054Style corruption after saving and reopening an Aspose.Cells-generated workbookBug
CELLSNET-52056Hyperlink Duplication IssueBug
CELLSNET-52071Excel to XML conversion - Element Names are Not EscapedBug
CELLSNET-52074HTML to XLSX: Missing cell contentBug
CELLSNET-52084The position of the “Northwind Traders” text is incorrect (the left indent value is not interpreted correctly).Bug
CELLSNET-52063PivotTable.CalculateData caused NullReferenceExceptionException
CELLSNET-51986Calculating workbook twice with enabled calculation chain caused exceptionException
CELLSNET-52081Opening XLSX file whose styles have been removed throws exceptionException
CELLSNET-52044Exception raised while importing the customer’s file in GridWebException
CELLSNET-52002Exception is thrown when trying to open unprotected document with a passwordException

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 .NET. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.

Changed the limit of moving cells out of the sheet for inserting rows

In old versions, if there are cells that have formatting settings but has no value?and will be moved out of the sheet, insert operation is not allowed. From 22.10, insert operation is allowed for such kind of situation and such behavior is same with ms excel now.

Adds DataModelConnection class

Specifies a data model connection.

Adds Chart.ChangeTemplate(byte[]) methods

Change chart type with preset template file.

Adds ChartCollection.Add(byte[] data, string dataRange, bool isVertical, int topRow, int leftColumn,int rightRow, int bottomColumn) method.

Adds chart with preset template file.