1. Check if the Print Area has been enabled for Listbox,callouts /comments. i.e print preview should show Listbox,callouts /comments.
2. Convert the attached excel to pdf.
3. Check if there is any data loss with respect to Listbox,callouts /comments.
Actual Result:
The pdf generated has data loss for Listbox,callouts /comments . if we compare the
output with the output generated by MS Word , it doesn't match .
Many callouts /listbox and comments are missing in Aspose pdf.
I have tested with it to convert your attached template Excel file to PDF and it works fine as per the print preview of the Excel sheet “Requirements”.
Workbook doc = new Workbook(“C:\test\source.xls”);
com.aspose.cells.PdfSaveOptions saveOptions = new com.aspose.cells.PdfSaveOptions();
saveOptions.setImageType(ImageFormat.getPng());
doc.save(“c:\test\output.pdf”, saveOptions);
Now if we comment out the second line - saveOptions.setImageType(ImageFormat.getPng());
then the pdf is fine but with this line callouts comments are missing.
I want to understand why this line is causing the issue? All these days we were using this line of code. We cannot simply remove it as we dont know wat this line does and may create problems for some functionality in future.
Well, I think you need to specify some vector image format type e.g Emf to show the comments/callouts etc. which are missing when you specify Png on the 4th page of the output PDF document, the Png image format type might not support it.
We recommend you to either remove this line “saveOptions.setImageType(ImageFormat.getPng());” (the component will by default specify Emf for image format type in the document with best quality) or specify Emf format type, see the line of code: