Aspose.Cells for .NET 21.10 Release Notes

CELLSNET-49192Issue with retrieving Ranges (RefersTo) with an offset functionNew Feature
CELLSNET-49132Open files with HTML table inside as XLS filesNew Feature
CELLSNET-49173Support Range.CurrentRegion PropertyNew Feature
CELLSNET-49015Update hyperlink(Sheet1!A1) when changing the name of the worksheet.Enhancement
CELLSNET-49021Conditional formatting of ods is lost in MS Excel if type is “Contains Text”Enhancement
CELLSNET-49280Support autofill range with fill typeEnhancement
CELLSNET-49413Remove invisible shapes when?rendering HTMLEnhancement
CELLSNETCORE-135Application halts while calculating large files and UDFsPerformance
CELLSNET-49124Blurry radio-buttons when converting XLSM to HTMLBug
CELLSNET-49115Incorrect calculation of operators in formula when operands are rangesBug
CELLSNETCORE-132Distorted chart created in converted HtmlBug
CELLSNETCORE-141Missing text, wrong text alignment and missing percentages in chartBug
CELLSNET-49067Issue with get and set Tab color in GridDesktopBug
CELLSNET-49069Aspose.Cells.GridWeb SessionMode does not workBug
CELLSNET-49118Issue with Xml importBug
CELLSNET-49195XLSX to HTML conversion does not retain sequence of invisible charactersBug
CELLSNET-49245Image shifts in specific XLS files when rendered to HTMLBug
CELLSNET-49246Image is not visible when converting specific XLSX file to HTMLBug
CELLSNET-49334Issue with font text in footer field for Excel renderingBug
CELLSNET-49393Unable to successfully import the XML file into the template fileBug
CELLSNETCORE-226Unnecessary whitespace rendered during Excel to EMF conversionBug
CELLSNET-49091The “strCache” node missing in a XMLBug
CELLSNET-49161No longer able to copy correct Value axis tick label’s font namesBug
CELLSNET-49191Cannot show percentage values in datalabelBug
CELLSNET-49305Some Data Labels in the chart are missingBug
CELLSNET-49374Chart line is different with Chart.ToImage function than in ExcelBug
CELLSNET-48613A resource that is out of the selected range should not be exported to HTMLBug
CELLSNET-49027Distortion of document page color and layoutBug
CELLSNET-49145DataMashup information not retrieved from Excel fileBug
CELLSNET-49146Watermark in Excel file cannot be correctly generated and displayedBug
CELLSNET-49239Shadow effect is applied to image(s) when converting from XLSM to XLSBug
CELLSNET-49244Icon conditional formatting is lost when saving as htmlBug
CELLSNET-49328Error when copying worksheetsBug
CELLSNET-49365Text is clipped in printer output after call to AutoFitRowsBug
CELLSNET-49366Issue with Cell data validation input fields in XLSB formatBug
CELLSNETCORE-269Wrong row with large height is added into HTML tableBug
CELLSNETCORE-270Problems with HtmlString Font when Excel saved as HTML onceBug
CELLSNET-49375Issue while refreshing Pivot table after adding dataBug
CELLSNET-49194Exception when loading the excel fileException
CELLSNET-49363CalculateData method on pivot table throws exceptionException
CELLSNET-49373“Input string was not in a correct format.” exception when open XLSX fileException
CELLSNET-49394Null exception when open NUMBERS 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 overloaded method Name.GetRefersTo().

Gets the formula expression based on the specified cell.

Adds overloaded method Range.AutoFill().

Automatically fill the target range with filling type.

Adds Comment.IsThreadedComment property.

Indicates whether this comment is threaded comment.

Adds HtmlSaveOptions.IgnoreInvisibleShapes property.

Indicates whether ingoring invisible shapes when saving html.

Adds Range.CurrentRegion property.

Returns a range bounded by any combination of blank rows and blank columns.

Adds AxisBins class.

Represents axis bins for Histogram Charts.

Obsoletes method SheetRender.GetPageSize(int pageIndex)

Use SheetRender.GetPageSizeInch(int pageIndex) instead.

Adds method SheetRender.GetPageSizeInch(int pageIndex)

Get page size of output image?in unit of inch.

Obsoletes method WorkbookRender.GetPageSize(int pageIndex)

Use WorkbookRender.GetPageSizeInch(int pageIndex) instead.

Adds method WorkbookRender.GetPageSizeInch(int pageIndex)

Get page size output image?in unit of inch.