Aspose.Cells for .NET 17.11 Release Notes

CELLSNET-45748XmlMapQuery like functionality needed as available in MS ExcelNew Feature 
CELLSNET-45747Associated property needed for XMLMaps to get the RootElementName for the mapNew Feature 
CELLSNET-45709Scale becomes smaller - Fonts issueNew Feature 
CELLSNET-45743Protect shared workbook - Set or change passwordNew Feature 
CELLSNET-45737Support PasteType for Aspose.Cells.GridDesktop during Copy/Paste actionsNew Feature 
CELLSNET-45755Unable to get Text of Smart Art shapes  Enhancement 
CELLSNET-45720Pivot table is taking too long to refresh data Performance
CELLSNET-45680Direction of shape is wrong when converted to image format  Bug 
CELLSNET-45679Star shapes are not shown correctly in the output PDF Bug
CELLSNET-45669Characters overlap when converting to imageBug 
CELLSNET-45665Some drawing elements are inverted while others are shifted to the rightBug 
CELLSNET-43912Position of the line objects changed while rendering the spreadsheet to PDFBug 
CELLSNET-45715PivotTable options - Show the values row - gets enabled on re-savingBug 
CELLSNET-45671Missing total values for the calculated fields when refreshing/calculating PivotTable dataBug 
CELLSNET-45650Error of expanding data to proper columns when saving an MHTML file format to Excel fileBug 
CELLSNET-45721LightCellsDataProvider is removing leading and trailing spacesBug 
CELLSNET-45719Formula calculation resolves formula unexpectedly to errorBug 
CELLSNET-45724Saving Excel as PDF decreases column widthBug 
CELLSNET-45712Legend of the chart is missing in the output PDFBug 
CELLSNET-45710Number formatting in chart is lost after saving an Excel file as PDFBug 
CELLSNET-45708PDF file created by Aspose.Cells causes error in Adobe Acrobat ReaderBug 
CELLSNET-45684Chart to image or PDF - 3D Line Chart is not correct or rotatedBug 
CELLSNET-45760Validation is not correctly copied from one worksheet to anotherBug 
CELLSNET-45758Style.QuotePrefix property does not work for XLSB file formatBug 
CELLSNET-45757Specific Excel workbook becomes hidden after opening and savingBug 
CELLSNET-45754Columns were expanded unexpectedly in the merged workbookBug 
CELLSNET-45749HTML string having multiple fonts corrupts the output Excel fileBug 
CELLSNET-45739SpreadsheetML file when re-saved via Aspose.Cells contains additional protection settings appliedBug 
CELLSNET-45738AutoFitColumns breaks HTML formatting in the output Excel fileBug 
CELLSNET-45734MS Excel prompts an error message when opening the output fileBug 
CELLSNET-45733Textbox font is changed after ungrouping shape(s)Bug 
CELLSNET-45714The row height becomes too big after autofitting rows Bug 
CELLSNET-45735Issue with CellColor when using the context menu to changeBug 
CELLSNET-45707Exception when using PivotTable.RefreshDataException 
CELLSNET-45728Index was out of range exception when saving as PDF page Exception 
CELLSNET-45704Workbook.Save() fails with an exception when using Aspose.Cells as an Azure web jobException 
CELLSNET-45753When XLSB is converted to PDF, System.ArgumentOutOfRangeException occurs Exception 
CELLSNET-45751ExportTableOptions.Indexes property used in ExportDataTable() method causes exceptionException 
CELLSNET-45726Exception while loading the output XLS file (with OLE Objects, images, etc. excluded)Exception 
CELLSNET-45723R1C1Formula throws exception if formula contains character “[”  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 Shape.GetResultOfSmartArt() method

Convert the smart art to a group shape.

Adds Shape.IsSmartArt property

Indicates whether the shape is smart art.

Workbook.ProtectSharedWorkbook() and Workbook.UnprotectSharedWorkbook() method

Protects and unprotects the shared workbook.

Adds enum StyleModifyFlag.Spacing

Specifies the spacing between characters within a text run.

Adds PdfSaveOptions.IgnoreError property

Indicates if you need to hide the error while rendering.

Adds ImageOrPrintOptions.PageIndex property

Gets or sets the 0-based index of the first page to save.

Adds ImageOrPrintOptions.PageCount property

Gets or sets the number of pages to save.

Adds XmlMap.RootElementName property

Gets root element name.

Adds Worksheet.XmlMapQuery(string path, XmlMap xmlMap) method

Query cell areas that mapped/linked to the specific path of xml map.

Adds GridDesktop.PasteType property

Gets or sets which paste type apply for paste action, only available when EnableClipboardCopyPaste is false.

Adds LoadOptions.AutoFitterOptions property

Gets and sets the auto fitter options.

Usage Examples

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