Skip to content

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

@jverelst

Description

@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
Image

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

Image

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

Image

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

Image

(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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions