Aspose.Cells for .NET 16.10.0 Release Notes

1) Aspose.Cells

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

2) Aspose.Cells Grid Suite

Key Summary Category
CELLSNET-44724 Support Custom Functions in Aspose.Cells.GridWeb New Feature 
CELLSNET-44784 Copy operation behaves as Cut operation by removing the copied value from the original cell Bug 
CELLSNET-44777 Deleting hyperlink cell crashes Aspose.Cells.GridDesktop Bug 
CELLSNET-44776 Adding hyperlink and then editing and removing it via context menu crashes GridDesktop Bug
CELLSNET-44774 Wrong formula causes application crash - Aspose.Cells.GridDesktop Bug 
CELLSNET-44748 GridDesktop crashed when we start writing formula directly into the formula bar Bug 
CELLSNET-44739 Aspose.Cells can find the embedded license but Aspose.Cells.GridDesktop cannot Bug 
CELLSNET-44738 Unable to enable AutoFilter for Rows Bug 
CELLSNET-44753 GridDesktop hangs while loading a malformed spreadsheetML Bug 
CELLSNET-44773 Exception when using the “Insert Comment” context menu item Exception 
CELLSNET-44782 IndexOutOfRangeException, while inserting rows on GridDesktop 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.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.