Skip to Content
Dette spørgsmål er blevet anmeldt
enterpriselocalizationi18nformattinglanaguageodoo16
4 Besvarelser
477 Visninger
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
Kassér
Avatar
Kunjan Patel
Bedste svar
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
Kassér
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Bedste svar
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
Kassér
Avatar
Zehntech Technologies Inc.
Bedste svar

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
Kassér
Avatar
YEKINI MARCEL
Forfatter Bedste svar

Hello Kunjan Patel,

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

Avatar
Kassér
Relaterede indlæg Besvarelser Visninger Aktivitet
POS UOM different issue Løst
pos enterprise odoo16
Avatar
1
aug. 24
2654
How to move Odoo 16 community to Odoo 17 enterprise
migration enterprise odoo17 odoo16
Avatar
Avatar
Avatar
2
aug. 24
3051
Error when using module "Documents" in a language other than English
error enterprise documents odoo16
Avatar
0
jun. 24
3143
Spread Sheet Total Figure Issue
inventory enterprise valuation spreadsheets odoo16
Avatar
Avatar
1
jun. 24
3347
Create A Pop-Up Windows with Odoo Studio
enterprise odoo Studio OdooStudio odoo16
Avatar
0
jun. 25
2221