Chart Area Soft Edge is MIssing in PDF & PPTX

Aspose.Cells Product Family
1

Hi Team,

Please find the attached ''DataLabelIssue.xlsx" excel.
If you see the charts are surrounded by border. I have set the soft edge radius with below line of code:

chart.getChartArea().getShapeProperties().setSoftEdgeRadius(2);

After converting the excel to PDF the line has become very thin.
In case of PPTX when we are running in UNIX operating system the line cannot be seen.

Please find the attached excel and pdf generated for your reference and also the code for the conversion.

Note: Cannot provide you the sample for PPTX.

Regards,
Sanjeev

2

Hi Sanjeev,


Thank you for contacting Aspose support.

We have evaluated the presented scenario from Aspose.Cells’ perspective while using the latest release, that is; Aspose.Cells for Java 8.7.1.3, and we are able to notice the said problem in resultant PDF as well as PNG files. In order to further investigate the matter, we have logged tickets separately for each resultant file format.

  • CELLSJAVA-41775: Chart Area Soft Edge is Missing in PDF
  • CELLSJAVA-41776: Chart Area Soft Edge is Missing in PNG

Please spare us little time to thoroughly investigate the matter and get back to you with updates in this regard.
3

Dear Babar Raza,

May I know whether there is any update on these issues?

Regards,
Sanjeev

4

Hi Sanjeev,

Thanks for your posting and using Aspose.Cells.

We are
afraid, there is no update for you regarding these issues (CELLSJAVA-41775, CELLSJAVA-41776) at this moment. However, we have logged your comment
in our database and requested the product team to provide some fix
or ETA for these issues. Once there is some news for you, we will let you
know asap.

5

Hi,

Thanks for using Aspose.Cells.

For your issues logged as

  • CELLSJAVA-41775 - Chart Area Soft Edge is Missing in PDF
  • CELLSJAVA-41776 - Chart Area Soft Edge is Missing in PNG

Aspose.Cells does not support SoftEdge for Chart.

Please set the fill of chart area to none before generating report for making border of cells shown.

Java
…
ChartCollection charts = worksheet.getCharts();
for(int i=0; i < charts.getCount();i++){
Chart chart = charts.get(i);
chart.getChartArea().getArea().setFormatting(FormattingType.NONE);
}

workbook.save(“C:/Sanjeev/DataLabelIssue.pdf”, saveOptions);