PDF and HTML files can be created in the same way: by going to File – Export and then choosing the desired format. You can customize the page layout as you wish under “File – Page Setup”.
Setting the print area
The print area by default is the range from A1 to the last cell with an entry in the current worksheet. To set a different print area, go to File – Page Setup and open the “Sheet” tab. Here you can set a specific range of cells to print, or enter rows and columns to repeat using the following format to indicate the desired outcome:
|$3:$3||Line 3 will be repeated on each page.|
|$3:$5||Lines 3-5 will be repeated on each page.|
|$B:$B||Column B will be repeated on each page.|
|$B:$D||Columns B-D will be repeated on each page.|
The default setting for page layout is “Landscape” and “Fit to 1 page wide by 1 tall”. You can adjust the page settings in the “Page” tab.
Headers and footers
In the “Header/Footer” tab, you can customize your headers and footers in a number of ways, such as inserting dates, page numbers, or pictures. Simply click on the icons (see image above) to insert the desired element.You can insert the following file types in your headers and footers: gif, jpg, jpeg, and png.
Note 1: For DynaRanges the print area needs to be at least one row (for vertical DRs) or one column (for horizontal DRs) larger than the DynaRange(s).
Note 2: Languages that write from right to left are displayed from left to right. This error is currently not fixable.
Note 3: PDFs can only be created with the correct font if the used font is available ( for Windows in the folder …\Windows\Fonts). Otherwise the PDF file will be created with a similar font, or, as in the case of characters in “Comic Sans MS Italic”, the characters will be created non-italic.
Note 4: To print PDFs of multibyte characters languages (e.g. Japanese), the font “Arial Unicode MS” must be available on the server. For servers on Linux this font is shipped with the Jedox setup.