Decimal point

4
I have a project for a Dutch client with end-users in foreign countries. For that reason the default language of the application is set to English. However, the customer wants to see floating numbers in Dutch localised settings (decimal comma and a dot as thousands seperator). Is this at all possible and if so, how? Do I understand correctly that the only way is to use an onchange microflow with a formatFloat function call?
asked
4 answers
4

7 years later still no better solution than highjacking a language?

answered
3

If you are not using the dutch language you could also translate the dutch language to english and then set everyones language to dutch. i am not sure if it will work, but my guess is this will also change the locale and thus your decimal separator.

answered
2

I think the fastest way is to do the following:

  1. Add Dutch as a language to the project.
  2. List item

  3. Empty all Dutch texts:

    a) Go to menu Tools > Language operations b) Select all rows (modules etc). c) Choose 'Delete' as operation d) Choose 'Dutch, Netherlands' as language e) Click 'Apply'.

  4. Update all users to use 'Dutch, Netherlands' as their language.

All texts will be English because if no Dutch text is available, English will be used as fallback. However, the localization of dates and numbers will be Dutch.

Note that if you add new widgets to your project, you will have to empty the Dutch texts again. The Modeler adds English US and Dutch texts by default to something like the New button.

answered
0

There are several ways to do this:

  • You could use calculated attributes to format the currency to your dutch format
  • You can use the group digits property in a grid and dataview to group the digits
  • You can use the Microflow label widget to show your custom format in a dataview: https://appstore.mendix.com/link/app/Microflow%20Label
  • You can use the Format string widget to show your custom format in a dataview

It's possible to add some custom formatting for date and time in your project settings -> languages. This way you can create your custom format for date/time. You could file a request to do this also for custom formatting currencies.

answered