I am using Aspose cells java version 8.5.2.
Following 2 issues are encountered while generating PDF from the chart:
1. Axis labels are not shown at all in the PDF.
2. Lot of small vertical lines appearing under the plot area.
However, the PDF generated directly from the MS Excel is flawless.
For your reference, the source excel file along with Aspose and MS Excel generated pdf files are attached herewith.
Following is the code snippet being used to generate PDF files:
Workbook workbook = new Workbook(“C:/temp/ChartIssue.xlsx”);
WorksheetCollection ws = workbook.getWorksheets();
Worksheet sheet1 = ws.get(“Workings”);
Chart chart = sheet1.getCharts().get(“Axis and Scale test”);
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/AsposeGenerated.pdf”, pdfSaveOptions);
Thanks,
Neeraj