Hi Team,
Please find the attached “DataLabelIssue.xlsx” excel file.
I’m trying to convert that to PDF and PPTX.
After conversion I can see that the data labels of the 3rd charts are missing in both PDF and PPTX.
Cold you please have a look into this issue.
Please find the attached PDF and PPTX files generated from excel.
Also, I’m attaching the sample code for xls to pdf and xls to pptx conversion.
Note: For your info. I’m using the below jars:
aspose-cells-8.7.0
aspose.slides-15.11.0
Regards,
Sanjeev
Hi,
Thanks for providing us sample JAVA programs with template files.
After an initial test, I observed the issue as you mentioned by using your sample programs/codes with your template file. I found that the DataLabels are missing for a chart in the output image/PDF for the Excel file. I noticed the data labels of the 3rd chart (“Chart 5”) are missing in the output image or PDF file format.
e.g Sample code:
1) Excel to PDF
Worksheet worksheet = workbook.getWorksheets().get(0);
PageSetup pageSetup = worksheet.getPageSetup();
PdfSaveOptions saveOptions = new PdfSaveOptions(com.aspose.cells.SaveFormat.PDF);
saveOptions.setAllColumnsInOnePagePerSheet(true);
saveOptions.setOnePagePerSheet(true);
saveOptions.setCreatedTime(DateTime.getNow());
pageSetup.setLeftMargin(0.5);
pageSetup.setRightMargin(0.5);
pageSetup.setTopMargin(0.5);
pageSetup.setBottomMargin(0.5);
saveOptions.setImageResample(220, 100);
//To avoid overlapping of hint text with Title
// worksheet.getCells().get(“A1”).setValue(null);
worksheet.getCells().deleteRow(0);
// worksheet.autoFitRows();
workbook.save(“out1DataLabelIssue1.pdf”, saveOptions);
2) Sheet to Image
Workbook workbook = new Workbook(“DataLabelIssue.xlsx”);
Worksheet worksheet = workbook.getWorksheets().get(0);
worksheet.getPageSetup().setLeftMargin(0.0);
worksheet.getPageSetup().setRightMargin(0.0);
worksheet.getPageSetup().setTopMargin(0.0);
worksheet.getPageSetup().setBottomMargin(0.0);
/***************Create Image START *****************************************************/
ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
imgOptions.setVerticalResolution(150);
imgOptions.setHorizontalResolution(150);
imgOptions.setOnePagePerSheet(true);
imgOptions.setImageFormat(ImageFormat.getPng());
SheetRender sr = new SheetRender(worksheet, imgOptions);
sr.toImage(0, “out1_img1.png”);
I have logged a ticket with an id “CELLSJAVA-41773” for your issue. We will look into it soon.
Once we have an update on it, we will let you know here.
Thank you.
Dear Amjad Sahi,
Could you please let me know whether there is any update on this issue?
Regards,
Sanjeev
Hi,
I have checked your issue’s status (which is logged as “CELLSJAVA-41773”) into our database and I am afraid, it is not resolved yet. However, I have asked the relevant developer from product team to update on it or provide an eta (if possible).
Once we have an update on it, we will let you know here.
We are sorry for any inconvenience caused!
Hi,
We got a response from the product team that we will provide you a fix in the next week.
Please keep in touch.
Thank you.
Hi,
Thanks for your using Aspose.Cells.
Please download and try the latest fix: Aspose.Cells for Java v8.7.2.1 and let us know your feedback.
The issues you have found earlier (filed as CELLSJAVA-41773) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by Aspose Notifier.