Aspose.Cells for .NET 8.9.0 Release Notes
1) Aspose.Cells
| Key | Summary | Category |
|---|---|---|
| CELLSNET-44574 | Support expanding text from right to left when exporting file to HTML | New Feature |
| CELLSNET-44561 | Ability to set Default Font while rendering spreadsheet to HTML | New Feature |
| CELLSNET-44562 | Ability to set Default Font while rendering spreadsheet to images | New Feature |
| CELLSNET-44552 | Refreshing Pivot Table throws exception | Bug |
| CELLSNET-44542 | Excel file is not properly rendering into HTML file format | Bug |
| CELLSNET-44541 | Contents overlap while converting spreadsheet to HTML | Bug |
| CELLSNET-44520 | Pivot Field’s dropdown is missing after re-saving XLSX as XLSB | Bug |
| CELLSNET-44518 | Spreadsheet becomes corrupted after re-saving XLSX as XLSB | Bug |
| CELLSNET-44501 | Refreshing and Calculating Data on existing Pivot Table generates corrupt Excel file | Bug |
| CELLSNET-44447 | Chart.ToImage is generating incorrect image | Bug |
| CELLSNET-43656 | Some text items are slightly truncated in the output HTML | Bug |
| CELLSNET-44590 | Problem exporting Excel to PDF with special characters in the header and footer | Bug |
| CELLSNET-44517 | Vertical alignment wrong when generating range to image using SheetRender.ToImage | Bug |
| CELLSNET-44589 | Aspose.Cells generated EMF shows incorrect axis labels when inserted into Word document and converted to PDF | Bug |
| CELLSNET-44586 | Less than single spacing doesn’t export to PDF properly | Bug |
| CELLSNET-44564 | Chart’s EMF generated under Session 0 does not display all the contents | Bug |
| CELLSNET-44559 | Chart.HasAxis is showing wrong value | Bug |
| CELLSNET-44538 | Empty PNG 0KB file generated while converting XLSX to HTML | Bug |
| CELLSNET-44591 | Cells.ClearContents removes the formula for the cells below the specified range | Bug |
| CELLSNET-44577 | Issue with Worksheet.Copy() - All comments after IV column are missing in the copied sheet | Bug |
| CELLSNET-44573 | Pictures in worksheets copied from an external XLSX are not sized the same as originals | Bug |
| CELLSNET-44571 | Copying workbook into new workbook produced unreadable content error | Bug |
| CELLSNET-44568 | TextBox in the chart is lost while copying Workbooks | Bug |
| CELLSNET-44567 | Chart colors are lost while copying workbook | Bug |
| CELLSNET-44545 | Formula results in “#NAME” error after copying the rows and calculating formulas | Bug |
| CELLSNET-44544 | Formula is replaced by 0 after copying the rows and calculating formulas | Bug |
| CELLSNET-44543 | The fill format of shape is lost when converting the file to HTML | Bug |
| CELLSNET-41153 | Printing zone is moved a bit using latest versions of the product | Bug |
| CELLSNET-44599 | Showing total for list object with only 1 record corrupts the workbook | Bug |
| CELLSNET-44598 | Incorrect ListObject size after ShowTotals set to false | Bug |
| CELLSNET-44563 | Exception: “Input string was not in a correct format.” when loading an HTML file format | Exception |
| CELLSNET-44560 | Problem with saving a workbook | Exception |
| CELLSNET-44558 | ArgumentNullException at WorksheetCollection.GetNamedRanges method | Exception |
| CELLSNET-44588 | ArgumentOutOfRangeException while calling AutoFitColumns() on a worksheet | Exception |
| CELLSNET-44556 | Exception occurred when saving an Excel document | Exception |
| CELLSNET-44554 | CellsException: error in Cell: C2-Length cannot be less than zero, at Workbook ctor | Exception |
| CELLSNET-44546 | Exception: “Invalid password” while opening an encrypted Excel XLS file by Aspose.Cells APIs | Exception |
2) Aspose.Cells Grid Suite
| Key | Summary | Category |
|---|---|---|
| CELLSNET-44515 | Add/Remove context menu items in Aspose.Cells.GridWeb | New Feature |
| CELLSNET-44565 | Support CellsHelper.GetVersion() API for GridWeb | Enhancement |
| CELLSNET-44583 | GridWeb control’s height grows on scrolling down post back | Bug |
| CELLSNET-44580 | Scrollbar moves down on IE11 and sometimes GridWeb loses grid formatting | Bug |
| CELLSNET-44550 | Paging is not working after specifying the Session storage path - Aspose.Cells.GridWeb | Bug |
| CELLSNET-44547 | Gridweb changes layout when page index is changed | Bug |
| CELLSNET-44539 | Gridweb is not refreshing after scrolling or page change because of registering Telerik RadAjaxManager control | Bug |
| CELLSNET-44537 | Layout problem of Dropdown in GridWeb | Bug |
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.