Server Locale overriding coded Currency Format
Hi. We're having a problem here. Let me describe what's going on:
We have a XML file that has an amount we need to print as currency. XML file is like this:
<Amount>123456.78</Amount>
or
<Amount>123456</Amount>
We need to show that amount as currency, on format MXP (Mexican peso, format mask is the same as USD)
example: $123,456.78 or $123,456.00
server locale is set to EUR (probably Spanish, Spain), so amounts are printed like this
$123.456,78 or $123.456,00
We have already tried:
format-number(Amount,'###,###.##')
format-currency:Amount,'MXP','true'
on MS Word, Field properties for Number $###,##0.00
format currency on local PC works when the currency code is MXN (obsolete) or USD, but does not work on MXP. However, on the server, any of these will work, but format mask will be EUR.
0