Aspose.Cells for .NET 17.1.0 Release Notes

Key	Summary	Category
CELLSNET-44747	MS Excel 2016 XLSX file containing Waterfall chart cannot be opened via Aspose.Cells APIs	New Feature
CELLSNET-44940	Bind Worksheet to a Customized Collection object (Aspose.Cells.GridWeb)	New Feature
CELLSNET-44939	Bind Worksheet to a DataSet object at Run Time (Aspose.Cells.GridWeb)	New Feature
CELLSNET-44597	Output Excel file is not good when converting an HTML file to Excel file format	Enhancement
CELLSNET-44994	Issue with Date format in German locale when rendering an Excel file to PDF	Enhancement
CELLSNET-44986	Representation of double numbers in Aspose.Cells	Enhancement
CELLSNET-45023	PivotTable.RefreshData takes a lot of time	Performance
CELLSNET-45012	Performance of GETPIVOTDATA	Performance
CELLSNET-45009	Formulas with GETPIVOTDATA are not being recalculated in the output file	Bug
CELLSNET-45000	Some CSS rules ignored when importing HTML	Bug
CELLSNET-44993	Images in table has incorrect position	Bug
CELLSNET-44990	Content color has been changed	Bug
CELLSNET-44989	Content style has been changed	Bug
CELLSNET-44987	Contents have been displaced	Bug
CELLSNET-44982	Issue with overriding default styling of TH elements	Bug
CELLSNET-44980	Column position has been changed while refreshing the Pivot Table	Bug
CELLSNET-44968	Merged cells in XLSX are not displayed as merged in HTML	Bug
CELLSNET-44962	Horizontal and vertical lines are missing in Pivot Table after converting spreadsheet to PDF	Bug
CELLSNET-44997	LoadOptions.LoadFilter is not working expectedly	Bug
CELLSNET-44991	YIELD function result inaccurate when CalculateFormula() method is called	Bug
CELLSNET-44978	Calculating formula returns different results than MS Excel	Bug
CELLSNET-45019	Image rendered incorrectly when a cell has Egyptian pound symbol	Bug
CELLSNET-43815	WordArt objects become mere dots in the output PDF	Bug
CELLSNET-44976	Area chart is slanted at the end in PDF output unlike MS Excel file	Bug
CELLSNET-44969	Unnecessary lines appear in the chart image	Bug
CELLSNET-44941	Culture settings are not applying on output chart’s image	Bug
CELLSNET-44938	Graph is not rendered correctly when spreadsheet is converted to PDF	Bug
CELLSNET-44919	Image generated by Aspose.Cells gets distorted when inserted into Docx	Bug
CELLSNET-45047	Worksheet contents change after opening and resaving as illustrated in the second screenshot	Bug
CELLSNET-45046	Worksheet contents change after opening and resaving as illustrated in the first screenshot	Bug
CELLSNET-45027	Dotted cell borders are not retained while converting XLSX to ODS	Bug
CELLSNET-45021	Excel files get corrupted after loading and saving via Aspose.Cells APIs	Bug
CELLSNET-45008	Color of the hyperlink does not change when clicked in MS Excel	Bug
CELLSNET-45007	Spreadsheet becomes corrupted after simple load and re-save	Bug
CELLSNET-44999	WorksheetCollection.CreateRange does not seem to create a range	Bug
CELLSNET-44996	Arrow links are broken between objects in process flow when using Aspose.Cells APIs	Bug
CELLSNET-44992	Excel shows “Name cannot be the same as a built-in name” message after saved with Aspose.Cells	Bug
CELLSNET-43770	Formula is calculated wrongly by Workbook.CalculateFormula() method and output file is corrupted	Bug
CELLSNET-43733	WordArt Text in TextBox renders as outline only rather than filled characters while converting spreadsheet to PDF	Bug
CELLSNET-43725	Resizing the ListObject in XLSM with external data range makes the result corrupted	Bug
CELLSNET-43580	This WordArt watermark is not printed properly as the color/style is changed in the output PDF	Bug
CELLSNET-43562	Filtering on columns is lost when XLSX is converted to ODS	Bug
CELLSNET-43405	Function’s text gets corrupted and WordArt text becomes white after converting an XLS to XLSX file format	Bug
CELLSNET-43404	Formatting of WordArt text in XLS file gets changed after converting into XLSX file format	Bug
CELLSNET-41938	Formatting issues (regarding WordArt) with XLS file	Bug
CELLSNET-41708	Issue with adding 3D effects to Shapes (TextBox) created by using Aspose.Cells	Bug
CELLSNET-41164	SmartArt support in Excel-to-PDF rendering	Bug
CELLSNET-40903	Issue with GlowEffect	Bug
CELLSNET-45006	Merged cells appear to be unmerged while load existing spreadsheet to GridWeb	Bug
CELLSNET-44802	Issue with Copy/Paste merged cell - Aspose.Cells.GridDesktop	Bug
CELLSNET-43962	WebWorksheet.GroupRows or GridWorkSheet.GroupRows isn’t working as expected	Bug
CELLSNET-40897	Spreadsheet with form controls	Bug
CELLSNET-45031	NullReferenceException in PivotTable.RefreshData with Slicer	Exception
CELLSNET-45041	Exception when saving an Excel file	Exception
CELLSNET-45016	Exception on opening a template XLSX file	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 setter for LoadFilter.LoadDataFilterOptions property to replace m_LoadDataFilterOptions variable

User may change the LoadDataFilterOptions property in their implementation of LoadFilter to change the behavior of loading workbook.

Adds CellsHelper.SignificantDigits property

Gets and sets the number of significant digits.

Adds GlowEffect.Color property

Gets the color of the glow effect.

Adds PageSetup.PaperWidth property

Represents the width in inches of the paper, considered page orientation.

Adds PageSetup.PaperHeight property

Represents the height in inches of the paper, considered page orientation.

Adds WorkbookSettings.CheckCustomNumberFormat property

Indicates whether checking custom number format when setting Style.Custom.

Adds some chart types

Adds more chart types for MS Office 2016.

Adds DisplayUnitType.Percentage enum

Represents values on the chart shall be divided by 0.01.