Released: Nov 11, 2016

Updates in V16.11.0

Features

• Support for MINIF and MAXIF functions.
• Mimics MS Excel behavior when the "Enter" key is pressed.
• Web links on a spreadsheet are now opened on the same page where the GridWeb is loaded.

Fixes

• UpdateLinkedDataSource() doesn't work when a Workbook is loaded from a stream.
• Deprecated .size() function used in acwmain.js.
• Set focus on the formula back when inserting a formula with wrong parameters (invalid formula).
• Performance issue with GetPivotData function.
• Issue with SheetRender.PageCount that takes a long time to calculate worksheet pages.
• Range.Copy() method freezes for big Excel ranges.
• Spreadsheet becomes corrupted when Workbook names is appended to the Named Range.
• RTL direction is changed to LTR while converting HTML to Excel.
• PivotTable is losing filters after RefreshData call.
• PivotTable fails to refresh after changing data source to a Named Range.
• Calling PivotTable.CalculateData() causes a crash when there is 1 data column.
• Excel file is corrupt after opening and resaving it.
• CSS style ignored for column widths, row heights and word wrap, etc. (HTML to Excel).
• Issue with font-weight and text-align in TD and TH cells.
• PivotTable contents are not showing correctly in the output PDF.
• Culture settings for Workbook does not take effect for Chart DataLabels using Chart.ToImage.
• SUMPRODUCT function with external ranges results in '#REF!' error.
• Long values in cell renders as '#' string while converting worksheet to image.
• Issue with the size of the converted file (Excel to PDF Conversion).
• Considerable increase in the output PDF file size from a relatively smaller Excel file.
• Label is missing when a chart is converted into image.
• Trendline in the chart is not rendering fine in the output PDF.
• SheetRender.ToImage: Chart overlaps the row below it.
• Formula gets _xlfn prefix after the calculation of workbook
• Resave operation corrupts the spreadsheet when worksheet name is " or ".
• Corrupted output file generated by Aspose.Cells APIs.
• The shapes are not in the same order (as per the original shapes' z order position)
• Removing image from header/footer corrupts the document.
• Changing background image of a shape corrupts output XLS file
• Line spacing from TextBox is lost with simple re-save.
• ThreeDFormat.TopBevelWidth and TopBevelHeight are not getting applied.
• Open and Save document creates corrupted file.
• Issue with updating External Link's data source and AbsPath.
• Font of Chart Data labels and Legend is changed on opening and re-saving source Excel file.
• Unable to update address of a GridHyperlink.
• Set alternative text for hyperlink if image URL is not correct.
• Accessing hyperlink via cell reference is not possible with GridHyperlinkCollection class.
• Obsoleted APIs are not identified in Visual Studio.
• Width of Auto-Filter's Dropdown is too small to make a selection.
• Trendline in the chart is not rendering fine - Aspose.Cells.GridDesktop.
• Auto filters are applied to all the columns instead of specific range/columns only.
• RowFilteredEvent of GridDesktop never occurs.
• Hidden rows due to filter remain hidden after removing the filter.
• Certain formatting elements in the template XLSM file are not imported correctly.
• GridDesktop.Button click event never fires on 200% zoom.
• Aspose.Cells.GridDesktop: Paste is Always inactive in context menu.
• GridWeb control, column disappear if drag to left.
• Save as HTML causes NullReferenceException.
• Value in scientific notation is throwing an exception.
• Exception is thrown when converting from specific XLS to XLSX.
• Stack overflow when using FileFormatUtil.DetectFileFormat.
• NullReferenceException when calling Workbook.Save.
• System.ArgumentOutOfRangeException at Hyperlinks.RemoveHyperlink.
• Random System.ArgumentException while deleting row.
• IndexOutOfRangeException, while inserting rows on GridDesktop.
• IndexOutOfRangeException, while deleting rows on GridDesktop.
• Error: Object reference not set to an instance of an object, after inserting a deleting a value.
• JavaScript runtime error: Object does not support property or method 'fireEvent'.