In the Word Properties of my numeric field I have tried the following format with no success
Does anyone have any suggestions on how to force a space in the 1000 separator of a numeric field?
#1 In the BIP property of the field, set the Formatting Type to "Number"; Format to "#,##0.00"
Yes, that's no typo up there. Grouping separator is a comma; decimal separator is a period.
What you have to understand is that the "," and "." are placeholders. They are not values that will be used in formatting. Just like when you use Oracle format mask, the "G" and "D" are placeholders for the grouping and decimal point characters. Placeholder... that is the key concept here.
#2 The grouping and decimal characters are determined by the template's LOCALE. I'm assuming that you want to format the numbers that way because you're working on a French style template.
So to achieve what you want, you can...
Set the template LOCALE to French-Canada. In E1, do this in P95600 for the template record.
In the BIP Word plugin, do this in the plugin UI under Tools/Options/Preview. Select fr-ca as the locale. You have to do this because this is the only way (AFAIK) that the plugin can determine the locale. However, if anyone knows how to override the locale in the template, please share it with us.
Then proceed to set the BIP property of the field as I outlined in #1 above.
If you want the leave the LOCALE as the default setting - en-us English-US - then set the text field to <?xdoxslt:format_number(TheXMLTagOfTheValueToConvert, numberOfDecimalPlaces, overrideLocale)?> for every field that you want to format.
For example: <?xdoxslt:format_number(AmountExtendedPrice_ID31, 2, 'fr-ca')?>
You don't need to worry about setting the BIP property Formatting Type to "Number". The plugin is intelligent enough to realize that the function result is a number and will force the BIP property formatting type to be "Number". Try and change it... You'll see that it will revert to "Number" when you get back to it.