*Datatable 4.3.6* - Currency fields - Incorrect formatting in other locales than English

[jverelst]

Steps to reproduce

We have a managed package (GoMeddo subscription management) which uses currency fields of length 16.

When querying this data with SOQL, you see that sometimes, all of these decimal places are used:

select Id, Subscription25__Price__c, Subscription25__Start_Date__c,Subscription25__Termination_Date__c,Subscription25__Quantity__c from Subscription25__Contract_Product__c where Account_Id__c = '001xxxxx

When I set my locale to English (United States), this record renders correctly:

However, when I set my locale to Dutch (Netherlands), the datatable now renders as follows:

The strange thig is, when I configure the component in flow editor, it does render correctly with my locale is set to **Dutch (Netherlands) **:

(as you can see in the screenshot, I also tried using special type attributes for column 4, with no effect).

I saw issue #1156 which seems to resemble this, however I am unable to change the type of settings of this field due to the fact that is from a managed package. My guess is that the definition of what is the decimal seperator (either a dot or a comma) is messing up the rendering somehow.

[ericrsmith35]

The best workaround may be to create some Text formula fields that can be used to display this the way you want it to.