Aspose.Cells for .NET 20.10 Release Notes

CELLSNET-47625Verifies password for encrypted filesNew Feature
CELLSNET-47601Render extra row and column in HTML without disturbing formulas/references to resemble the output with MS ExcelNew Feature
CELLSNET-47619Aspose Chart SetChartDataRange ProblemEnhancement
CELLSNET-47632Structure and order difference in OLE of the input and output after saving the fileEnhancement
CELLSNET-47644Different external connections fetched as compared to MS ExcelEnhancement
CELLSNET-47652Font spacing issues when set characters formatEnhancement
CELLSNET-47623Slow save operation with lots of formulas in filePerformance
CELLSNET-47606Application hangs while converting Excel to PDFPerformance
CELLSNET-47611IRR formula calculation issueBug
CELLSNET-47616Delete Range behaving differently between v20.8 and v20.9Bug
CELLSNETCORE-83Excel file was not displayed properly in GridWebBug
CELLSNETCORE-86Shape display problem in GridWebBug
CELLSNET-47597The fill areas are very different comparing to the source fileBug
CELLSNET-47614Some symbols are missing in the output PDF in Excel to PDF renderingBug
CELLSNET-47636Excel to PDF conversion - The result goes over the page in landscape orientationBug
CELLSNET-47637Converting Excel to PDF issue with Calibri LightBug
CELLSNET-42982Chart size & Layout were changed after Workbook.CombineBug
CELLSNET-47594Option to get PlotBy and OnAction information similar to MS ExcelBug
CELLSNET-47595Chart was not retained properly in Excel file while loading and saving it backBug
CELLSNET-47599AddControlRefrernce does not add a reference to MS Forms 2.0Bug
CELLSNET-47600Form control names and few other properties are different as compared to MS ExcelBug
CELLSNET-47613LTR and RTL are not preserved after load and save with XLSB fileBug
CELLSNET-47615Power point file embedded in Excel file cannot be opened after saveBug
CELLSNET-47645Repair message raised by MS Excel after loading and saving Excel files with Aspose.CellsBug
CELLSNET-47647Repair message raised by Excel while converting XLSB->XLSX->XLSBBug
CELLSNET-47648XLSB file is corrupted after conversion (XLSB->XLSX-XLSB)Bug
CELLSNET-47658Font size is rounded when we have specified Decimal Symbol with Region settingBug
CELLSNETCORE-81“Wrap text” option is not preserved in XLSB file after Load and SaveBug
CELLSNETCORE-82Specific sheet inside XLSB file breaks after load and saveBug
CELLSNETCORE-84Styling information returned along with the header textBug
CELLSNETCORE-85Cells.InsertCutCells corrupts notesBug
CELLSNET-47544Images are missing and text’s position was wrong when rendering Excel in LinuxBug
CELLSNET-47571HTML conversion from XLS goes into a continuous conversion loopBug
CELLSNET-47583PivotTable.TableRange2 gives wrong value for the pivot tableBug
CELLSNET-47584Aspose.Cells HTML to Excel conversion did not show imagesBug
CELLSNET-47609Diagram is not shown in html when sheet has no other contentBug
CELLSNET-47633Pivot table with dates does not update correctlyBug
CELLSNET-47635Slicer on different table generates corrupted fileBug
CELLSNET-47620Shape to image Error while saving to PDFException
CELLSNET-47608NullReferenceException on loading XLSXException
CELLSNET-47624System.ArgumentException when loading encrypted file to XLAMException
CELLSNET-47630Specified argument was out of the range of valid values exception when deleting columnException
CELLSNET-47649Exception is raised while reading DBConnection.PowerQueryFormula from XLSX fileException
CELLSNET-47655CellsException during Excel to PDF conversionException
CELLSNETCORE-80Unable to cast object exception while converting XLSB to XLSMException
CELLSNET-47593Exception when trying to open particular HTMException
CELLSNET-47656Shape to image Error when converting XLSB to PDFException

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.

Adds ExceptionType.Permission enum

Represents ExceptionType.Permission.

Adds ExternalConnection.PowerQueryFormula property.

Gets the definition of power query formula.

Adds FileFormatUtil.VerifyPassword method.

Verifies whether the password is valid for the file.

Adds VbaProject.Copy() method.

Copies VBA project.

Adds XlsSaveOptions.MatchColor property.

Indicates whether matching color if the color is not in the palette when saving .xls file.

Deletes obsoleted Series.Line property.

Use Series.Border property instead.