Aspose.Cells for .NET 8.9.0 Release Notes

1) Aspose.Cells

CELLSNET-44574Support expanding text from right to left when exporting file to HTML New Feature 
CELLSNET-44561Ability to set Default Font while rendering spreadsheet to HTMLNew Feature 
CELLSNET-44562Ability to set Default Font while rendering spreadsheet to imagesNew Feature 
CELLSNET-44552Refreshing Pivot Table throws exceptionBug 
CELLSNET-44542Excel file is not properly rendering into HTML file formatBug 
CELLSNET-44541Contents overlap while converting spreadsheet to HTMLBug 
CELLSNET-44520Pivot Field’s dropdown is missing after re-saving XLSX as XLSBBug 
CELLSNET-44518Spreadsheet becomes corrupted after re-saving XLSX as XLSBBug 
CELLSNET-44501Refreshing and Calculating Data on existing Pivot Table generates corrupt Excel fileBug 
CELLSNET-44447Chart.ToImage is generating incorrect imageBug 
CELLSNET-43656Some text items are slightly truncated in the output HTMLBug 
CELLSNET-44590Problem exporting Excel to PDF with special characters in the header and footerBug 
CELLSNET-44517Vertical alignment wrong when generating range to image using SheetRender.ToImageBug 
CELLSNET-44589Aspose.Cells generated EMF shows incorrect axis labels when inserted into Word document and converted to PDFBug 
CELLSNET-44586Less than single spacing doesn’t export to PDF properlyBug 
CELLSNET-44564Chart’s EMF generated under Session 0 does not display all the contentsBug 
CELLSNET-44559Chart.HasAxis is showing wrong valueBug 
CELLSNET-44538Empty PNG 0KB file generated while converting XLSX to HTMLBug 
CELLSNET-44591Cells.ClearContents removes the formula for the cells below the specified rangeBug 
CELLSNET-44577Issue with Worksheet.Copy() - All comments after IV column are missing in the copied sheetBug 
CELLSNET-44573Pictures in worksheets copied from an external XLSX are not sized the same as originalsBug 
CELLSNET-44571Copying workbook into new workbook produced unreadable content errorBug 
CELLSNET-44568TextBox in the chart is lost while copying WorkbooksBug 
CELLSNET-44567Chart colors are lost while copying workbookBug 
CELLSNET-44545Formula results in “#NAME” error after copying the rows and calculating formulasBug 
CELLSNET-44544Formula is replaced by 0 after copying the rows and calculating formulasBug 
CELLSNET-44543The fill format of shape is lost when converting the file to HTML Bug 
CELLSNET-41153Printing zone is moved a bit using latest versions of the productBug 
CELLSNET-44599Showing total for list object with only 1 record corrupts the workbookBug 
CELLSNET-44598Incorrect ListObject size after ShowTotals set to falseBug 
CELLSNET-44563Exception: “Input string was not in a correct format.” when loading an HTML file formatException 
CELLSNET-44560Problem with saving a workbookException 
CELLSNET-44558ArgumentNullException at WorksheetCollection.GetNamedRanges methodException 
CELLSNET-44588ArgumentOutOfRangeException while calling AutoFitColumns() on a worksheetException 
CELLSNET-44556Exception occurred when saving an Excel documentException 
CELLSNET-44554CellsException: error in Cell: C2-Length cannot be less than zero, at Workbook ctorException 
CELLSNET-44546Exception: “Invalid password” while opening an encrypted Excel XLS file by Aspose.Cells APIsException 

2) Aspose.Cells Grid Suite

CELLSNET-44515Add/Remove context menu items in Aspose.Cells.GridWebNew Feature 
CELLSNET-44565Support CellsHelper.GetVersion() API for GridWebEnhancement 
CELLSNET-44583GridWeb control’s height grows on scrolling down post backBug 
CELLSNET-44580Scrollbar moves down on IE11 and sometimes GridWeb loses grid formattingBug 
CELLSNET-44550Paging is not working after specifying the Session storage path - Aspose.Cells.GridWebBug 
CELLSNET-44547Gridweb changes layout when page index is changedBug 
CELLSNET-44539Gridweb is not refreshing after scrolling or page change because of registering Telerik RadAjaxManager controlBug 
CELLSNET-44537Layout problem of Dropdown in GridWebBug

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 HtmlSaveOptions.DefaultFontName property

Specifies the default font name while exporting HTML, the default font will be used  when the font of style does not exist. If this property is null, Aspose.Cells will use universal font which has the same family with the original font, the default value is null.

Adds PivotTable.IsExcel2003Compatible property

Specifies whether the PivotTable is compatible for Excel2003 when refreshing PivotTable. If true, a string must be less than or equal to 255 characters, so if the string is greater than 255 characters, it will be truncated. If false, a string will not have the aforementioned restriction. The default value is true.

Adds ImageOrPrintOptions.DefaultFont property

When characters in the Excel are unicode and not to be set with correct font in cell style, They may appear as block in PDF and image. Set the DefaultFont such as MingLiu or MS Gothic to show these characters. If this property is not set, Aspose.Cells will use System’s default font to show these unicode characters.

Adds GetVersion method in GridWeb.

Get the release version.