Aspose.Cells for .NET V18.3

Group pivot fields in a Pivot Table.
April 5, 2018
New Version

Features

  • Group pivot fields in a Pivot Table.

Fixes

  • Exception during backward HTML-to-Cells conversion.
  • Add property to the StyleFlag to not override the QuotePrefix value.
  • ActiveX control becomes a picture when copying a sheet from one workbook to another.
  • Data validation - GridWeb should display a dialog with an error message.
  • Workbook.CalculateFormula hangs infinitely when setting specific value to the cell.
  • Underline of text "KEY DRIVERS:" is broken in the output image.
  • Besides broken underline, text is also misalignedt.
  • Some shapes are not rendered completely.
  • Output Excel file of new version crashes the Microsoft Excel 2016.
  • Style issue with HTML to Excel rendering.
  • VLOOKUPS formula calculation is not working correctly.
  • Cell text alignment (having mixed fonts) is different in converted image.
  • Conditional formatting not applied while converting Excel file to PDF.
  • Unwanted borders appear around the image when Excel file is saved to PDF.
  • The cell reference for the data label gets lost after open/save.
  • Last axis label is missing from the chart image.
  • Bad position and line in the rendering of Market Risk chart.
  • Missing label in chart rendering.
  • Smart Art chart on tab - cones edges are jagged in the output PDF file format.
  • Dialogs not saving correctly in XLSM files.
  • Worksheet.Protect(ProtectionType.Objects) does not work for XLS files.
  • Hyperlink with hyphen in scheme breaks during save.
  • ConvertToRange() method breaks the Names in Name Manager.
  • Excel hangs when opening the output workbook.
  • Aspose.Cells.GridWeb culture date issue.
  • Column group does not work in GridWeb.
  • Tabs are not visible or partially visible on GridWeb in IE 11.
  • Offset issue in GridWeb worksheet on IE 11.
  • "<br>" is embedded into the cell on cell change in Aspose.Cells.GridWeb.
  • Formula disappears after validating/updating the value in the cell.
  • Error validating a cell.
  • Exception opening an XLSX file via Aspose.Cells APIs.
  • Invalid formula throws exception at start.
  • Exception when loading an ODS file.
  • System.IndexOutOfRangeException on opening XLSB files.
  • System.FormatException occurs while opening XLSX file.
  • Loading XLSX causes StackOverflowException.
Aspose.Cells for .NET V18.3
Aspose.Cells for .NET

Aspose.Cells for .NET

Create and manage Excel Spreadsheets without requiring Microsoft Excel.

Get Quote Buy Now

Aspose.Cells for .NET is also available in:

Got a Question?

Live Chat with our Aspose licensing specialists now.