Per-cell currency formatting?

Tags: #<Tag:0x00007f136b44cfe8> #<Tag:0x00007f136b44cea8>

Hi,

Is it possible to apply different currency formats on a per-cell level? In the example below, the desired behaviour would be to apply the appropriate currency symbol to the “Buying amount” column based on the user’s selection of the preceding “Buying currency” column (e.g. USD, GBP, Euro).

https://jsfiddle.net/Blakeyg/0na9s63p/4/

Thanks!
Blake

Hi @blake.gilchrist

Yes, it’s possible on a cell level. Here’s an example: https://jsfiddle.net/handsoncode/f2Lwte95/ I added just Euro currency to show the general idea, but of course you can add more currencies in a similar way. You just have to import and register other formats.

1 Like

Great, thank you Adrian for the swift response.

@blake.gilchrist

I’m glad that helped. I will close this topic now, but if you have any other questions, feel free to open a new one.