Set the background color of legend in a chart starts to support on Spire.XLS 7.8.43

A new hotfix version of Spire.XLS 7.8.43 is available today. In this new version, we add new features to Spire.XLS to set the background color of legend in a chart and add new options for header and footer. We also focus on the performance enhancement of Spire.XLS. View the details as below:

New Features:

Add new feature to set the background color of legend in a chart.

XlsChartFrameFormat x = chart.Legend.FrameFormat as XlsChartFrameFormat;
x.Fill.FillType = ShapeFillType.SolidColor;
x.ForeGroundColor = Color.White;

Add new options for header and footer.

//Specify whether the header and footer should scale as you use the "Shrink To Fit" feature on the document.
sheet.PageSetup.ScaleWithDoc 

//Give a different header and footer only for the first page 
sheet.PageSetup.DifferentFirst 

//Specify that odd-numbered pages should have a different header and footer from even-numbered pages.
sheet.PageSetup.DifferentOddEven

Add new property to set the line weight.

(ChartSerie.DataPoints[0].DataFormat.LineProperties as XlsChartBorder).CustomLineWeight;

Bug solutions:

• Fixes the issue that caused conditional Formatting not working when converts excel to PDF.
• Fixes the issue that caused some documents fails to load.
• Fixes the issue where the content is not converted properly when convert excel to PDF.
• Fixes the issue where the formula's results render incorrectly when converting to PDF.
• Fixes the issue where the image render incorrectly when convert Excel to PDF.

Welcome to experience Spire.XLS 7.8.43 with downloading here:

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