Aspose.Cells for .NET 17.10 Release Notes

CELLSNET-45695Set number format for cells in Chart’s Data TableNew Feature 
CELLSNET-45666Get SheetId field of Excel worksheetNew Feature 
CELLSNET-45664Reading and writing External connection of XLSB file New Feature 
CELLSNET-45660Sheet to Image rendering - Alignment issue for Asian fontsEnhancement 
CELLSNET-45408Value disappears or changes color when convert to PDF Bug 
CELLSNET-45696Slicer is not moving down in the sheet when inserting rowsBug 
CELLSNET-45675Error calculating the formulas (involving “SUMPRODUCT” and “TRANSPOSE”)Bug 
CELLSNET-45651TextBox size changes when using Chinese font in the workbook in rendering to PDFBug 
CELLSNET-45678Partially missing characters when converting to imageBug 
CELLSNET-45667Trendline labels are not updated in MS Excel when we manually change the source value in the cellsBug 
CELLSNET-45620Color and interval between scale is different for 3D chart Bug 
CELLSNET-45397Aspose.Cells recognizes fonts in the chart incorrectlyBug 
CELLSNET-45700MS Excel 2016 Add-in pane removed from file after open/save by Aspose.CellsBug 
CELLSNET-45693Worksheet is no more protected in the output file in SpreadsheetML to XLSX conversionBug 
CELLSNET-45691Document is corrupted when re-saving itBug 
CELLSNET-45690Styles seem to be carried over wrongly for some cells - SpreadsheetML to XLSX conversionBug 
CELLSNET-45688Date column is not sorted correctlyBug 
CELLSNET-45687Worksheets protection properties are not carried from SpreadsheetMLBug 
CELLSNET-45683SpreadsheetML AllowSort element doesn’t work in the output XLSXBug 
CELLSNET-45682MS Excel prompts an error message “Excel found unreadable content….”Bug 
CELLSNET-45676Document is corrupted when re-saving due to non-break space in worksheet nameBug 
CELLSNET-45673Alignment style applying for SpredsheetMLBug 
CELLSNET-45670Cells color is lost on converting to ImageBug 
CELLSNET-45692GridWeb does not ungroup rows on clicking the “+” buttonBug 
CELLSNET-45654Comment added to the cell is not retrieved on client side - Aspose.Cells.GridWebBug 
CELLSNET-45645Exception occurs on opening the BUDGET RH 3_0.xlsm in GridWebBug 
CELLSNET-45657Input string was not in a correct format - Exception on Pivot.CalculateData() methodException 
CELLSNET-45703Exception when converting XLSM file back to XLS file formatException 

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 AbstractCalculationMonitor.Interrupt(string) method

Allows users to interrupt the progress of formula calculations.

Adds HtmlCrossType.MSExport enum

Displays the string like MS Excel exporting HTML.

Adds Worksheet.TabId property

Gets the internal identifier for the sheet.

Adds enum OLEDBCommandType.None

The command type is not specified.

Adds enum ConnectionDataSourceType

Represents the data source type of connection.

Obsoletes ExternalConnection.Credentials and ExternalConnection.ReConnectionMethod property

Use ExternalConnection.CredentialsMethodType and ExternalConnection.ReconnectionMethodType property instead.

Obsoletes WebQueryConnection.EditPage property

Use WebQueryConnection.EditWebPage property instead.

Adds Seris.ValuesFormatCode property

Represents number format code of series values.

Usage Examples

Please check the list of help topics added in the Aspose.Cells Wiki docs: