Chart area is blank in PDF and PNG output of excel Chart

Aspose.Cells Product Family
1
Hello,

I am using Aspose.Cells v17.5.5 to generate PDF/PNG of chart - "Chart 18" in the attached excel file. In both PDF and PNG outputs, the chart area is not rendered, it is completely blank.

Following code is used to generate the output:

Workbook workbook = new Workbook("test.xlsx");
WorksheetCollection ws = workbook.getWorksheets();
String worksheetName = "Monthly Family Budget";
Chart chart = ws.get(worksheetName).getCharts().get("Chart 18");
chart.toPdf("D:\\aspose response 17.5.5.pdf");
ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
imgOptions.setImageFormat(ImageFormat.getPng());
chart.toImage("aspose response 17.5.5.png", imgOptions);


Can you please analyse this issue.

Thanks,
Neha
2

Hi,


Thanks for your posting and using Aspose.Cells.

We were able to observe these issues and logged them in our database for a fix. Once, the issues are resolved or we have some other update for you, we will let you know asap.

These issues have been logged as

  • CELLSJAVA-42313 - Chart is Blank in the output PDF
  • CELLSJAVA-42314 - Chart is Blank in the output PNG

3

@Neha_Gautam

Thanks for using Aspose APIs.

Please re-attach your files so that we could look into this issue and fix it. Thanks for your help.

Attachment: test.xlsx
Attachment: aspose response 17.5.5.pdf
Attachment: aspose response 17.5.5.png
Attachment: excel generated.pdf
Attachment: comparison.png

4

Hello,

Please find the files attached:
attachments.zip (126.6 KB)

Thanks,
Neha

5

@Neha_Gautam

Thanks for providing us the needed files. We have logged your files in our database for product team reference. We will look into it and fix this issue and update you asap.

6

@Neha_Gautam

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

7

Hello,

Thanks for your response.
Although the output has improved a lot, but the chart still renders incorrectly in both PNG and PDF output.

PFA the files for the rendering issue:
aspose response_17.8.6.pdf (20.1 KB)
aspose response_17.8.6.png (65.5 KB)
comparison.png (59.4 KB)

Can you please look into this.

Thanks,
Neha

8

@Neha_Gautam

Thanks for your feedback and using Aspose APIs.

We were able to observe this issue while rendering the chart. We have logged this issue 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-42395 - Rendering - Chart image is not correct
9

@Neha_Gautam,

Please try our latest version/fix: Aspose.Cells for Java v17.8.7:

Your issue “CELLSJAVA-42395” should be fixed in it.

Let us know your feedback.

10

The issues you have found earlier (filed as CELLSJAVA-42395) have been fixed in Aspose.Cells for Java 17.9.

11

The issues you have found earlier (filed as CELLSJAVA-42313;CELLSJAVA-42314) have been fixed in Aspose.Cells for Java 17.9.