Aspose.Cells for .NET 9.0.0 Release Notes

1) Aspose.Cells

CELLSNET-40617Read/write values from/to ActiveX ComboBox controlNew Feature 
CELLSNET-41264Using Aspose.Cells.GridDesktop in WPF application New Feature 
CELLSNET-44681Import of HTML fails when script tag uses CDATAEnhancement 
CELLSNET-44693Contents are missing while converting HTML to XLSXBug 
CELLSNET-44650Unable to convert background or foreground colors from HTML Bug 
CELLSNET-44645Error message is shown when double-clicking on any value of the PivotTable in the output fileBug 
CELLSNET-44644The resultant file becomes corrupted when open and save the XLS fileBug 
CELLSNET-44622Final XLSX file has a lack of the caption styles while these are present in the input XLSX and intermediate HTMLBug 
CELLSNET-44581Issue with Spreadsheet to HTML conversion: STYLE tag between BODY and HTML tagsBug 
CELLSNET-44718ICustomFunction doesn’t work with [@columnName]Bug 
CELLSNET-44705Wrong SUM displayed when calculating formulasBug 
CELLSNET-44692API incorrectly calculates the formula value as compared to MS ExcelBug 
CELLSNET-44688Wrong calculation of the cell valueBug 
CELLSNET-44684Wrong value from cell when calculating formulasBug 
CELLSNET-44716PDF result does not match with Excel for printing title rowsBug 
CELLSNET-44713The data is hidden in the conversion result of PDFBug
CELLSNET-44675Rendering to image file fails for a worksheetBug 
CELLSNET-44717Spreadsheet to XPS: Process never completes and takes too much memoryBug 
CELLSNET-44678Sparklines are not rendered right while rendering spreadsheet to PDF/imageBug 
CELLSNET-44654Chart.Calculate() method spoils the chart imageBug 
CELLSNET-44714Saving to memorystream (SpreadsheetML), the process is hanged and takes lots of timeBug 
CELLSNET-44711Unhiding the row hidden by Aspose.Cells does not work properly in Microsoft ExcelBug 
CELLSNET-44709Picture formula is gone after removing and reinserting the pictureBug 
CELLSNET-44708Re-embedding the presentation slide in XLS results in presentation view upon double clickingBug 
CELLSNET-44696Line with arrow head isn’t rendered completely in XLSX & PDF formatsBug 
CELLSNET-44689Printer settings are changed on opening and re-saving the source XLS fileBug 
CELLSNET-44683“pane” xml within “customSheetView” xml not being replicated from designer spreadsheetBug 
CELLSNET-44660The Y and X Axis of the graph become bold after loading and saving an XLS fileBug 
CELLSNET-44658The text-size of chart’s vertical axis labels is changed after loading and saving XLS fileBug 
CELLSNET-44691NullReferenceException at Workbook ctor due to display:none in source HTMLException 
CELLSNET-44685Workbook.CalculateFormula() method throws exception on the source Excel fileException 
CELLSNET-44712Exception: “Invalid text of the defined name.” while opening an Excel fileException 

2) Aspose.Cells Grid Suite

CELLSNET-44667Cell shading due to conditional formatting does not display on GridWeb interfaceBug 

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 Shape.TextOptions property

Represents the text options of the shape.

Obsoletes Worksheet.SetBackground method

Please use Worksheet.BackgroundImage property instead.

Obsoletes LineShape.BeginArrowheadStyle and ArcShape.BeginArrowheadStyle

Please use Shape.Line.BeginArrowheadStyle property instead.

Obsoletes LineShape.BeginArrowheadWidth and ArcShape.BeginArrowheadWidth

Please use Shape.Line.BeginArrowheadWidth property instead.

Obsoletes LineShape.BeginArrowheadLength and ArcShape.BeginArrowheadLength

Please use Shape.Line.BeginArrowheadLength property instead.

Obsoletes LineShape.EndArrowheadStyle and ArcShape.EndArrowheadStyle

Please use Shape.Line.EndArrowheadStyle property instead.

Obsoletes LineShape.EndArrowheadWidth and ArcShape.EndArrowheadWidth

Please use Shape.Line.EndArrowheadWidth property instead.

Obsoletes LineShape.EndArrowheadLength and ArcShape.EndArrowheadLength

Please use Shape.Line.EndArrowheadLength property instead.

Deletes obsoleted Worksheet.CopyConditionalFormatting() method

Deletes obsoleted Workbook.CheckWriteProtectedPassword() method

Please use WorkbookSettings.WriteProtection.ValidatePassword method instead.

Renames Workbook.RemoveDigitallySign as Workbook.RemoveDigitalSignature method

The Workbook.RemoveDigitallySign method has been renamed to Workbook.RemoveDigitalSignature.

Adds ChartSplitType.Auto property

Represents the data points shall be split using the default mechanism for this chart type.

Adds ChartPoint.IsInSecondaryPlot property

Gets or sets a value indicates whether this data points is in the second pie or bar on a pie of pie or bar of pie chart.

Adds OleObject.ClassIdentifier property

Gets or sets the class identifier of the embedded object.

Adds LoadOptions.CultureInfo property

Gets or sets the system culture info at the time the file was loaded.