Excel chart to image transformation gives an incorrect chart

Aspose.Cells Product Family
21

Hi,

Here is a screenshot showing the comparison of image outputs between v8.5 & v8.5.1.2
I feel the arrows were more like as in actual Excel in v8.5

Thanks,
Jaspreet Kaur
22

Hi,

Thanks for your sample images and using Aspose.Cells.

We were able to notice the issue highlighted by you in your images. We have therefore logged this issue in our database for investigation and improvement. We will look into it and fix this issue. Once the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSJAVA-41432 - The best image output of arrows was in version 8.5 of Aspose cells

I have also attached the output pdfs generated with the newer and older versions using the following code for a reference.

Javas


String filePath = “F:\Shak-Data-RW\Downloads\bad_looking_chart±+Copy.xlsx”;


Workbook workbook = new Workbook(filePath);


PdfSaveOptions opts = new PdfSaveOptions();

opts.setOnePagePerSheet(true);


workbook.save(filePath + CellsHelper.getVersion() + “.out.pdf”, opts);


23

Hi,

Thanks for using Aspose.Cells.

For your issue logged as (CELLSJAVA-41432 - The best image output of arrows was in version 8.5 of Aspose cells)

In the two versions, we don’t change the arrows. We only adjust the position of data labels of pie.

We are afraid the position of the labels and the arrow can not be put very well as excel. We suggest you to replace arrow with leader lines and set the fill of the upper text to no fill then you will get a better pdf. Please refer to the attached file.

24

Hi,


I logged up couple of issues in this same ticket that has made, the tracking of issues difficult for me.
So, I would request you to close this ticket as I will post separate new tickets for the issues as per their status.

Thanks,
Jaspreet
25

Hi Jaspreet,

Thanks for your posting and considering Aspose.

This is a good decision. It is always better to keep one issue in one thread because it is helpful for product team and other Aspose Staff members to report or investigate the issue. Also the issue is fixed sooner than the multiple issues in a single thread. Please feel free to create threads as per your needs. We will look into them and help you asap. Thanks for your cooperation.