Aspose.Cells for .NET V16.11.0

Prend en charge les fonctions MINIF et MAXIF, et reproduit le comportement d’Excel lorsque vous appuyez sur la touche « Entrée ».
Novembre 11, 2016
Nouvelle Version

Fonctionnalités

  • Support for MINIF and MAXIF functions.
  • Mimics Microsoft 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.

Correctifs

  • 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'.
Aspose.Cells for .NET

Aspose.Cells for .NET

Créez et gérez des feuilles de calcul Excel sans passer par Microsoft Excel.

Vous avez une question ?

Discutez en direct avec l'un de nos spécialiste des licences Aspose .