SaveToPdf - custom combo charts missing

[cal004b2]

Hello,

Spire.XLS isn't properly handling some charts when saving a worksheet to PDF.

The attached .NET Framework 4.8 project contains a sample Excel workbook with three charts: a line chart, a scatter chart, and a custom combo chart that combines one line series and one scatter series.

Running the project will display a form with two buttons. The first button saves the worksheet to PDF using Spire.XLS and the second button saves the worksheet to PDF using Excel interop.

The interop PDF correctly displays all three charts, while the Spire.XLS PDF only displays the line chart and the scatter chart. It appears Spire.XLS is not including custom combo charts.

Another minor issue is that the Spire.XLS PDF does not show the labels of the line chart's horizontal axis diagonally; instead they are vertical.

Thank you in advance for any help you can provide.

[Nina.Tang]

Hi,

Thanks for your feedback.
I have reproduced the two issues you methioned and logged them into our bug tracking system with the issue ID: SPIREXLS-5716. Our dev team will investigate and fix them, once they are resolved or there is any update, I will notify you immediately. Apologize for the inconvenience caused.

I noticed that you are currently using our free version. It should be noted that we do not regularly update the free version. Currently, all bug fixes and new feature development are mainly focused on the commercial version. After the problem is solved, I will provide you with an update package for the commercial version.

Sincerely,
Nina
E-iceblue support team

[Nina.Tang]

Hi,

Glad to inform you that the reported bug SPIREXLS-5716 has been resolved and the new version (Spire.XLS Pack(Hotfix) Version:15.4.0) is available. Please download it from the following link.
Websit download link: https://www.e-iceblue.com/Download/download-excel-for-net-now.html
Nuget download link：https://www.nuget.org/packages/Spire.XLS/15.4.0
https://www.nuget.org/packages/Spire.XLSfor.NETStandard/15.4.0

It should be noted that when analyzing your Excel document, we found that the axis text rotation angle of the charts in your document does not comply with the specifications. We need to add the following code to reset it.

Code: Select all

 Worksheet sheet = wb.Worksheets[0];
 sheet.Charts[0].PrimaryCategoryAxis.TextRotationAngle = -45;
 sheet.Charts[1].PrimaryCategoryAxis.TextRotationAngle = -45;

Sincerely,
Nina
E-iceblue support team

[cal004b2]

Thank you Nina!