Browse our Products

Aspose.Cells for .NET 16.11.0 Release Notes

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