PNG output of excel chart has discrepancies

Aspose.Cells Product Family
1

Hello,

I am using Aspose.Cells v19.4 to generate PNG of chart - “Chart” in the attached excel file. The PNG output is not the same as the original chart.

Following code is used to generate the output:

Workbook workbook = new Workbook(“Test.xlsb”);
WorksheetCollection ws = workbook.getWorksheets();
String worksheetName = “Sheet”;
Chart chart = ws.get(worksheetName).getCharts().get(“Chart”);
ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
imgOptions.setImageType(ImageType.PNG);
chart.toImage(“aspose response 19.4.png”, imgOptions);

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

Can you please look into this.

Thanks,
Neha

2

@Neha_Gautam,

Thanks for the template file and screenshot.

After an initial test, I am able to observe the issue as you mentioned by highlighting in the comparison screenshot. I used your template file and sample code and found the output image of chart has a few discrepancies. I have logged a ticket with an id “CELLSJAVA-42895” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

3

Hi,

Is there any update on this? We need to provide a fix for this issue to our customer in our upcoming product release next month, so we need a fix for this ASAP. Can you provide any tentative date for when this issue will be resolved?

Thanks,
Neha

4

@Neha_Gautam,

I am afraid, your issue is not sorted out yet. I have logged your concerns against your issue. We will check if we could provide you an update or eta (if it will take more time) for your issue.

We are sorry for any inconvenience caused!

5

@Neha_Gautam,

For the two discrepancies, the marker’s location is fixed now. We need to do more investigation for the text being cut off. We found that when opening the template file “Original.xlsb” with MS Excel 2016, and save it again. Then you may use the sample code to generate the output, it will be ok.

6

The issues you have found earlier (filed as CELLSJAVA-42895) have been fixed in this update.