Excel to PDF rendering stacked bar chart has series overlapped in Java

Aspose.Cells Product Family
1

Hi,

I’m having an issue with exporting an Excel spreadsheet to PDF. Within the spreadsheet, there is a stacked bar chart with the “Series Overlap” option set to 75%. When exported, it looks like the offset is doubled for each bar in the chart. This results in data being offset too much, and some of the bars being cut off.

The code that I am using with aspose-cells:19.6 is:
Workbook workbook = new Workbook(“workbook.xlsx”);
//Save the document in PDF format
workbook.save(“AsposeConvert.pdf”, SaveFormat.PDF);

I have attached the XLSX file and the resulting PDF. Thanks for the help!

stacked-bar-chart-overlap.pdf (35.5 KB)
stacked-bar-chart-overlap.xlsx.zip (11.2 KB)

2

@bryanplant,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSJAVA-42946 - Wrong rendering of Stacked bar chart with series to PDF
3

@bryanplant,

Please try our latest version / fix. Aspose.Cells for Java v19.6.2 (attached)

It should solve your issue “CELLSJAVA-42946”.

Let us know your feedback.
Aspose_Cells_Java_v19.6.2.zip (6.5 MB)

4

@Amjad_Sahi,

That looks to have fixed the issue. Thank you!

5

@bryanplant,

Good to know that your issue is sorted out by the new fix/version. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

6

The issues you have found earlier (filed as CELLSJAVA-42946) have been fixed in Aspose.Cells for Java 19.7. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi