|
PDF2XL Online Help
Table of Contents User Interface Dialogs Settings Output Settings Page
Output Settings Page
This page is one of the pages in the Settings dialog.
This page allows you to change various output settings for the PDF2XL application.
If this option is checked, PDF2XL will include each table's name in the output (when not using the Convert into multiple sheets option). If this option is cleared, the table name will not be displayed in the output.
If this option is checked, PDF2XL will include each table's column names in the output (if there are column names for the table). If this option is cleared, the column names will not be converted.
Checking this option will result in the output including empty rows, i.e., rows in which all the cells are empty. If this option is cleared, such rows will not be sent to the output.
Checking this option will result in merging the contents of cells where a word is overflowing from one into the other; if converting to a format that supports merging the actual cells (for example, Excel or Word), the cells themselves will also be merged if that option is set.
Leaving this option clear will make PDF2XL split overflowing words between the cells.
Checking this option will result in keeping the text attributes - size, color, italic, bold, and type - of the original data when converting to Excel or OpenDocument Spreadsheet.
Unchecking this option will result in using the default text attributes.
Checking this option will make PDF2XL merge cells in Excel or OpenDocument Spreadsheet if there are merged cells in the table layout.
Checking this option will make sure that Excel and OpenOffice will treat cells that contain numbers with leading zeros as text, even when not marked as text in the Conversion Format.
Note that this does not apply to columns specifically marked as Numeric, but only to columns that have no set format.
If Excel 2007 is installed, and this option is checked, PDF2XL will use the new Excel 2007 file format when saving (and will default to use the .xlsx file extension). If it is cleared, the file will be saved in the old format (.xls).
When PDF2XL converts data into Excel or Excel File (with the Open File after Conversion option checked), the opened Excel instance may not have all the installed Add-ins enabled.
To make sure they are working in that instance, check this box; note that the conversion may be a little slower when this option is set.
Sets the format set in the Excel sheet for cells marked as holding numeric data. This value should be in Excel's Cell Format format.
Sets the format set in the Excel sheet for cells marked as holding currency data. This value should be in Excel's Cell Format format.
Sets the format set in the Excel sheet for cells marked as holding dates. This value should be in Excel's Cell Format format.
Sets the format set in the Excel sheet for cells marked as holding time data. This value should be in Excel's Cell Format format.
Checking this option will result in keeping the text attributes - size, color, italic, bold, and type - of the original data when converting to Word or Powerpoint.
Unchecking this option will result in using Word's default text attributes.
The third part of the page contains viewing format options:
Checking this option will make PDF2XL merge cells in the Word (or Powerpoint) table if there are merged cells in the table layout.
Checking this option will make PDF2XL quote all the fields in the CSV output; leaving it clear will quote only fields the contain the separator character or the quote character.
Checking this option will make PDF2XL quote any empty fields in the CSV output (i.e., putting "" between separators); leaving it clear will result in writing the separators only.
This setting allows you to select the separator used in the conversion into CSV files. The default is Comma, and you can also select Tab from the combo box. If you wish for any other character, select 'Other' from the combo box and type it into the edit box (see, for example, the 'o' as a separator in the image above).
|
