Working with Microsoft Excel

Sometimes Microsoft Excel may have paging problem that causes CenoPDF fields mis-align on the PDF pages. The following is an example of this situation.

Excel file:

The PDF file generated from above Excel file. Notice the mis-alignment caused by wrong page break location.

To workaround above problem, you should select the cell row that you want to put in next page and choose the command Insert > Page Break :

This is the screenshot after you added the page break:

Export to PDF again. The problem should have been fixed. The following screenshot shows correct page break and field locations: