Spire.XLS

Spire.XLS 9.8.11 supports adding arrow lines to worksheets

We're glad to announce the release of Spire.XLS 9.8.11. This vresion suppots adding arrow lines to worksheets, supports adding a copy of an existing shape, and fixes some issues that occurred when processing and converting Excel documents. More details are given below.

New Features:

  • Supports to add arrow lines.
  • var arrowline = workbook.Worksheets[0].TypedLines.AddLine();
    line.Top = 50; 
    line.Left = 30; 
    line.Width = 300;
    line.Height = 500;
    line.BeginArrowHeadStyle = ShapeArrowStyleType.LineArrowDiamond;
    line.EndArrowHeadStyle = ShapeArrowStyleType.LineArrow;
    
  • Supports to add a copy of an existing shape which is a line, a checkbox, a textbox, a radio button, or a combo box.
  • //create a shape 
    var line = wb.Worksheets[0].TypedLines.AddLine();
    line.Top =50;
    line.Left=30;
    line.Width =300;
    line.Height = 500;
    //add a copy
    wb2.Worksheets[0].TypedLines.AddCopy(line);
    

Bug Fixes:

  • Fixes the issue that the page break was wrong after converting Excel to PDF.
  • Fixes the issue that the data displayed wrongly after saving Chart to image.
  • Fixes the issue that loading a file failed.
  • Fixes the issue that the application threw the exception StackOverflowException when saving Excel to PDF.
  • Fixes the issue that caused corrupt Excel when using Conditional Formatting.
  • Fixes the issue that the result file hinted an error when opening after deleting a row that contains formula.
  • Fixes the issue that setting fill horizontally for text didn't work.
  • Fixes the issue that the application threw the exception FormatException when loading a file.

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