Aspose.Cells for .NET 21.2 Release Notes

CELLSNET-42427Support percentage of column display format for PivotTableNew Feature
CELLSNET-44288Using LightCells API with XLSB filesNew Feature
CELLSNET-47817Update data source when changing Waterfall chart to Column chart.Enhancement
CELLSNETCORE-99Support updating display icon for embedded jpg, zip, msg object.Enhancement
CELLSNET-47827Hang on CalculateFormulaPerformance
CELLSNET-47832Cells.DeleteBlankRows never finishes (infinite loop) on a particular worksheetPerformance
CELLSNETCORE-98Loading xlsb results with OOM exceptionPerformance
CELLSNET-47805Wrong position of some polylines when saving .html files.Bug
CELLSNET-47810Arrow position is wrongBug
CELLSNET-43717Pivot Field sorting does not render to PDFBug
CELLSNET-43751Row Label Sorting is lost after refereshing PivotTableBug
CELLSNET-47777Formatting errors in converted HTMLBug
CELLSNET-47824Issue with PPMT formula that gives wrong resultBug
CELLSNET-47847Wrong formula reference after deleting rowsBug
CELLSNET-47818Shape.ToImage does not render text in docker enviromentBug
CELLSNET-47820Borders are missing in Aspose EMF/OfficeCompatibleEMF converted from XLSXBug
CELLSNET-47844Wrong conversion of double underline accounting formatted cell when saving to PDFBug
CELLSNET-47819Data Labels not displaying properly when savingBug
CELLSNET-47821Data Labels Not CorrectBug
CELLSNET-47813Strange behavior (and differences) with Treemap chart (and other advanced charts)Bug
CELLSNET-47815Threaded Comments are not transferred with the Enclosing shapeBug
CELLSNET-47816File size and MaxColumn of the workbook are increased after setting outline borderBug
CELLSNET-47828Additional Ctls stream in XLS file after upgrade to Aspose.Cells for .NET 21.1Bug
CELLSNET-47838Native chart color palette is not preservedBug
CELLSNET-47845Borders unexpectedly removed after pasting with DefaultExceptBorders paste typeBug
CELLSNET-47848Issue with AutoFilter removal of ListObject or Add Filter Button flag for itBug
CELLSNET-47840Exception raised while opening Excel file generated from an HTMLException
CELLSNET-47841StackOverflowException with xlsx fileException
CELLSNET-47854Cells.Find throws exception when the file is open via streamException
CELLSNET-47825Aspose.Cells 21.01 Exception on opening documentException
CELLSNET-47831New workbook failException

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.

Changes behavior of Cells.DeleteBlankRows()/Cells.DeleteBlankRows(DeleteOptions)

In old versions, we delete all column settings while deleting blank rows if the worksheet is empty(no cells data). This make it impossible for user to delete blank rows only and keep all column settings. From 21.2, we do not clear column settings any more. If user needs to delete column settings for empty worksheet, he should check there is no data in sheet and then clear the ColumnCollection manually. In old versions, we do not delete blank rows under shape. This make it impossible for user to delete all blank rows as they expect. From 12.2, we delete those blank rows under shape together with other common blank rows.

Obsoleted Range.CellCount property.

Please use Range.RowCount and Range.ColumnCount to get the total cell count instead.

Adds AutoFilter.ShowFilterButton property.

Indicates whether showing filter button of auto filter.

Deletes obsoleted SeriesCollection.SecondCatergoryData property.

Please use SeriesCollection.SecondCategoryData property instead.

Deletes StyleModifyFlag.Spacing enum.

It’s not used.