|
PDF2XL Online Help
Table of Contents Concepts Conversion Format
Conversion Format
PDF2XL supports specifying a format for each field or table column. This setting can be used when converting .
The format of a column or a field can have several effects on the conversion. Firstly, if the Column format character set check box from the Format Settings Page is set, PDF2XL will make sure that only characters from the set specified in the appropriate settings box will be included in the converted data. For example, if the Numeric format setting only includes the 12345 characters, and the data in the document is 1236, the converted data will be only 123.
Secondly, when converting to Excel, the Display format of the cell will be set to the format specified in the Excel Formats section of the Output Settings Page.
All of this does not apply, of course, to the Image format, which will convert the cell or field area as an image (except for CSV files, which does not support image conversions; in that case, the field or cell will be converted with no contents).
The format can be selected from the following sub-menu:
The available formats are:
| Format | Value Type | Excel Display Format | Default character set |
|---|
| Automatic | Textual copy of the data | Default Excel format for the value (cannot be changed) | All (cannot be changed) |
| Text | Textual copy of the data | Displayed the same as in the original document1 | All (cannot be changed) |
| Number | Numeric, if possible | Number Format setting from the Output Settings Page | The digits and decimal, thousands, negative and positive signs appropriate to the locale |
| Currency | Currency, if possible | Currency Format setting from the Output Settings Page | The digits and currency, decimal, thousands, negative and positive signs appropriate to the locale |
| Date | Date Time, if possible | Date Format setting from the Output Settings Page | The digits and the date separator sign appropriate to the locale |
| Time | Date Time, if possible | Time Format setting from the Output Settings Page | The digits, date separator sign, and the AM/PM designators appropriate to the locale |
| Image | Image | Not applicable | None |
1 - Text columns or fields will keep their indentation and/or line wrapping if so set in the Format settings page. When converting into the clipboard or into CSV file, however, line wrapping will not be kept.
The default Display Format settings for Number Format is to display four decimal digits.
The default Display Format settings for Currency Format is to display a $ sign before the number, and only two decimal digits. It will also display negative numbers in red.
The default Display Format settings for Date Format is to display the month/day/year.
The default Display Format settings for Time Format is to display the hour:minute.
The format settings are in the Excel Cell Format; see the Excel Help file for details about the Cell Format.
If a column is not set to Automatic Format, the format name will be displayed in the Conversion Preview Area next to the column's header.
|
