Aspose.Cells for .NET 22.7 Release Notes

CELLSNET-51296Gridweb keeps jumping back to top when trying to copy and pasteEnhancement
CELLSNET-51355And Range.Top, Left, Width ,Height in unit of pointsEnhancement
CELLSNET-51367Convert all sheets to one page when saving as html.Enhancement
CELLSNET-51486The text rendered as small squaresBug
CELLSNET-51492Default font is not applied when converting XLSX to HTMLBug
CELLSNET-51306Pivot table styles not copied properly using the latest version of Aspose.Cells for .NETBug
CELLSNET-51268Problem with COUNTIFS formula treating 0 incorrectlyBug
CELLSNET-51297Cell.GetPrecedents() does not provide all precedents when the formula references to defined nameBug
CELLSNET-51399Print_Titles named range and MATCH function returns #NAME errorBug
CELLSNET-51456cells jump when do ctrl+c ctrl+v when GridWeb height is set to 100%Bug
CELLSNET-51457context menu does not show when height is set to 100% after some rowsBug
CELLSNET-51471validation list does not show in empty cellBug
CELLSNET-51469Text in image is missing after converting to pdfBug
CELLSNET-51476Arrow element becomes distorted in imageBug
CELLSNET-51001Shape object on the chart is not positioned wellBug
CELLSNET-51156Chart to image conversion - Different display of chart in the output imageBug
CELLSNET-512133-D Pie chart not properly rendered - Chart to image conversionBug
CELLSNET-51472Chart labels are missing from SVG when set to outside endBug
CELLSNET-51491Wrong values used in chart series when rendering to image or HTMLBug
CELLSNET-51525Waterfall chart is different when exported to HTML/PNG or PDFBug
CELLSNET-51353Converting an XLSB file with DDE link to XLSM file is changing the DDE application position in linkBug
CELLSNET-51376Page size is automatically changed from A4 ? Letter for a sheetBug
CELLSNET-51379External Link of type OLE in XLS file is being read as of type DDEBug
CELLSNET-51402The content is shifted content out of cell when saving html fileBug
CELLSNET-51417Links from shape to sheet in file are removed after upgrade from 22.5 to 22.6.1Bug
CELLSNET-51418An external link of type xlPathMissing is changed to normal externalLinkPath type in XLSB to XLSM conversionBug
CELLSNET-51420Differences in the document properties in app.xml fileBug
CELLSNET-51427External link containing special character “#” which is not escaped by Aspose.CellsBug
CELLSNET-51482Combining sheets from different workbooks results in corrupt file that can crash MS ExcelBug
CELLSNET-51507Number values from XLSX file read as 0Bug
CELLSNET-51280Exception while saving ODS file (RB-60121)Exception
CELLSNET-51483File Loading is failing with exception “Source array was not long enough…”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.

Adds Cells.GetDependentsInCalculation(int,int,bool) method

Gets all cells whose calculated result depends on the cell specified by row and column according to current calculation chain. For the cell which is empty and has not been instantiated in current cells model, user may use this method instead of Cell.GetDependentsInCalculation(bool) because the later one needs to instantiate the cell object into current cells model at first.

Changes cell’s Left/Right border for Cell.GetStyle() when the adjacent column is hidden

In old versions, if the adjacent column is hidden for one cell, then this cell’s Left/Right border will not be checked with the adjacent cell, so the returned border may be different from what shown in ms excel’s dialog when setting this cell’s border. From 22.7, we make the returned border always be the actual value(which should be consistent with the border of its adjacent cell) of the cell for Cell.GetStyle(). If user needs what shown for the cell in ms excel(when the adjacent column is hidden, the shown border may be the one of next visible column), user may try Cell.GetDisplayStyle().

Add Range.Top, Range.Left, Range.Height and Range.Width properties.

Gets the position and size of the range in unit of points.

Delete class PowerQueryFormulaCollction and add class PowerQueryFormulaCollection class.

There is a typo in the old class.

Add HtmlSaveOptions.ExportPageFooters and HtmlSaveOptions.ExportPageHeaders properties.

Indicates whether exporting headers and footers when saving as a single html file.

Adds HtmlSaveOptions.ShowAllSheets property.

Indicates whether showing all sheets when saving as a single html file.

Obsoletes HtmlSaveOptions.ExportHeadings property and add HtmlSaveOptions.ExportRowColumnHeadings property.

Please use HtmlSaveOptions.ExportRowColumnHeadings instead.

Obsoletes Chart.ToImage(string, ImageFormat) and add Chart.ToImage(string, ImageType)

Please use Chart.ToImage(string, ImageType) instead.

Obsoletes Chart.ToImage(Stream, ImageFormat) and add Chart.ToImage(Stream, ImageType)

Please use Chart.ToImage(Stream, ImageType) instead.

Obsoletes Shape.ToImage(Stream, ImageFormat) and add Shape.ToImage(Stream, ImageType)

Please use Shape.ToImage(Stream, ImageType) instead.