Browse our Products

Aspose.Cells for .NET 24.5 Release Notes

KeySummaryCategory
CELLSNET-52256Support XMATCH functionNew Feature
CELLSNET-55475Support XOR functionNew Feature
CELLSNET-55521Transpose data of the rangeNew Feature
CELLSNET-55531Support obtaining properties of advanced filtering settingsNew Feature
CELLSGRIDJS-997Add the ability to copy styles to autofillNew Feature
CELLSGRIDJS-969Support chart color settingNew Feature
CELLSNET-55494Support determining whether the ReferredArea is a entire row or a entire columnEnhancement
CELLSNET-55640Floor function returns #NUM! for negative numberEnhancement
CELLSNET-55252Export metadata of cell into pdf , image and htmlEnhancement
CELLSNET-55497Process font RGBA color with style background colorEnhancement
CELLSNET-55498Remove picture in cell when set value to the cellEnhancement
CELLSNET-55574Some formats are not yet supported when converting LoadFormat to extensionEnhancement
CELLSNET-55454Missing or incorrect SmartArt inner shape propertiesBug
CELLSNET-55511Asian line break issue for shapes when rendering Excel file to PDFBug
CELLSNET-55518Fix the issue where the text box height was incorrect when the text was in Japanese.Bug
CELLSNET-55523Read SVG throws exception when converting html to xlsxBug
CELLSNET-55375Chart not rendered as expected when converting XLSX to PDFBug
CELLSNET-55493INDEX(FILTER(?);1) working incorrectly inside LAMBDABug
CELLSNET-55529Currency format for negative value was formatted with brackets instead of ‘-’ for CannadaBug
CELLSNET-55536ISNA(INDIRECT()) was calculated as #REF! but it is true in ms excelBug
CELLSNET-55600Formula evaluation shows incorrect valueBug
CELLSNET-55648Wrong records are hiding due to Workbook.RefreshDynamicArrayFormulas()Bug
CELLSNET-55651The value in a cell is truncated to 255 characters in light weight mode when opening the XLS workbook in MS ExcelBug
CELLSNET-55669Typo error in API for range mergingBug
CELLSNET-55343Chart display error when calling SheetRender.ToImageBug
CELLSNET-55408Text with the same font displays differently when converting chart to imageBug
CELLSNET-55442Excel Combo chart control rendering to an Image reduces width to 50% of the original Excel rangeBug
CELLSNET-55559The chart title is not rendered correct when set FarEastName and LatinName at the same timeBug
CELLSNET-55613Can not display conditonal formatting colour scales in GridWebBug
CELLSGRIDJS-1076Fail to display two gradient color for some cellsBug
CELLSGRIDJS-1082Image load status is not correct in the demo project for highlightBug
CELLSNET-55473Image in header is lost when saving Excel file as PDFBug
CELLSNET-55510Excel page splitted to two PDF pagesBug
CELLSNET-55512Excel to PDF does not maintain last row on print-preview pageBug
CELLSNET-55287Skewed cells rendering error when converting file to HTMLBug
CELLSNET-55387When load a html file, table element can not be turned into list object.Bug
CELLSNET-55501Some text colors are white when importing html fileBug
CELLSNET-55500Wrong Horizontal Alignment if zero indent level is setBug
CELLSNET-55524Pivot table and pivot chart are not calculated/rendered correctly in the output imageBug
CELLSNET-55526Extra rows are inserted while adding a list object without header rowsBug
CELLSNET-55530Unable to copy data to the specified area after calling Worksheet.AdvancedFilterBug
CELLSNET-55543Chart formatting is changed on worksheet copyBug
CELLSGRIDJS-1087After edit cell value to empty string ,the server side cell in workbook still have valueBug
CELLSGRIDJS-1086The autofill data in UI does not keep same with server side workbookBug
CELLSGRIDJS-1092Raise exception when do autofill actionBug
CELLSNET-55560NullReferenceException occurs when calling CalculateFormula methodException
CELLSNET-55573Exception occurred while deleting cache folderException
CELLSNET-55652Formula “TEXTAFTER” throws NullReferenceExceptionException
CELLSNET-55686Throwing ArgumentOutOfRangeException when loading XLS files via streamException

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 the returned value of FileFormatUtil.LoadFormatToExtension(LoadFormat.TabDelimited).

In old versions, we returned “txt” for tab delimited text file. From 24.5, we return the most specific extension of “tsv” for it.

Adds properties ReferredArea.IsEntireRow/IsEntireColumn.

Indicates whether the area reference is entire row or column.

Adds properties DefaultStyleSettings.BuiltInPreference and WorkbookSettings.DefaultStyleSettings.

Indicates which property should be used to format values when the used style defines both built-in number and custom pattern.

Adds HtmlSaveOptions.AddGenericFont property.

Indicates whether to add a generic font to CSS font-family when saving file to html.

Adds HtmlSaveOptions.IsBorderCollapsed property.

Indicates whether the table borders are collapsed when saving file to html.

Adds Range.UnionRanges() method and obsoletes Range.UnionRang() method.

Uses Range.UnionRanges() method instead.

Adds Range.Transpose() method.

Transposes the row to column of the range.

Adds AdvancedFilter class.

Represents the settings of advanced filter.

Adds Worksheet.GetAdvancedFilter(Int32,Boolean,CellsUnitType) method.

Gets the settings of advanced filter.

Add CellsUnitType enum.

Represents the unit type.

Adds Cells.GetRowHeight(Int32,Boolean,CellsUnitType) method and obsoletes Cells.GetRowOriginalHeightPoint() method.

Gets the height of the row in unit of type.

Adds GetColumnWidth(Int32,Boolean,CellsUnitType) method.

Gets the width of the column in unit of type.

Obsolets Cells.GetColumnOriginalWidthPoint(Int32), GetColumnWidthPixel(Int32,Boolean) and GetColumnWidthInch(Int32) methods.

Uses Cells.GetColumnWidth(Int32,Boolean,CellsUnitType) method instead.