Se rendre au contenu
Cette question a été signalée
enterpriselocalizationi18nformattinglanaguageodoo16
4 Réponses
406 Vues
Avatar
YEKINI MARCEL

In Odoo 16 Enterprise, for language Portuguese (pt_PT), we set the Thousands Separator to "." in Settings → Languages, but number formatting is not affected (e.g. 1000000 is not shown as 1.000.000).

 We have already verified that the language is active and assigned to the user.

Any idea why this is ignored?

Avatar
Ignorer
Avatar
Kunjan Patel
Meilleure réponse
Hello IEKINI MARCEL MENDES FERNNANDES,
I hope you are doing well

Fix: Settings → Languages → Portuguese (pt_PT):
- Decimal Separator = ,
- Thousands Separator = .
- Separator Format = [3,0] ← the missing piece

Then refresh/relogin (formatting is ormcached, cleared on write). [3,0] → 1.000.000.

I hope this information helps you

Thanks & Regards,
Kunjan Patel
Avatar
Ignorer
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Meilleure réponse
Hi,

In Odoo 16, the Thousands Separator configured on the language record is not always used by the web client. Number formatting is often determined by the locale definitions (Babel/CLDR) associated with the user's language (pt_PT).

Make sure:

    Ensure the user's language is set to Portuguese (Portugal) - pt_PT and not another Portuguese variant such as pt_BR.
    Log out and log back in after changing the language settings, and clear the browser cache.
    Check whether the issue occurs everywhere or only in specific views/reports. Some reports and custom widgets may format numbers independently.
    Verify that no custom modules or JavaScript customizations are overriding number formatting.


If the issue persists, it is likely that Odoo is using the locale's predefined formatting rather than the manually configured separator values, which may require customization to change.


Hope it helps

Avatar
Ignorer
Avatar
Zehntech Technologies Inc.
Meilleure réponse

Hello, 

In Odoo 16, the thousands separator defined in the language settings is generally used for number formatting, but some views and widgets may rely on localization rules or client-side formatting that do not immediately reflect changes made in the language configuration.

A few things worth checking:

  • Clear browser cache and reload assets after modifying the language settings.
  • Verify whether the issue occurs in all modules/views or only in specific fields.
  • Confirm that the user is actually using the pt_PT language and not another Portuguese variant.
  • Check whether any localization or custom modules are overriding the default formatting behavior.

If the issue persists in standard Odoo without customizations, it may be related to the localization implementation for pt_PT in Odoo 16 and could require further investigation.

Hope this works for you! If you need any help implementing this or want a more optimized approach, feel free to reach out for further discussion.

Regards,

Zehntech Technologies Inc.

santosh.sekwadia@zehntech.com

Avatar
Ignorer
Avatar
YEKINI MARCEL
Auteur Meilleure réponse

Hello Kunjan Patel,

Thank you. Your solution worked perfectly. Setting Separator Format = [3,0] fixed the issue.

Avatar
Ignorer
Publications associées Réponses Vues Activité
POS UOM different issue Résolu
pos enterprise odoo16
Avatar
1
août 24
2598
How to move Odoo 16 community to Odoo 17 enterprise
migration enterprise odoo17 odoo16
Avatar
Avatar
Avatar
2
août 24
3009
Error when using module "Documents" in a language other than English
error enterprise documents odoo16
Avatar
0
juin 24
3088
Spread Sheet Total Figure Issue
inventory enterprise valuation spreadsheets odoo16
Avatar
Avatar
1
juin 24
3251
Create A Pop-Up Windows with Odoo Studio
enterprise odoo Studio OdooStudio odoo16
Avatar
0
juin 25
2174