Spire.XLS

Spire.XLS 9.8.5 supports creating chart based on PivotTable and enhances the conversions from Excel to PDF/HTML

We're pleased to announce the release of Spire.XLS 9.8.5. This version supports creating chart based on PivotTable and fixes a series of issues that occurred when converting Excel to PDF/Html, CSV to XLSX and copying cells range. See the content below for more details.

New Features:

  • Supports creating chart based on PivotTable.
  • worksheet.Charts.Add(ExcelChartType.BarClustered, pivotTable);
    

Bug Fixes:

  • Fixes the issue that incorrect line height was caused after setting AutoFitRow.
  • Fixes the issue that there were errors with the PivotTable after converting Excel to PDF or HTML.
  • Fixes the issue that messy content was caused after converting CSV to XLSX in .NET Core.
  • Fixes the issue that incorrect line was caused after converting Excel to PDF.
  • Fixes the issue that the conditional format was lost after copying range.
  • Fixes the issue that if the page number had blank space, there was a problem with the page number after adding.
  • Fixes the issue that incorrect Thai characters were caused after converting Excel to PDF.
  • Fixes the issue that incorrect chart data was caused after converting Excel to PDF.
  • Fixes the issue that the formula of trendline could not be returned correctly.
  • Fixes the issue that the color of range could not be cloned successfully.
  • Fixes the issue that the application failed to load a correct document if the first document had failed to be loaded.
  • Fixes the issue that Excel prompted a message to update link after removing a sheet which contains NamedRange.
  • Fixes the issue that the application caught an exception in try catch statement, but another exception was thrown after using GC to collect garbage.

Click the link to download Spire.XLS 9.8.5:
More information of Spire.XLS new release or hotfix: