Use the SINGLE to do 1-on-1 replacements from SFDC Data into the document
Formatting:
Depending on the field type that is defined in the DataSource, the data can be formatted:
- CURRENCY
- NUMBER
- Custom format: Format by international formatting rules. Some examples
- ###,##0.00 => this will make sure there is a 1000-separator and always 1 number in front of the decimal sign and 2 number after the decimal sign
- ###,##0 => this will make sure there is a 1000-separator and always 1 number in front of the decimal sign but no decimals
- A good tutorial can be found here: How to use 0, # and ? number formatting in Excel (youtube.com)
- Spelled Out: Spell out Numbers (youtube.com)
- Roman numeral: these can be placed in both uppercase and lowercase.
- Roman numerals have some constraints:
- negative numbers will be converted into positive numbers
- decimal numbers will be cut off at the decimal sign. So we only allow integer numbers
- the number must be smaller the 4000. So the biggest possible number is 3999
- Roman numerals have some constraints:
- Custom format: Format by international formatting rules. Some examples
- DATE
- DATE TIME
- TIME