Passa al contenuto
È necessario essere registrati per interagire con la community.
Tutti gli articoli Persone Badge
Etichette (Mostra tutto)
odoo accounting v14 pos v15
Sul forum
La domanda è stata contrassegnata
spreadsheetsodoo16features
1 Rispondi
1858 Visualizzazioni
Avatar
whugh@caradon.co.uk

Good afternoon everyone,


I am using 16.0 on Odoo.sh


The date format in Odoo spreadsheets does not match my language. It is set as MM/DD/YY and I don't seem to be able to change this.


I have my language set as English UK, and the date format is %d/%m/%Y. No other languages are activated. In all other areas, dates display correctly in the DD/MM/YY format, except for spreadsheets.


How can I correct this?


Kind regards,

Will

Avatar
Abbandona
Maciej

I have the same issue and my developers say it just works like that, which is quite annoying. Especially considering that Odoo is a Belgian company and uses a European date notation. Is anyone from Odoo here that could shed some light on that? I'll probably make a ticket in Odoo support, I don't expect it would do anything but it doesn't hurt to try.

Avatar
Desk Enterprise
Risposta migliore
How to fix or work around:
  • No built-in way yet to change date format inside Odoo spreadsheets.
  • Dates in spreadsheets use a fixed format for now, ignoring locale.

Workarounds:

  1. Format dates as text in your spreadsheet (using formulas) to display DD/MM/YYYY manually.
  2. Export data and use external tools (Excel, Google Sheets) where you can set date format.
  3. Keep an eye on Odoo updates—this is a known limitation and may be improved in future releases.

Avatar
Abbandona
Post correlati Risposte Visualizzazioni Attività
Where can we learn about spreadsheet formula’s (v16)? Risolto
spreadsheets odoo16features
Avatar
Avatar
Avatar
Avatar
Avatar
4
apr 25
7847
bug saving on spreadsheet document Risolto
documents spreadsheets odoo16features
Avatar
Avatar
Avatar
Avatar
Avatar
9
apr 25
3996
How to Add wizard under print button inside the form view.
odoo16features
Avatar
Avatar
Avatar
Avatar
3
ago 25
2338
How to add @api.onchange in _get_view() method odoo 16
odoo16features
Avatar
Avatar
1
mag 25
2555
get all partners which are internal users or portal users odoo16
odoo16features
Avatar
Avatar
1
apr 25
3517