Currency Renderer Results / Playground

4 views
Skip to first unread message

Henrik Waeltken

unread,
Jun 2, 2023, 2:50:42 PM6/2/23
to Ultradox
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
Reply all
Reply to author
Forward
0 new messages