Operation Manual
C
OREL
PDF F
USION
U
SER
G
UIDE
ADD-INS FOR MICROSOFT OFFICE INDEX CONTENTS 139
ADD-IN SETTINGS FOR MICROSOFT EXCEL INDEX CONTENTS 139
Use the PDF link appearance panel to configure how links appear in the generated PDF
file.
NOTE: The hyperlink box in the converted file is not always correctly aligned with the hyperlink text. This
occurs because in Excel the row height is dependent on the font style, size and cell padding. In the
Excel Add-in implementation, the hyperlink box calculation is based on various items including the
cell position, the font height and width. This calculation works for some rows and columns, but not
all.
10.4.1.4 Bookmarks tab (Excel PDF)
Select the Create PDF bookmarks to create PDF bookmarks from the Excel document.
Use Destination magnification to choose the zoom value when the PDF file is opened.
A number of Fit page to... options are provided. Select Inherit Zoom option to open
the PDF with the zoom value currently selected in the user’s PDF viewer.
PDF bookmarks are, by default, created using the font and color from the Excel
document.
The Bookmark appearance panel allows you to change the appearance of the generated
bookmarks:
Click Use text color to change the color of the bookmark text, which is blue by default.
Click Color to display a color picker so you can select a new color.
Click Use text formatting to change the text to Italic, Bold or Bold-italic.
10.4.1.5 Cropping tab (Excel PDF)
Select Use Cropping to enable all the other options on this dialog.
Select Crop if current document format is smaller than destination format, which
enables the Centered option, to crop the document to fit the generated page size.
Select Centered to center the generated page before being cropped.
Click Static values to enter specific cropping values. On selection, use the Units menu to
choose your preferred units (point, mm, inch).
The following three options are available:
Set individual values
Individually set the top/bottom/left and right values.
Constrain all values to be the same
Make the top/bottom/left and right values all the same.
Constrain Top and Bottom values to be the same
Make the top and bottom values the same.
NOTE: If the entered cropping values exceed the page size, the values are ignored and no cropping is
performed.
10.4.1.6 Watermark tab (Excel PDF)
Click Watermark Document to enable the following options:
Use the Te x t option to enter the text you want to become your watermark.