Hello Aspose Team,
We are facing a issue in the export of the attached template. The template itself is fine as there are 3 extra lines between the end of the data and the bottom of page. However, the equivalent of 6 lines is being added when exported and the Template bleeds to second page by 3 lines . Please look at into this issue.
Sample Code:
FileInputStream io = new FileInputStream(new File("/home/asthapa/Pa-front/project/exportCheck/ReportTemplates/coverageCode.xlsx"));
Workbook workbook = new Workbook(io);
workbook.calculateFormula();
for (int m = 0; m < workbook.getWorksheets().getCount(); m++) {
workbook.getWorksheets().get(m).getShapes().updateSelectedValue();
}
//Removes excess blank page. Can be replicated without the following loop code.
for (int j = 0; j < workbook.getWorksheets().getCount(); j++) {
if (shouldExclude(workbook.getWorksheets().get(j).getName())) {
workbook.getWorksheets().get(j).setVisible(false);
} else {
removeBlankRowsAndColumns(workbook.getWorksheets().get(j));
}
}
workbook.save("output.pdf");
sampleTemplate.zip (37.5 KB)
Thanks,
Astha