Position of vertical axis is incorrect in Chart's PDF

Aspose.Cells Product Family
1
Hello,

I am using Aspose.Cells v8.6.2.1 to generate PDF of chart - Chart 1 in the attached excel file. In the PDF output, the position of the vertical axis is to the left of Q2 label. In actual chart its very slightly towards the right of Q2 label.

Following code is used to generate the output:

void chartToPDF() throws Exception {
Workbook workbook = new Workbook("test.xlsx");
WorksheetCollection ws = workbook.getWorksheets();
String worksheetName = "Sheet1";
Chart chart = ws.get(worksheetName).getCharts().get("Chart 1");
chart.toPdf("D:\\test.pdf");
}

Can you please analyse this issue.

Thanks,
Neha
2

Hi,


Thanks for the template files.

After an initial test, I observed the issue as you mentioned. I found that position of vertical axis is incorrect in output PDF for the Area chart. I used the sample code and template file provided by you to reproduce the issue as you mentioned via the screen shot. I have logged a ticket with an id “CELLSJAVA-41625” for your issue. We will look into it soon.

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

Thank you.

3

Hi Neha,

We have analyzed the problem logged earlier as CELLSJAVA-41625. Unfortunately, the mentioned problem is too complex to be fixed in short period of time, however, we will keep the ticket open and provide you further updates during the month of February 2016. Thank you for your patience with us.

4

Hello,


Is there any update on this issue?

Thanks,
Neha
5

Hi Neha,


I am afraid, we haven’t yet received any updates regarding the issue logged earlier as CELLSJAVA-41625. However, we have requested the concerned member of the product team to share an ETA for it. As soon as we get any updates in this regard, we will share here for your kind reference.
6
Hello,

Can you please provide an update on this issue and could you provide an estimated time for the fix?

Thanks,
Neha
7

Hi,

Thanks for your posting and using Aspose.Cells.

We are
afraid, there is no update for you regarding this issue at this moment.
However, we have logged your comment in our database against this issue
and again requested the product team to provide some fix or ETA for this
issue. Once there is some news for you, we will let you know asap.

8

Hello,

Is there any update on this issue?

Our customers are waiting for this given issue to be resolved as soon as possible. Kindly provide the fix for this issue and also let us know the ETA of the fix so that we can update our customer accordingly.

Thanks,

Neha

9

Hi Neha,


I am afraid, the product team hasn’t shared any updates regarding the ticket attached to this thread. I have logged your comments to the aforementioned ticket and have requested the concerned member of the product team to share the ETA at earliest possible. As soon as we get any news in this regard, we will post here for your kind reference.

Thank you for your patience with us.
10

Hi,


We have received a response from the product team on your issue(s).
I am afraid, now we can’t fix your issue. As the width of plot area that Aspose figures out is not the same as MS Excel, so the rule line is not in proper position. The process that calculates the width of Plot area is too complex to be sorted out. We need to consider the label of Y axis, label of X axis, legend and other objects, etc. Now we cannot do the same as per MS Excel. Please refer to the attachment for more details. We notice that the rule is itself a shape line which is not is a part of the chart. We suggest it is best that you should add rule-line as the series of chart like the chart in the thread(<a href="https://forum.aspose.com/t/26158). Hopefully, we will fix the issue (CELLSJAVA-41981) in the new version i.e., v9.0.x.

Thanks.
11

Please try our latest version Aspose.Cells 21.6.0.

If you find any issue, please provide the source Excel file to help us analyze it.