Bars mis-aligned after converting xlsx to pdf and pptx

Aspose.Cells Product Family
1

Dear Team,

In my attached excel I’ve bars of the graph aligned horizontally with cells(right side of the graph).

Im converting the xlsx file to pdf and pptx using Aspose.Cells for java v8.8.2.9 and Aspose.Cells for java v16.5.0 jars.

In the generated pdf , the bars which are aligned properly in excel are getting mis-aligned. Bars are moving upward. As a result legend is coming up.

Similarly in generated pptx, in addition to the bars mis-alignment one of the legend entries also missed.

Please find the screenshots of excel, pdf and pptx for your reference.

Also please find attached sample code used to convert xlsx to pdf, xlsx to pptx, xlsx file used, emf generated.

Could you please help us in understanding why this is happening and provide any fix for this.

Regards,
Sanjeev

2

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to observe your first issue i.e.

In the generated pdf, the bars which are aligned properly in excel are getting mis-aligned. Bars are moving upward. As a result legend is coming up.

We have logged this issue as

  • CELLSJAVA-41901 - Bars are moving upward in the output pdf

but we were not able to observe the second issue with emf i.e.

Similarly in generated pptx, in addition to the bars mis-alignment one of the legend entries also missed.

We have tested these issues with the latest version:
Aspose.Cells for Java 8.8.3 and attached the output pdf and emf image for your reference.

Please test your emf image issue where legend entries got missing with latest version and see if it still happens. In case, it still happens, please share the sample code with us.

3

Dear Shakeel Faiz,

Thanks for the response.

FYI my second issue is in PPTX with OLE not in PDF.
As per your suggestion I’ve tested the same with Aspose.Cells for java v8.8.3 and still I’m able to replicate the below 2 issues in PPTX :

  • Bars mis-alignment
  • Legend entry missing (i.e, Series name 2 for graph is missing)

Note: I’m using MS Power Point 2013, Aspose.Cells for java v8.8.3

Please find attached sample java code to convert excel to ppt, excel file, generated emf and pptx files for your reference.

Also please find the screenshot of legend entry missing.

Regards,

Sanjeev

4

Hi Sanjeev,


Thank you for providing the details.

Please note, the legend entry “Series Name 2 for graph” is missing due to the statement mentioned at the bottom of this post. You can confirm this by saving the spreadsheet on disc and review it in Excel, the said legend entry is missed there too. If you wish to render this entry, please comment out the statement and give the scenario another try. Attached to this post are the resultant files generated on my side.

Java

sheet.getCharts().get(0).getLegend().getLegendEntries().get(1).setTextNoFill(true);
5

Dear Babar Raza,

Thanks for the clarification on the legend entry missing in PPTX.

May I know when we can expect a fix for the below logged issue in this regard:

CELLSJAVA-41901 - Bars are moving upward in the output pdf

Will the fix provided for the above issue will resolve the same issue in PPTX with OLE as well…?

Regards,
Sanjeev

6

Hi Sanjeev,


Thank you for writing back.

The ticket CELLSJAVA-41901 was logged to address the problem for PDF rendering, whereas a separate ticket CELLSJAVA-41905 has already been logged to address the problem for EMF rendering. Please note, the EMF image shows the problem of bar misalignment therefore as soon as this problem is fixed in Aspose.Cells APIs, you will be able to get the correct EMF, which you can use as OleObject’s image while inserting the spreadsheet to presentation file.

I am afraid, we haven’t yet received any updates regarding both of the aforementioned tickets as they are currently in analysis phase. As soon as we get any news, we will post here for your kind reference.
7

Hi,


Please try our new version/fix: Aspose.Cells for Java v8.8.3.4 (attached)

We have fixed your issues (CELLSJAVA-41901 and CELLSJAVA-41905) now.

Let us know your feedback.

Thank you.
8

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

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