Aspose.Cells for .NET 17.1.0 Release Notes

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

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.