Hi,
when we try to render the attached XLS file as a PDF it has a lot of missing lines on the second page.
Please help ASAP.
Thank you,
Mariusz
Hi,
Thanks for the template files.
After an initial test, I observed the issue as you mentioned by converting your template file to PDF file format. I found some missing contents/ data (in the second page of the first worksheet) in the rendered PDF file as you pointed out. I have logged a ticket with an id “CELLSJAVA-41352” for your issue. We will look into it soon.
Once we have any update on it, we will let you know here.
Thank you.
Hi,
We have evaluated your issue further.
Well, there is lot of data in column A (e.g. in the cells range like A46:A88), but the PrintAea set is actually starting from column B (you may confirm it by opening the file into MS Excel manually and check in the Page Setup dialog box, e.g see Page Setup|Sheet tab which has “B1:K90” as printable area specified), so, it does not contain column A at all and you are missing the contents of column A in the rendered PDF file. In this case, we cannot handle it correctly for now. There are two two ways (as workaround) to cope with it (you may do it either manually or in your code).
1) Either change the PrintArea to set it to e.g. “A1:K90"
2) Or remove the printable area or set the print area to “”, so all the contents are considered to be rendered in the output PDF file.
Please see the sample code below for your reference:
e.g
Sample code:
Workbook workbook = new Workbook(“15-40-01-007.xlsx”);
workbook.getWorksheets().get(0).getPageSetup().setPrintArea(”");
workbook.save(“out1.pdf”);
Thank you.