When converting some Excels to Pdf (using the .NET or Java version of Aspose Cells) charts are
not centered causing in some cases content not to be included in the PDF.
To reproduce, run the following code:
String filename = @"chart_sheet.xls";
Workbook wb = new Workbook(filename);
PdfSaveOptions opts = new PdfSaveOptions();
wb.Save(filename+".pdf", opts);
Using the following input file:
https://www.dropbox.com/s/x5ukms2fkrasc3o/chart_sheet.xls?dl=0
This is the output I get:
https://www.dropbox.com/s/mvl9u0vm0jxz6hi/chart_sheet.xls.pdf?dl=0
In another case, which I cannot send as the Excel file contains confidential information:
Here’s the Excel View of the PDF:
https://www.dropbox.com/s/qhsaywzgbwu7h7p/000000_Original000246.jpg?dl=0
and here is the PDF with text cutoff I obtain:
https://www.dropbox.com/s/k6jisnyd06oyafb/000000_Original000246.pdf?dl=0
@russ.nichols,
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
CELLSNET-46732 - Inappropriate chart rendered to PDF
Regarding the second issue, I am afraid that without the sample Excel file, it is not possible to provide assistance as we must need to reproduce the issue here for our analysis. You may please replace the confidential data with the dummy data and share the file with us. We will test is and provide feedback accordingly.
@russ.nichols,
We evaluated your issue “CELLSNET-46732” further.
This is not an issue with Aspose.Cells. We found when opening “chart_sheet.xls” into MS Excel 2003, it shows same output as per the output PDF generated by Aspose.Cells APIs. So, we think it works the same way as per MS Excel 2003 for XLS and it should work as Excel 2003 for XLS file format.