Aspose.Cells for .NET 21.1 Release Notes

CELLSNET-47376Release Aspose.Cells for .NET 5.0New Feature
CELLSNET-40624How to switch row/column data series using asposeNew Feature
CELLSNET-42195Convert control from xlsm to xlsNew Feature
CELLSNET-47806Gets the data source range of the chart.New Feature
CELLSNET-47756SmartArt shapes are not rendered fine in Excel to PDF conversionBug
CELLSNET-47391Shapes are not positioned correctly in excel to pdf conversionsBug
CELLSNET-47766Arrow graph is incompleteBug
CELLSNET-47653Diagram blocks are shifted when converting to HTMLBug
CELLSNET-47720Invalid CSS and HTML markup when converting XLSX to HTMLBug
CELLSNET-47746Unencoded quotes in values of HTML attributesBug
CELLSNET-47792Images are over lapping the text when importing html to excelBug
CELLSNET-47797Bad link when XLSM file is rendered in HTMLBug
CELLSNET-47807Invalid HTML markup with nested A elementsBug
CELLSNET-47778IRR Calculation evaluates to #NUMBug
CELLSNET-47814GridDesktop scrollbars are not hiddenBug
CELLSNET-47744Radial plots are squished when exported to pdfBug
CELLSNET-47786XErrorBar not displaying in the chartBug
CELLSNET-47787XErrorBars disappears when copying chart from one workbook to anotherBug
CELLSNET-43907WordArt is not rendered while converting XLS to PDFBug
CELLSNET-47780Problem setting two ranges as data source of chartBug
CELLSNET-47781Wrap Text not working for ODS filesBug
CELLSNETCORE-94Pivot Table Group By day is increasing when refreshedBug
CELLSNETCORE-77Error while converting XLSX to PDF on AzureBug
CELLSNETCORE-90Issues while inserting attachments in excel worksheetBug
CELLSNETCORE-93H1 tag not rendered without additional tags like underline, italic or boldBug
CELLSNETCORE-97Calling RemoveExternalLinks() raises exceptionBug
CELLSNET-47719Failed to save xlsb to xlsxException
CELLSNET-47784Exception while importing HTML document with IStreamProviderException
CELLSNET-47801CalculateData on pivot table throws exceptionException
CELLSNET-47809Cell.ContainsExternalLink throws ‘Unable to castException
CELLSNET-47791Chart causing Workbook.Save to failException
CELLSNET-47808Exception raised while calculating an empty chartException

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.

Deletes obsoleted ReplaceOptions.IsCaseSensitive property(.NET ONLY).

Use ReplaceOptions.CaseSensitive instead.

Obsoleted PdfSaveOptions(SaveFormat) constructor.

Use PdfSaveOptions() constructor instead.

Obsoleted XlsbSaveOptions(SaveFormat) constructor.

Use XlsbSaveOptions() constructor instead.

Obsoleted XlsSaveOptions(SaveFormat) constructor.

Use XlsSaveOptions() constructor instead.

Obsoleted SpreadsheetML2003SaveOptions(SaveFormat) constructor.

Use SpreadsheetML2003SaveOptions() constructor instead.

Adds Chart.GetChartDataRange() method.

Gets the data range source of the chart.

Adds Chart.SwitchRowColumn() method.

Switches row/column of the chart’s data range source.

Adds OleObject.SetEmbeddedObject() method.

Sets embedded object .

Adds VbaProject.ValidatePassword() method.

Validates the password of VBA project.

Deletes obsoleted ChartPoint.MarkerBackgroundColor and Series.MarkerBackgroundColor properties , adds Marker.BackgroundColor property.

Uses Marker.BackgroundColor instead.

Deletes obsoleted ChartPoint.MarkerForegroundColor and Series.MarkerForegroundColor properties , adds Marker.ForegroundColor property.

Uses Marker.ForegroundColor instead.

Deletes obsoleted ChartPoint.MarkerBackgroundColorSetType and Series.MarkerBackgroundColorSetType properties , adds Marker.BackgroundColorSetType property.

Uses Marker.BackgroundColorSetType instead.

Deletes obsoleted ChartPoint.MarkerForegroundColorSetType and Series.MarkerForegroundColorSetType properties , adds Marker.ForegroundColorSetType property.

Uses Marker.ForegroundColorSetType instead.

Deletes obsoleted ChartPoint.MarkerSize and Series.MarkerSize properties.

Uses Marker.MarkerSize instead.

Deletes obsoleted ChartPoint.MarkerStyle and Series.MarkerStyle properties.

Uses Marker.MarkerStyle instead.