Browse our Products

Aspose.Cells for .NET 22.4 Release Notes

KeySummaryCategory
CELLSNET-50624Support to remove tailing blank cells for saving csvNew Feature
CELLSNET-50747Add Style.HasBorders to check whether there are borders for itEnhancement
CELLSNET-50627Get merged range with respect to worksheet cell in Aspose.Cells.GridDesktopEnhancement
CELLSNET-50675add GridLoadDataFilterOptions for GridDesktop and Worksheet.GetMergeByCell apiEnhancement
CELLSNET-50816Support High Contrast Theming in Aspose.Cells.GridDesktopEnhancement
CELLSNET-50751Support PasteType.ValuesAndFormats when copying range.Enhancement
CELLSNET-50620When converting xls to pdf, text blank line size in textbox is not rendered correctlyBug
CELLSNET-50684Issue with extracting OLE attachments from ODS fileBug
CELLSNET-50712WordArt effects and shapes are not rendered properly in Excel to PDF conversionBug
CELLSNET-50714The XLSB file is corrupt when opening and saving by Aspose.Cells APIsBug
CELLSNET-50778Vertical lines are missing for the pivot table in the output PDFBug
CELLSNET-50517Wrong reference in conditional formatting formula after inserting/deleting rowsBug
CELLSNET-50622Heading blank row/column with custom style is not exported to csvBug
CELLSNET-50645Incorrect results with Workbook.CalculateFormula methodBug
CELLSNET-50695Name.RefersTo/R1C1RefersTo changed when referencing to single cell addressBug
CELLSNET-50553Column style is not applied on complete column in GridDesktopBug
CELLSNET-50641Issue with opening a password protected file with blank password ("") into Aspose.Cells.GridDesktopBug
CELLSNET-50672add FailLoadFile eventBug
CELLSNET-50815double click edit cell value behavior is not correctBug
CELLSNET-50594Text is hidden behind input fields when converting XLSX to HTMLBug
CELLSNET-50665Pdf/A-1b validation failed after setting CreatedTime while converting to pdfBug
CELLSNET-50701The brightness and contrast of inserted image is reset in Excel to PDF conversionBug
CELLSNET-50834Issue with table’s merged cells in Excel to HTML conversionBug
CELLSNET-50595XLSX to SVG: Differences in chartBug
CELLSNET-50596Axis units are not changed in the output XLSX fileBug
CELLSNET-50740XLSX to JPG: text shifted to right side on chartsBug
CELLSNET-50309Range to PNG: output not as expectedBug
CELLSNET-50610RecalculateBeforeSave always false in newer versionBug
CELLSNET-50611Issue with Boolean value in Excel to PDF renderingBug
CELLSNET-50706File size reduced many times when save with SaveToStream() at second timeBug
CELLSNET-50749DeleteBlankColumns(options) method deleting columns which are having only commentsBug
CELLSNET-50759Formulas are not being saved correctly when a workbook has external links to a workbook that has not been savedBug
CELLSNET-50776Smart markers are not processed when using a generic list of type System.Dynamic.ExpandoObject as the datasource for a nested objectsBug
CELLSNET-50779Potential data loss regarding embedded objects while converting XLS -> XLSX -> XLSBug
CELLSNET-50821Issue with Range.AutoFill - data is not auto-filled properly if the range area is intersectedBug
CELLSNET-50777PutValue method throws System.StackOverflowException on Australian regional formatException
CELLSNET-50275“Object reference not set to an instance of an object” exception when rendering ODS to HTMLException
CELLSNET-50713System.NullReferenceException when loading an XLSB fileException

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 DefaultStyleSettings class.

Group of default values for style-related properties.

Adds LoadOptions.DefaultStyleSettings property.

Support to set default values of style-related properties for initializing a Workbook.

Adds TxtSaveOptions.TrimTailingBlankCells property.

Support to remove all blank cells(repeated characters of separator such as “~,~,~,~,”) at the end of row record when exporting csv/tsv.

Adds Style.HasBorders property.

Support to check whether there are borders have been set for the style.

Obsoletes LoadOptions.StandardFont/StandardFontSize properties.

Please use LoadOptions.DefaultStyleSettings.FontName/FontSize instead.

Removes obsolete enum StyleModifyFlag.FontSubscript and FontSuperscript.

Please use StyleModifyFlag.FontScript instead.

Obsoletes Shape.ConnectionPoints properties.

Use GetConnectionPoints() method instead.

Adds Shape.GetConnectionPoints() method.

Get the connection points.

Adds Row.IsCollapsed and Column.IsCollapsed properties.

Indicates whether the row and column is collapsed.

Adds PasteType.ValuesAndFormats enum.

Indicates only copying values and formats.

Adds Shape.IsInGroup property.

Indicates whether the shape is grouped.

Adds AutoFilter.GetCellArea() method.

Gets the area where the specified AutoFilter applies to.

Adds Cells.GetRowOriginalHeightPoint() method.

Gets the original row height, in unit of points.

Adds TimelineCollection.Add(PivotTable pivot, string destCellName, PivotField baseField) method.

Add a new Timeline using PivotTable as data source.

Adds TimelineCollection.Add(PivotTable pivot, int row, int column, PivotField baseField) method.

Add a new Timeline using PivotTable as data source.

Adds TimelineCollection.Add(PivotTable pivot, string destCellName, int baseFieldIndex) method.

Add a new Timeline using PivotTable as data source.

Adds TimelineCollection.Add(PivotTable pivot, int row, int column, int baseFieldIndex) method.

Add a new Timeline using PivotTable as data source.

Adds TimelineCollection.Add(PivotTable pivot, string destCellName, string baseFieldName) method.

Add a new Timeline using PivotTable as data source.

Adds DataLabelShapeType.Line enum.

Represents the Line Shape. This type is not available in Excel, it is only used for some special files.

 
 English