Hi,
Hi Jaspreet,
Thanks for your posting and using Aspose.Cells.
Your issue is not quite clear. Please provide us screenshot comparing the results of the excel and the pdf for our investigation. Please also let us know how you are measuring the aspect ratio of your excel file as well as your pdf file. We will look into your issue and help you asap.
Hi,
Hi,
Thanks for your screenshot and using Aspose.Cells.
We were able to replicate this issue after executing your above code with the latest version: Aspose.Cells
for Java v8.6.0.3 and found aspect ratio does change.
We have logged this issue in our database for investigation. 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-41496 - Aspect ratio is not maintained in PDF output of excel chart
Hello.
At IHS we also have Aspose.cells license and we have encountered this problem too.
Fixing it is important for us, because our users face it in everyday work.
Regards,
Tomek
Hi,
Thanks for using Aspose.Cells.
When converting to pdf, there are scales in width and height. And you can check excel generated pdf, the chart width and height is also scaled. So this issue is not a bug and won’t be fixed.
Hi,
Hi,
Thanks for your feedback and using Aspose.Cells.
We have logged your comment and files in our database against this issue for product team consideration. We will look into it and update you. Once there is some news for you, we will let you know asap.
Hi,
Hi,
Hello,
Hi,
Thanks for your posting and using Aspose.Cells.
You are actually telling the page size 5.01x3.01 and not the chart image size. The chart image size is 5x3. Please take the screenshot of the image and copy it in MS-Paint and then measure the image size and you will find it is 5x3.
Hi,
Thanks for using Aspose.Cells.
For your further clarification, as the chart border width is 1pt, the Aspose generated pdf size is bigger than excel.
In excel, the size( 5 * 3 inches) doesn’t include the border size of chart. So when we set the width of border of chart to big value, the size is still not changed.
Please check the two charts in ChartBorder.xlsx. The size of both charts is same, but actual size of chart is not same. So when generate them to pdf, we will get different size pdf.
In first chart, excel size is 5*3 inch. The boder width is 1 pt. So the pdf will be 5 3 inch + 1 1 pt