Cell chart with secondary axis not scale correctly when converting to pdf

Aspose.Cells Product Family
1

Hi Aspose Team,

Hope someone can help to check here. We are using Aspose cell JAVA version to convert excel to pdf with charts. One tricky chart has secondary axis to fake the points labeling. It works fine on the excel, however when converting into PDF the scale on the x axis doesn’t look correct comparing to the excel.

Can you please help to check if we are doing correctly or this is one known issue?

Thanks

2

Hi,

Thanks for your posting and using Aspose.Cells.

Please download and use the latest version: Aspose.Cells
for Java v8.5.1.2 it works fine and generates correct output pdf from your excel file.

I have tested this issue with the following code and attached the output pdf for your reference.

Java


String filePath = “F:\Shak-Data-RW\Downloads\ChartTest.xlsx”;


Workbook workbook = new Workbook(filePath);

workbook.save(filePath + “.out.pdf”);

3

Thanks for the quick reply. I didn’t get chance to test the new jar yet, but we are currently on v8.5.
And i found the same issue in your output pdf. e.g. The point labelled as 24 it aligns to 8.52 on x, which in excel it shows correctly. However if you look at the pdf generated, it aligns to somewhere around 7. Can you please check again?

Thanks

4

Hi,

Thanks for your clarification and using Aspose.Cells.

We were able to observe the issue mentioned by you in the converted chart inside the output pdf. We highlighted the issue in a screenshot for a reference.

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-41426 - Cell chart with x-axis not scale correctly when converting to pdf

5

Thank you very much for taking a look into the issue, may i ask the ETA to have the issue fix? And do we have a way to track the issue you logged with that id?

Thanks
Min

6

Hi,

Thanks for your posting and using Aspose.Cells.

Please spare us some time, couple of weeks, hopefully your issue will be fixed in this time span. In case the issue is difficult to be resolved, it could take longer.

Once the issue is resolved, we will post in this thread and provide you a fix to this issue. You cannot track this issue except that you can see the status saying (Resolved or Unresolved) at the top left corner of the very first post of your thread.

Whenever you need to find the status of your issue, you can post in this thread or you can provide us the issue id, we will then check the status from database and update you with it.

Let us know if you have any other questions, we will be glad to look into it and help you further.

7

Thanks for the update. Just want to add, i did couple of testings and try to see if any work around, found one thing can somehow help to make the align correct. I just fixed the Major unit in the Axis Options (Fix the Maximum would also help however in my case the chart range is dynamic) to some value like 2 for both Primary and Secondary, it creates too many unit ticks if the chart range goes big but that is the best i can get for now. Hope this would help those have similar issue, also can help you/team to debug/fix issue.

Thanks

8

Hi,


Thank you for sharing your analysis results. Hopefully, this information will help us in identifying the problem cause. We have logged your comments to the ticket already attached to this thread for product team’s review.
9

Hi,

Thanks for using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells
for Java v8.5.1.6 and let us know your feedback.

10

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

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.