Spire.XLS

Spire.XLS 8.10.7 supports setting the comment visibility when printing Excel

It is pleasing to announce that the version Spire.XLS 8.10.7 is released. In this version, two features are added, one is to set the comment visibility when printing Excel, the other is to set the position of ChartTitleArea. Besides, numerous bugs are fixed, such as getting empty oleData when extracting the OLE in excel, failing to copy excel range and causing exceptions when converting Excel to PDF and saving Excel to stream. More details see the information below.

New Features:

  • Add new properties to print comment visible/invisible:
  • sheet.PageSetup.PrintComments = PrintCommentType.InPlace;
    sheet.PageSetup.PrintComments = PrintCommentType.NoComments;
    
  • Add new properties to set the position of ChartTitleArea:
  • chart.ChartTitleArea.X = xx;
    chart.ChartTitleArea.Y = xx;
    

Bug Fixes:

  • Fixes the issue that extracting the OLE in Excel but got empty oleData.
  • Fixes the issue that changing the font of chart title had impacts on other fonts of text.
  • Fixes the issue that caused an exception when loading an Excel file.
  • Fixes the issue that adding the fill color failed.
  • Fixes the issue that copying range didn't succeed.
  • Fixes the issue that caused an exception when converting Excel to PDF.
  • Fixes the issue that caused an exception when saving Excel to stream.
  • Fixes the issue that caused incorrect page number after converting Excel to PDF.

Get the version of Spire.XLS 8.10.7 here: