Date format in Spreadsheets

Question

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

Desk Enterprise · Answer

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:*

*Format dates as text in your spreadsheet* (using formulas) to display DD/MM/YYYY manually.

Export data and use external tools (Excel, Google Sheets) where you can set date format.

Keep an eye on Odoo updates—this is a known limitation and may be improved in future releases.

相關帖文	回覆	瀏覽次數
Where can we learn about spreadsheet formula’s (v16)? 已解決 spreadsheets odoo16features	4 4月 25	7639
bug saving on spreadsheet document 已解決 documents spreadsheets odoo16features	9 4月 25	3838
How to add @api.onchange in _get_view() method odoo 16 odoo16features	1 5月 25	2225
get all partners which are internal users or portal users odoo16 odoo16features	1 4月 25	3274
How to add decoration color green with bold to a record with a single conditon odoo16features	1 4月 25	4089

此問題已被標幟

How to fix or work around:

喜歡這則討論？不要只閱讀，加入發表意見吧！