To the UDX Community,
I'm playing around with different options for currency rendering with data coming in from Google Sheets and into a Google Docs template.
regardless of formatting in Google Sheet (Accounting or Number), the moment I render as currency (without any options specified) I get:
USD1,234.56
If I use optional formatting options like currency(ol=en;oc=US;op=USD) I get:
$1,234.56
but I actually would prefer the USD in front of the number, but would like a space between the currency code and the decimal number. Like this:
USD 1,234.56
is that possible? Or instead should I just hard code the USD and then use a number renderer with US based '000 separator, decimal point and two digits?
I appreciate your guidance, Cheers,
Henrik