Chart lines disappear when the chart is saved as an image

Aspose.Cells Product Family
1

Hello,

I’m trying to save a line chart as an image, but during the process, the chart lines are getting lost. Is this a bug in Aspose?

Workbook workbook = new Workbook(new FileInputStream("C:\\lines.xlsx"));
Chart chart = workbook.getWorksheets().get(0).getCharts().get(0);
chart.toImage("C:\\lines.png");

Difference:
chart_lines.png (24.3 KB)

Excel:
lines.7z (12.4 KB)

2

@dfinsolutions

It seems you are experiencing an issue where the lines of your chart disappear when saving it as an image. This could be due to several factors, including the chart’s rendering settings or the specific format you are using for the output image.

To troubleshoot this issue, you can try the following steps:

  1. Check Chart Properties: Ensure that the chart’s properties are correctly set before converting it to an image. Sometimes, certain properties may affect how the chart is rendered.

  2. Use Different Image Formats: Instead of saving the chart as a PNG, try saving it in a different format, such as JPEG. This can sometimes yield better results in terms of rendering.

    Here’s an example of how to save the chart as a JPEG:

    Workbook workbook = new Workbook(new FileInputStream("C:\\lines.xlsx"));
Chart chart = workbook.getWorksheets().get(0).getCharts().get(0);
chart.toImage("C:\\lines.jpeg", System.Drawing.Imaging.ImageFormat.Jpeg);

  3. Update Aspose.Cells: Ensure that you are using the latest version of Aspose.Cells, as bugs and rendering issues are often fixed in newer releases.

  4. Check for Known Issues: Review the Aspose.Cells documentation or forums for any known issues related to chart rendering. Sometimes, specific configurations or chart types may have known bugs.

If the problem persists after trying these suggestions, it may be beneficial to reach out to Aspose support with your specific chart file and code snippet for further assistance.

Sources:
[1]: ConvertingColumnChartToImage.cs

3

@dfinsolutions,

After initial testing, I am able to reproduce the issue as you mentioned by converting the chart in the template Excel file to image.

We require thorough evaluation of the issue. We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSJAVA-46277

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

4

Hi @dfinsolutions
We have fixed this issue, the result is as follows, it will be effective in version 25.4.
250329.png (6.0 KB)