Hello,
Our application is in the Dutch language but we need to use a period (.) as decimal separator because numbers are often entered by our users with the numeric keypad of the keyboard. Because we use American keyboard layout in The Netherlands, the decimal separator of the numeric keypad is a period (.)
We can change nls_numeric_characters so the database will only accept a period but the IG (and numberFieldItem interface) uses the locale decimal separator for NL which is a comma (,)
This means the IG will remove all the decimal separators from numbers. For example 100.5 changes to 1005 when saved.
And decimal numbers from the database will also not display correctly. For example 10.5 in database will be displayed as 105 in IG.
I have tried changing the locale decimal separator to (.) with apex.locale.init() and now the numbers like 10.5 are displayed correctly in the IG but when saved the IG still removes the (.) decimal separator and this makes it impossible to enter number values with the number keypad.
This has been very frustrating to say the least..
I would really like to avoid changing all number columns of our IG's and Number Page items to Text and have to validate and format every number with custom code.
Is there a way to make Apex 21.2 work correctly with a decimal dot separator for Dutch application language?