Hi,
I have following 3 issues while rendering charts to PDF using PDFSaveOptions.
1. Charts are marginally being cut in the generated PDF. Refer attached file: Chart3-Pie.pdf
2. Chart text being overlapped at the bottom. Space between the bottom text and y-axis line being reduced. Refer attached file: Chart2-Bar.pdf
3. Extra horizontal and vertical lines around the bars of the chart are appearing in the generated PDF. Refer attached files: Chart2-Bar.pdf and LinesSurroundBars.JPG (showing extra lines highlighted in yellow)
On the other hand, when I generate the PDF output of the same charts using MS Excel, none of the above mentioned issues appear.
Following code snippet is being used to generate the PDF of the charts:
Workbook workbook = new Workbook(“C:/temp/ChartTextOverlapping.xls”);
WorksheetCollection ws = workbook.getWorksheets();
Worksheet sheet1 = ws.get(“Charts”);
Chart chart = sheet1.getCharts().get(“Chart 2”);
ChartShape cshape = chart.getChartObject();
System.out.println(chart.getHeightPercent());
System.out.println(chart.getChartArea().getWidth());
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/Chart2-Bar.pdf”, pdfSaveOptions);
Thanks,
Neeraj