Vertical rule extends past X axis in Chart's PDF

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 vertical rule extends past the X-axis. Although the vertical rule extends past the X-axis in actual chart too but not as much as in the PDF output.

Following code is used to generate the output:

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

Can you please analyse this issue.

Thanks,
Neha

Hi,


Thanks for the template files and screen shot.

After an initial test, I observed the issue as you mentioned. I found that Vertical rule extends past X-axis in the chart’s PDF. 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-41627” for your issue. We will look into it soon.

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

Thank you.

Hi Neha,

We have analyzed the problem logged earlier as CELLSJAVA-41627. 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.

Hello,


Is there any update on this issue?


Thanks,
Neha

Hi Neha,


I am afraid, we haven’t yet received further updates regarding the ticket CELLSJAVA-41627. However, we have posted your concerns on the aforementioned ticket and have requested the concerned member of the product team to share more details and preferably an estimated release schedule for the fix. As soon as we get any news, we will post here for your kind reference.

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

Hi,


I am afraid, your issue “CELLSJAVA-41627” is not resolved yet. I have asked the concerned developer from the product team to update on it or provide an ETA (if possible).

Once we receive an update on it, we will let you know here immediately.

Thank you.

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 for your understanding!

@Neha_Gautam

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.