Is a absolut necessity for use of anydb in Europe
Hi Folkerth thanks for your feedback and reporting the issue.
We are using the computer’s OS locale to set the number/currency formatting. In this case can you please tell us what your computer’s OS region/locale is set to?
We can investigate this and also add explicit support for this formatting.
1 Like
That is the Dutch locale NL-nl.
1 Like
We have fixed this issue already and it should be live in our server.
Please check if it works ok now.
Here’s the result of number and currency with region set to nl-NL
2 Likes
Euro Currency format using locale nl_NL works okay now in Chrome on my macbook.
Also correct in Edge on my Windows 11 Pro laptop.
But currency format using locale nl_NL does not work correctly in Chrome on that windows 11 Pro laptop.
We tried this in a Chrome on Windows 11 Pro desktop (sorry, we don’t have a laptop with Windows 11 pro). The currency seem to work well.
We used latest Chrome version: 139.0.7258.128 (Official Build) (64-bit).
Could you please try it on the latest version of Chrome?
1 Like
I use this newest Chrome 139.0.7258 but still it uses the wrong format to display large amounts
Hello,
Thanks for the reply.
We have a comparable environment with different results.
We will try to see if we can recreate the problem on our side.
Meanwhile, could you please clear the cache and do a reload (assuming the browser is still caching the old code).
To clear cache and reload, use Ctrl + F5.
Please keep us posted.
1 Like
I can check something in Chrome’s dev tools and give you a screenshot of some code/settings if needed.
1 Like
Hello,
From the developer console, can you please try the following snippets
- const formatter = new Intl.NumberFormat();
formatter.format(12345.6); - navigator.language
Here is a sample run for en-US locale:
Your snippet does not work.
But if I adjust it a little bit then it does work in console: I added the locale to the NumberFormat statement and it formats correctly.
Hello,
Thank you for your response.
That error you faced could be the key to the issue.
As per specification, when the locale is not passed to the NumberFormat constructor, it is supposed to detect and use the system locale.
Could you please repeat the command
new Intl.NumberFormat() and see if you get any javascript error?
If that doesnt not produce an error, please try the following command:
new Intl.NumberFormat().resolvedOptions()
Once we have a clue on the error, we will see if we can handle it better.
double checked the settings in Windows 11 pro. All settings are cooect nl_NL and display values in the correct format. This Anydb record shows Euro amount correctly. Chrome just keeps using the US format.
Below the Edge dev tool screenshot
Hello,
Doing some research online, looks like Chrome doesn’t always automatically sync up system locale settings. It is not clear what causes this behavior in Chrome.
While Edge respects the Windows 11 nl-NL locale, Chrome often defaults to en-US unless you explicitly change its language preferences. This is a known behavior and not a problem with your Windows installation.
The fix that I could find is really to set the locale in Chrome as well:
-
Open Google Chrome on your Windows 11 PC.
-
Click the three dots (â‹®) in the top-right corner and select Settings.
-
On the left-hand menu, select Languages.
-
Under “Preferred languages,” click Add languages.
-
Search for and add Dutch (
nl-NL). -
Once added, click the three dots next to the “Dutch” language entry.
-
Select Display Google Chrome in this language.
-
Restart Chrome to apply the changes.
After following these steps and restarting the browser, the new Intl.NumberFormat().resolvedOptions() code should correctly return "nl-NL", and number formatting on websites will follow the Dutch conventions.
Hope this helps.
1 Like
Yes. That works and shows amount in correct format.