Aspose.Cells for .NET 16.11.0 Release Notes

Key Summary Category
CELLSNET-44702 Support MINIF and MAXIF functions New Feature 
CELLSNET-44864 Web links on spreadsheet are opened on the same page where GridWeb is loaded New Feature 
CELLSNET-44810 UpdateLinkedDataSource() doesn’t work when Workbook is loaded from stream  Enhancement 
CELLSNET-44877 Deprecated .size() function used in acwmain.js Enhancement 
CELLSNET-44801 Mimic MS Excel behavior when “Enter” key is pressed Enhancement 
CELLSNET-44793 Set focus on the formula back when inserting a formula with wrong parameters (invalid formula) Enhancement 
CELLSNET-44847 Performance issue with GetPivotData function Performance
CELLSNET-44832 Issue with SheetRender.PageCount that takes a long time to calculate worksheet pages Performance
CELLSNET-44861 Range.Copy() method freezes for big Excel ranges Performance
CELLSNET-44854 Spreadsheet becomes corrupted when Workbook names is appended to the Named Range Bug 
CELLSNET-44852 RTL direction is changed to LTR while converting HTML to Excel Bug 
CELLSNET-44846 PivotTable is losing filters after RefreshData call Bug 
CELLSNET-44823 Pivot Table fails to refresh after changing data source to a Named Range Bug 
CELLSNET-44814 Calling PivotTable.CalculateData() causes a crash when there is 1 data column Bug 
CELLSNET-44799 Excel file is corrupt after opening and resaving it Bug 
CELLSNET-44790 CSS style ignored for column widths, row heights and word wrap, etc. (HTML to Excel)  Bug 
CELLSNET-44786 Issue with font-weight and text-align in TD and TH cells Bug 
CELLSNET-44448 PivotTable contents are not showing correctly in the output PDF  Bug 
CELLSNET-44892 Culture settings for Workbook does not take effect for Chart DataLabels using Chart.ToImage Bug 
CELLSNET-44809 SUMPRODUCT function with external ranges results in ‘#REF!’ error Bug 
CELLSNET-44818 Long values in cell renders as ‘#’ string while converting worksheet to image Bug 
CELLSNET-43623 Issue with the size of the converted file (Excel to PDF Conversion) Bug 
CELLSNET-43439 Considerable increase in the output PDF file size from a relatively smaller Excel file Bug 
CELLSNET-44842 Label is missing when a chart is converted into image Bug 
CELLSNET-44806 Trendline in the chart is not rendering fine in the output PDF Bug 
CELLSNET-44737 SheetRender.ToImage: Chart overlaps the row below it Bug 
CELLSNET-44885 Formula gets _xlfn prefix after the calculation of workbook Bug 
CELLSNET-44884 Resave operation corrupts the spreadsheet when worksheet name is " or " Bug 
CELLSNET-44880 Corrupted output file generated by Aspose.Cells APIs Bug 
CELLSNET-44879 The shapes are not in the same order (as per the original shapes' z order position) Bug 
CELLSNET-44869 Removing image from header/footer corrupts the document Bug 
CELLSNET-44868 Changing background image of a shape corrupts output XLS file Bug 
CELLSNET-44866 Line spacing from TextBox is lost with simple re-save Bug 
CELLSNET-44830 ThreeDFormat.TopBevelWidth and TopBevelHeight are not getting applied Bug 
CELLSNET-44827 Open and Save document creates corrupted file  Bug 
CELLSNET-44817 Issue with updating External Link’s data source and AbsPath Bug 
CELLSNET-44703 Font of Chart Data labels and Legend is changed on opening and re-saving source Excel file Bug 
CELLSNET-44878 Unable to update address of a GridHyperlink Bug 
CELLSNET-44857 Set alternative text for hyperlink if image URL is not correct Bug 
CELLSNET-44856 Accessing hyperlink via cell reference is not possible with GridHyperlinkCollection class Bug 
CELLSNET-44841 Obsoleted APIs are not identified in Visual Studio Bug 
CELLSNET-44840 Width of Auto-Filter’s Dropdown is too small to make a selection Bug 
CELLSNET-44805 Trendline in the chart is not rendering fine - Aspose.Cells.GridDesktop Bug 
CELLSNET-44798 Auto filters are applied to all the columns instead of specific range/columns only Bug 
CELLSNET-44797 RowFilteredEvent of GridDesktop never occurs Bug 
CELLSNET-44796 Hidden rows due to filter remain hidden after removing the filter Bug 
CELLSNET-44792 Certain formatting elements in the template XLSM file are not imported correctly Bug 
CELLSNET-44783 GridDesktop.Button click event never fires on 200% zoom Bug 
CELLSNET-44745 Aspose.Cells.GridDesktop: Paste is Always inactive in context menu Bug 
CELLSNET-44698 GridWeb control, column disappear if drag to left  Bug 
CELLSNET-44886 Save as HTML causes NullReferenceException Exception 
CELLSNET-44875 Exception while saving PulseSecure_PriceList_FLAT FILE_Nov2016_102816_v1.0.xlsx Excel file to HTML Exception 
CELLSNET-44874 Exception while saving PulseSecure_PriceList_FLAT_FILE_Oct2016.xlsx Excel file to HTML Exception 
CELLSNET-44873 Exception while saving PulseSecure_PriceList_Nov2016_102816_v1.0.xlsx Excel file to HTML Exception 
CELLSNET-44872 Exception while saving PulseSecure_PriceList_Oct2016_093016_v1.xlsx Excel file to HTML Exception 
CELLSNET-44882 Value in scientific notation is throwing exception Exception 
CELLSNET-44849 Exception is thrown when converting from specific XLS to XLSX  Exception 
CELLSNET-44898 Stack overflow when using FileFormatUtil.DetectFileFormat Exception 
CELLSNET-44834 NullReferenceException when calling Workbook.Save Exception 
CELLSNET-44836 System.ArgumentOutOfRangeException at Hyperlinks.RemoveHyperlink Exception 
CELLSNET-44795 Random System.ArgumentException while deleting row Exception 
CELLSNET-44782 IndexOutOfRangeException, while inserting rows on GridDesktop Exception 
CELLSNET-44781 IndexOutOfRangeException, while deleting rows on GridDesktop Exception 
CELLSNET-44770 Error: Object reference not set to an instance of an object, after inserting a deleting a value Exception 
CELLSNET-44725 JavaScript runtime error: Object does not support property or method ‘fireEvent’ 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 Workbook.AbsolutePath property

Gets and sets the Absolute path of the file. Only used for external links.

Adds GlobalizationSettings class and WorkbookSettings.GlobalizationSettings property

Gets and sets the globalization settings.

Removes obsoleted Cell.GetConditionalStyle() method

Use Cell.GetConditionalFormattingResult() method instead.

Removes obsoleted Cells.MaxDataRowInColumn(int column) method

Use Cells.GetLastDataRow(int) method instead.

Removes Obsoleted PageSetup.Draft property

Use PageSetup.PrintDraft property instead.

Removes obsoleted AutoFilter.FilterColumnCollection property

Use AutoFilter.FilterColumns property instead.

Obsoletes the Style constructor and adds CellsFactory class

Use CellsFactory.CreateStyle() method instead.

Removes obsoleted TickLabels.Rotation property

Use TickLabels.RotationAngle property instead.

Adds GridHyperlinkCollection.GetHyperlink(GridCell cell) method

Gets the cell’s Hyperlink object. If there is no Hyperlink of the cell, it returns null.

Adds GridHyperlinkCollection.GetHyperlink(int row,int column) method

Gets the cell’s Hyperlink object. If there is no Hyperlink of the cell, it returns null.