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.