Aspose.Cells for .NET 21.2 Release Notes

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

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.