Chart to image rendering smoothed line contains loops and wrong x-axis on scatter chart in .NET

Aspose.Cells Product Family
1

Hi,


I have a scatter chart with smooth lines defined for some simple data. 2 issues appear when converting this chart to an image with Aspose (using chart.ToImage()).

1) The smooth line connecting data points contains loops
2) The grid markers on the X Axis aren’t the same as in Excel (Aspose shows 5 markers where as excel shows 12)

Please see attached images (chart_aspose.png and chart_excel.png) for reference and the XLSX file for reproduction.
2

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to observe these issues using the latest version: Aspose.Cells
for .NET v8.1.0.1 after converting your chart into images.

We have logged these issues in our database for investigation. We will look into them and fix these issues. Once, these are resolved or we have some other update for you, we will let you know asap.

These issues have been logged as

  • CELLSNET-42738 - Smoothed line on Scatter Chart contains loops
  • CELLSNET-42739 - Scatter Chart image shows wrong X axis grid markers

I have attached the output image generated with the following code for a reference.

C#

string filePath = @“F:\Shak-Data-RW\Downloads\Bug_LineOfBestFit.xlsx”;


Workbook workbook = new Workbook(filePath);

Worksheet worksheet = workbook.Worksheets[“Chart1”];

Chart chart = worksheet.Charts[0];

chart.ToImage(filePath + “.out.png”);
3

The issues you have found earlier (filed as CELLSNET-42738;CELLSNET-42739) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.