Aspose.Cells for .NET 21.9 Release Notes

CELLSNET-48134Support rendering Box & Whisker Excel 2016 Chart to imageNew Feature
CELLSNET-48683Delete pivot table while perserving dataEnhancement
CELLSNET-48624Support named range of whole row/column for .ods filesEnhancement
CELLSNET-49052Support setting Transparency of picture for xlsx files.Enhancement
CELLSNETCORE-233Enhancement for changing threaded comment’s authorEnhancement
CELLSNET-49011Speed up cells iterator access for render for GridDesktopPerformance
CELLSNET-48915Out Of Memory Exception when rendering worksheet to imagePerformance
CELLSNET-47663Excel document is not converted to htmlPerformance
CELLSNET-48506Improve performance for writing .ods file.Performance
CELLSNET-48645Text inside an arrow shape got the wrong positionBug
CELLSNET-48475Pivot table refresh does not work properlyBug
CELLSNET-48711Export the zoomed xlsx to html.Bug
CELLSNET-48998Modifications to properties get lost or cause it disappear for Slicer objectBug
CELLSNET-48614Excel filter function does not seem to work properlyBug
CELLSNETCORE-136Arrowhead does not appear in Linux environmentBug
CELLSNETCORE-137Arrowhead missing while converting Excel to SVGBug
CELLSNET-49045Incorrect cells height observed in GridWeb while loading the attached fileBug
CELLSNET-49069Aspose.Cells.GridWeb SessionMode not workingBug
CELLSNET-40974Excel to Xps conversion: link is not clickable after conversion done .NETBug
CELLSNET-48540Lines became dotted on data bars in Emf/OfficeCompatibleEmfBug
CELLSNET-48609Fonts difference issue while comparing it with the ExcelInterop imageBug
CELLSNET-48983Sheet to Emf leaves the border edges drawn improperlyBug
CELLSNET-49049Font is distorted while converting sheet to Emf image with EmfOnly optionBug
CELLSNET-48049Different axis spacing when converting from xlsx workbook to emfBug
CELLSNET-48509Chart sometimes does not appear based on legend positionBug
CELLSNET-48580Miss Legend entry in the output SVG of Excel chartBug
CELLSNET-48696Error in modifying data label colorBug
CELLSNET-48698Chart color issue when export in PDFBug
CELLSNET-48797Mean marker value is error when reading from xlsxBug
CELLSNET-48455Autofit row height issueBug
CELLSNET-48473AutoFit Column does not working properlyBug
CELLSNET-48605Add VBA code to workbook produced corrupted resultsBug
CELLSNET-48644Miss rows and watermark when converting XLSX to HTML by page breaksBug
CELLSNET-48669Named range of .ods file is read as Table .Bug
CELLSNET-48718Get wrong embedded object nameBug
CELLSNET-48966After copying range of cells formulas are lostBug
CELLSNET-49055AutoFit columns for Merged cell not workingBug
CELLSNET-49100Some cells are missing grid lines when exporting to HTMLBug
CELLSNETCORE-149Copying styles after copying values erases cell values in Excel 97 formatBug
CELLSNETCORE-152EMF image data cannot be read from XLS fileBug
CELLSNET-48444Invalid parameter error when converting xlsb to xls fileException
CELLSNET-48607Shape to image ErrorException
CELLSNET-48866Unable to open specific XLSX Excel file into GridDesktop controlException
CELLSNET-48956Exception after setting cells style using Cell.SetStyleException
CELLSNET-48712Array out of bound when rendering Box&Whisker chartException
CELLSNET-48910Exception thrown when rendering box&Whisker Chart to imageException
CELLSNET-48648Invalid column index when copying a rangeException

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 AutoFitterOptions.FormatStrategy property.

Gets and sets the formatted strategy for auto fitting.

Adds MsoFormatPicture.Transparency property.

Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear).

Adds overloaded PivotTableCollection.Remove() methods.

Deletes the specified PivotTable and checks whether keeping cells’ data .

Adds ImageOrPrintOptions.IsOptimized property.

Indicates whether optimize the output elements. Default value is false. Currently only the border lines are?optimized when this property is set to true.