Free Support Forum - aspose.com

Arrows missing in PNG output of excel chart

Hello,

I am using Aspose.Cells v18.2.1 to generate PNG of chart - “Chart 1” in the attached excel file. In original chart there are arrows pointing to the bars, which are missing in the PNG output.

Following code is used to generate the output:

Workbook workbook = new Workbook("test.xlsx");
WorksheetCollection ws = workbook.getWorksheets();
String worksheetName = "WP2020";
Chart chart = ws.get(worksheetName).getCharts().get("Chart 1");
ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
imgOptions.setImageFormat(ImageFormat.getPng());
chart.toImage("aspose response 18.2.1.png", imgOptions);

PFA below the source excel and PNG output:
attachments.zip (147.4 KB)

Can you please analyse this issue.

Thanks,
Neha

@Neha_Gautam

Thanks for using Aspose APIs.

We were able to observe this issue as per your screenshot and description. We have logged it in our database for investigation and for a fix. Once, the issue is resolved or we have some other news for you, we will let you know asap.

This issue has been logged as

  • CELLSJAVA-42560 - Arrows are missing in PNG output of Excel Chart

@Neha_Gautam,

This is to inform you that we have fixed your issue (“CELLSJAVA-42560”) now. We will soon provide the fix after performing QA and including other enhancements and fixes.

@Neha_Gautam

Thanks for using Aspose APIs.

Please download and try the following fix and let us know your feedback.

The issues you have found earlier (filed as CELLSJAVA-42560) have been fixed in this update. This message was posted using BugNotificationTool from <a href=“https://#{request.env[“HTTPS_HOST”]}”>Downloads module by Amjad_Sahi

The issues you have found earlier (filed as CELLSJAVA-42560) have been fixed in Aspose.Cells for Java 18.4. Please also see the document for your reference:
https://docs.aspose.com/display/cellsjava/Installation