Hello,
We are using Aspose Cells API 8.2.x.x. to generate PDF of the charts. For that, we are copying the desired chart to a new sheet and using PDFSaveOptions to generate the PDF of that sheet (by hiding other sheets of the workbook).
I have figured out certain cases wherein charts are not being rendered properly in PDF files.
For your reference I have attached the 2 such excel files containing charts, along with their PDF outputs generated using Aspose API and MS Excel, which are not rendered properly.
In file InvalidPdf.xls - Chart 50, Chart 51 and Chart 52 have following common problems when compared with the PDF of same charts generated using MS Excel:
- Horizontal lines are missing in the Aspose generated PDF
- Thickness of bar lines is decreased in the Apose generated PDF
- Spacing, between the vertical labels to the axis line, is marginally more when compared with MS Excel generated PDF
In file InvalidPdf2.xls - Chart 2 and Chart 8 have following common problem when compared with the PDF of same charts generated using MS Excel:
- Dotted line is missing both in chart and in labels
Following is the code snippet being used to generate PDF files:
Workbook workbook = new Workbook("C:/temp/InvalidPdf2.xlsx");
WorksheetCollection ws = workbook.getWorksheets();
Worksheet sheet1 = ws.get("Charts2");
Chart chart = sheet1.getCharts().get("Chart 8");
ChartShape cshape = chart.getChartObject();
int sheetIndex = ws.add();
Worksheet worksheet = ws.get(sheetIndex);
//Setting the name of the newly added worksheet
String transientSheetName = "TransientWorksheet";
worksheet.setName(transientSheetName);
//Copy the Chart to Second Worksheet
worksheet.getShapes().addCopy(cshape, 0, 0, 0, 0);
//Get the new chart and set its height and width accordingly
Chart chart1 = worksheet.getCharts().get(0);
chart1.getChartObject().setHeight(cshape.getHeight());
chart1.getChartObject().setWidth(cshape.getWidth());
//Making remaining sheets invisible as the output is required for only TransientWorksheet
for (int i = 0; i < ws.getCount(); i++) {
String sheetName = ws.get(i).getName();
if(!transientSheetName.equalsIgnoreCase(sheetName)){
ws.get(i).setVisible(false);
}
}
PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();
pdfSaveOptions.setOnePagePerSheet(true);
worksheet.getPageSetup().setTopMargin(0);
worksheet.getPageSetup().setBottomMargin(0);
worksheet.getPageSetup().setRightMargin(0);
worksheet.getPageSetup().setLeftMargin(0);
workbook.save("c:/temp/Chart 8-Aspose.pdf", pdfSaveOptions);
Thanks,
Neeraj