Aspose.Cells for .NET 16.11.0 Release Notes
Contents
[
Hide
]
| 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.