Aspose.Cells for .NET 16.10.0 Release Notes

1) Aspose.Cells

KeySummaryCategory
CELLSNET-44374Import xml map by defining an array of only some columns that are related to the xml mapNew Feature 
CELLSNET-44701API hides the row containing the DIV tag with style display:noneEnhancement 
CELLSNET-44700API does not import the contents between the DIV tags having style display:blockEnhancement 
CELLSNET-44699API does not import contents between the DIV tags of HTMLEnhancement 
CELLSNET-44304PivotTable.GetCellByDisplayName returns null for anything over the 256th fieldEnhancement 
CELLSNET-44808Formula in Table or ListObject does not propagate with new rowsEnhancement 
CELLSNET-44719Workbook.Worksheets.ExternalLinks does not return the same listEnhancement 
CELLSNET-44721Resultant spreadsheet cannot be loaded in MS ExcelBug 
CELLSNET-44695Load from HTML ignores bold style from style blockBug 
CELLSNET-44779Calculated value of cell D5 is wrongBug 
CELLSNET-44775Excel To PDF Conversion - Number of pages increased in the output PDF file format Bug 
CELLSNET-44771Loss of text while converting Excel to PDF Bug 
CELLSNET-44733Hidden text due to less column width has rendered in imageBug 
CELLSNET-44768Chart title does not change dynamicallyBug 
CELLSNET-44763Chart defined using hebrew language pack in MS Office is not exported correctly to imageBug 
CELLSNET-44730Justified list does not display properly in output PDFBug 
CELLSNET-44729Numbered lists in Excel do not display properly when exporting to PDFBug 
CELLSNET-44720Arc ends are square not round in the output PDF Bug 
CELLSNET-44715API returns Pie Chart’s Slice color as NoneBug 
CELLSNET-44804Workbook having a hyperlink to another worksheet with name containing ‘#’ character becomes corruptedBug 
CELLSNET-44791Object positioning changes after simple load and save operationBug 
CELLSNET-44772Issue with hyperlinks by adding “file:///” or similarBug 
CELLSNET-44769Conditional formatting becomes corrupted when the workbook is processed by Aspose.Cells APIsBug 
CELLSNET-44767Cell shading is applied automatically while applying named styleBug 
CELLSNET-44759Hyperlink cannot be added to a new commentBug 
CELLSNET-44758Hyperlink cannot be added to an existing commentBug 
CELLSNET-44756Textbox deleted after saving workbookBug 
CELLSNET-44755Excel crashes after copying a range/column to another worksheetBug 
CELLSNET-44754Aspose.Cells does not get single quote when retrieving formulas of the cellsBug 
CELLSNET-44751Spreadsheet becomes corrupted after simple open and saveBug 
CELLSNET-44743Adding hyperlink inside the cell comment is not workingBug 
CELLSNET-44735Issue with updating external link with special characterBug 
CELLSNET-44731#NAME error for dynamically injected PERCENTILE.INC functionBug 
CELLSNET-44726Copying/Inserting rows resulted in unexpected borders in the output Excel fileBug 
CELLSNET-44642Resaving the Excel file changes the default fontBug 
CELLSNET-44785NullReferenceException on opening a specific file (XLSB)Exception 
CELLSNET-44760IndexOutOfRangeException while initializing SheetRenderException 
CELLSNET-44765System.ArgumentOutOfRangeException at Workbook ctorException 
CELLSNET-44757System.NullReferenceException on opening the source XLSB fileException 
CELLSNET-44750Exception:“Invalid column index.” while rendering a worksheet to image fileException 
CELLSNET-44742System.FormatException: Input string was not in a correct format, at Workbook ctorException 

2) Aspose.Cells Grid Suite

KeySummaryCategory
CELLSNET-44724Support Custom Functions in Aspose.Cells.GridWebNew Feature 
CELLSNET-44784Copy operation behaves as Cut operation by removing the copied value from the original cellBug 
CELLSNET-44777Deleting hyperlink cell crashes Aspose.Cells.GridDesktopBug 
CELLSNET-44776Adding hyperlink and then editing and removing it via context menu crashes GridDesktopBug
CELLSNET-44774Wrong formula causes application crash - Aspose.Cells.GridDesktopBug 
CELLSNET-44748GridDesktop crashed when we start writing formula directly into the formula barBug 
CELLSNET-44739Aspose.Cells can find the embedded license but Aspose.Cells.GridDesktop cannotBug 
CELLSNET-44738Unable to enable AutoFilter for RowsBug 
CELLSNET-44753GridDesktop hangs while loading a malformed spreadsheetMLBug 
CELLSNET-44773Exception when using the “Insert Comment” context menu itemException 
CELLSNET-44782IndexOutOfRangeException, while inserting rows on GridDesktopException 

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.Reflection property and ReflectionEffect class

Represents reflection effect for the chart element or shape.

Adds Shape.Glow, GlowEffect.Size and GlowEffect.Transparency properties

Represents glow effect for the chart element or shape.

Adds LightRigType.None enum

Represents no lighting setting.

Adds Shape.ShadowEffect property

Represents shadow effect for the chart element or shape.

Adds ExternalLink.IsVisible property

Indicates whether the external link is visible.

Adds Shape.ThreeDFormat property and ThreeDFormat class

Gets and sets 3d format of the shape.

Adds PresetCameraType enum

Represents different algorithmic methods for setting all camera properties, including position.

Adds LightRigDirectionType enum

Represents the light rig direction type.

Adds BevelType enum

Represents a preset for a type of bevel which can be applied to a shape in 3D.

Adds XmlMapCollection.Add(string url) method

Adds an XmlMap by the url/path of an XML file.

Adds ShapeCollection.AddWordArt() method and PresetWordArtStyle enum

Adds preset WordArt since MS Excel 2007.

Adds FontSettingCollection.SetWordArtStyle() method and FontSetting.SetWordArtStyle() method

Sets preset WordArt style to the text of the shape.

Adds Cells.LinkToXmlMap(string mapName, int row, int column, string path) method

Link to an xml map.

Adds ListColumn.Formula property

Gets and sets the formula of the list column.

Adds GridWeb.CustomCalculationEngine property and GridAbstractCalculationEngine class

Represents user’s custom calculation engine to extend the default calculation engine of Aspose.Cells.GridWeb.