Dialogs - Options

This is the Format tab of PDF2XL's options dialog. Click on any option for an explanation on what it does.




Column format character set

Number

Checking this option will ensure that only the characters in the box will be converted in columns and fields marked as numeric.
This character set will also be used to limit the OCR engine when performing OCR on columns and fields marked as numeric.

Currency

Checking this option will ensure that only the characters in the box will be converted in columns and fields marked as currency.
This character set will also be used to limit the OCR engine when performing OCR on columns and fields marked as currency.

Date

Checking this option will ensure that only the characters in the box will be converted in columns and fields marked as date.
This character set will also be used to limit the OCR engine when performing OCR on columns and fields marked as date.

Time

Checking this option will ensure that only the characters in the box will be converted in columns and fields marked as time.
This character set will also be used to limit the OCR engine when performing OCR on columns and fields marked as time.

Numeric Columns

Move right side negative to left

If this option is checked, PDF2XL will move any negative sign on the right side of numeric fields to the left, so Excel will be able to regard the data as a number.
If the box is cleared, the numeric fields and columns will not be changed.

Replace parenthesis with negative sign

If this option is checked, PDF2XL will replace the parentheses around numeric fields with a minus sign on the left. If left unchecked, numeric fields and columns containing parentheses will remain unchanged.

Minus sign characters

Any character in this character set will automatically be converted to the minus (negative) sign in fields and columns marked as numeric.

Text Columns

Keep indentations

If this option is checked, PDF2XL will retain the relative indentation of all the columns or fields marked as text.
This will affect all the lines of text in case of fields or cells containing more then one line of text, if the Keep Line Wrap option (under Text Columns) is checked.

Keep line wrap

Checking this box will ensure PDF2XL will keep line wrapping for all fields and cells marked as text when converting.
Note that line wrapping will not be kept for CSV or Clipboard conversions, due to the fact the Excel and similar applications will not receive the data correctly in such a case.

Output formatting

Convert superscript

If this option is unchecked, PDF2XL will remove any superscript data from the conversion.
This is mostly useful when there are footnote or annotation marking next to numbers, and you wish to ignore them when converting so Excel won't consider them a part of the number.

Change white text's color

When converting data using the font's attributes - specifically, color - white colored text can disappear if the background color of the resulting document is white; as the default background color of Word and Excel is white, this can cause some issues.
This setting can fix this problem by letting the user select the output color for white and nearly-white colored text; the user can keep the original color by clearing the check box.
Note that this problem only occurs if the user set the Keep Text Attributes option for either Excel or Word and Powerpoint in the Output Settings page of the Settings dialog.