This property tab provides number formatting settings for all fields and variables of the document.
The list on the left is set to display either the Fields or the Variables of the document.
The Field Options group is only used for Fields:
The Default from Input button sets the formatting to that of the input.
Check the Survive Reload option if the formatting is to apply to the document permanently.
The following controls for formatting values are available:
| Property | Description |
|---|---|
| Mixed | Both numbers and text. Numbers shown in original format. |
| Number | Shows numeric values with the number of digits set in the Precision spinner box. |
| Integer | Shows numeric values as integers. |
| Fixed to | Shows numeric values as decimal values with the number of decimal digits set in the Decimals spinner box. |
| Money | Shows numeric values in the format shown in the Preview text box. The default format is the Windows Currency setting. |
| Date | Shows values that can be interpreted as dates in the format set in the Format Pattern edit box. An example of this format is shown in the Preview text box. |
| Time | Shows values that can be interpreted as time in the format set in the Format Pattern edit box. An example of this format is shown in the Preview text box. |
| Timestamp | Shows values that can be interpreted as date + time in the format set in the Format Pattern edit box. An example of this format is shown in the Preview text box. |
| Interval | Shows time as sequential time increment (e.g. format = mm shows the value as the number of minutes since calendar start ( 1899:12:30:24:00). |
The Show in Percent (%) button operates on the following formats: Number, Integer and Fixed to.
Decimal and Thousand separators can be set in the edit boxes of the Separators group.
The ISO button uses the ISO standard to format date, time and timestamp values.
The System button uses the system settings for the formatting.
