Spire.XLS 7.10.79 supports to assign a discontinuous range for a chart

Spire.XLS

A release hotfix of Spire.XLS 7.10.79 is available today. In this new version, Spire.XLS starts to support assign a discontinuous range for a chart, add line shape to chart, and set different header/footer on Odd/Even page, etc. We also improved the performance of conversion feature from Excel to PDF and the issue of where formula in the image disappeared. View the details as below:

New Feature:

Supports to assign a discontinuous range for a chart.

ChartSerie.CategoryLabels = sheet.Range["E8:E9"].AddCombinedRange(sheet.Range["G8:G9"]).AddCombinedRange(sheet.Range["I8:I9"]);
ChartSerie.Values = sheet.Range["F8:F9"].AddCombinedRange(sheet.Range["H8:H9"]).AddCombinedRange(sheet.Range["J8:J9"]);

Supports to add line shape in chart.

Chart.Shapes.AddLine(Point startPoint, Point endPoint, LineShapeType lineShapeType);

Supports to set header/footer on OddEven page.

Worksheet.PageSetup.DifferentOddEven = 1;
Worksheet.PageSetup.OddHeaderString = "&COdd_Header1";
Worksheet.PageSetup.OddFooterString = "&COdd_Footer1";
Worksheet.PageSetup.EvenHeaderString = "&CEven_Header2";
Worksheet.PageSetup.EvenFooterString = "&CEven_Footer2";

Add new method to specify the ExcelVersion to avoid the limitation in Excel when load CSV file.

public void LoadFromFile(string fileName, string separator, int row, int column, ExcelVersion version);

Bug solutions:

Fixes the issue that caused thread unsafe when convert to PDF.
Fixes the issue that caused some added controls (combo box or comment) incorrect when resave.
Resolves the issue that caused the image in the textbox disappear when convert to PDF.
Fixes the issue where formula in the image disappeared.
Fixes the issue that caused the image can't be deleted after it was inserted with ExcelPicture.

Welcome to experience Spire.XLS 7.10.79 with downloading here:

http://www.e-iceblue.com/Download/download-excel-for-net-now.html