Missing chart lines in PNG output of excel chart

Aspose.Cells Product Family
1

Hello,

I am using Aspose.Cells v18.8 to generate PNG of chart - “Chart1” in the attached excel file. The chart area is incorrect in the PNG output. The line dividing the chart is missing in the PNG output.

Can you please look into this.

Following code is used to generate the output:

Workbook workbook = new Workbook(“test.xlsx”);
WorksheetCollection ws = workbook.getWorksheets();
String worksheetName = “Charts”;
Chart chart = ws.get(worksheetName).getCharts().get(“Chart1”);
ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
imgOptions.setImageType(ImageType.PNG);
chart.toImage(“aspose_response_18.8.png”, imgOptions);

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

Thanks,
Neha

2

@Neha_Gautam,

I am afraid shared XLSX file does not include a chart or a worksheet named “Charts”. Please upgrade to Aspose.Cells for Java 18.10 and then let us know your feedback. Share the XLSX file you are working with so that we can provide our feedback after analysis.

3

Hii,

I have updated the attachments. Please refer the following attachments:

attachments.zip (356.1 KB)

Thanks,
Neha

4

@Neha_Gautam,

We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSJAVA-42737 - Chart line is missing in XLSX->PNG conversion
5

@Neha_Gautam,

This is to inform you that we have fixed your issue (logged earlier as “CELLSJAVA-42737”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

6

@Neha_Gautam,

Please try our latest version/fix: Aspose.Cells for Java v18.10.3 (attached)

Your issue should be fixed.

Let us know your feedback.
Aspose.Cells for Java_v18.10.3.zip (6.3 MB)

7

The issues you have found earlier (filed as CELLSJAVA-42737) have been fixed in Aspose.Cells for Java 18.11. You can also get the latest Aspose.Cells for Java version from Maven repos. with simple configurations. Please see the document for your reference: Installation|Documentation

This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi

8
9