I have looked everywhere I can think of, both here and in the help files, but I cannot find how to change the date format so that for ALL OOO modules it is set to the European standard of dd:mm:yyyy, rather than the American way of putting the month first.
Advice appreciated.
[Solved] Language configuration and date format
[Solved] Language configuration and date format
Last edited by Hagar Delest on Fri Jul 11, 2008 2:04 pm, edited 1 time in total.
Reason: tagged the thread as Solved.
Reason: tagged the thread as Solved.
OOo 2.3.X on Ms Windows XP
- Hagar Delest
- Moderator
- Posts: 33533
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Language configuration and date format
Please read the Survival Guide for the forum. I've split the topic, don't post after a tutorial please.
What's the setting in the Tools>Options>Language Settings>Languages for the Locale setting field?
What's the setting in the Tools>Options>Language Settings>Languages for the Locale setting field?
LibreOffice 25.2 on Linux Mint Debian Edition (LMDE 7 Gigi) and 24.8 portable on Windows 11.
Re: Language configuration and date format
Sorry about the faux-pas!
On the basis that a picture tells a story, here is a screenshot.

On the basis that a picture tells a story, here is a screenshot.

OOo 2.3.X on Ms Windows XP
Re: Language configuration and date format
I've sussed it - tick the box for decimal separator key seems to do it - is that right?
OOo 2.3.X on Ms Windows XP
- Hagar Delest
- Moderator
- Posts: 33533
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Language configuration and date format
Looks fine.
Make sure that the style for the paragraph (in Writer) or for the cells (in Calc) is set to English (UK) and not English (USA). For that, open the Stylist (F11), right click the Default paragraph/cell style, click Modify and go to the Fonts tab.
Make sure that the style for the paragraph (in Writer) or for the cells (in Calc) is set to English (UK) and not English (USA). For that, open the Stylist (F11), right click the Default paragraph/cell style, click Modify and go to the Fonts tab.
LibreOffice 25.2 on Linux Mint Debian Edition (LMDE 7 Gigi) and 24.8 portable on Windows 11.
Re: Language configuration and date format
Thank you very much for your prompt help.
When OOO V3 is out I see it will open M.S.Office 2007 .docx types of file without having to use an odf converter.
This will be a big plus as I have and receive, MS word in both .doc & docx formats. I'm sure Microsoft introduced the new file formats just to make it difficult for OOO users!
When OOO V3 is out I see it will open M.S.Office 2007 .docx types of file without having to use an odf converter.
This will be a big plus as I have and receive, MS word in both .doc & docx formats. I'm sure Microsoft introduced the new file formats just to make it difficult for OOO users!
OOo 2.3.X on Ms Windows XP
- Hagar Delest
- Moderator
- Posts: 33533
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Language configuration and date format
Rather strange but why not.landsker wrote:tick the box for decimal separator key seems to do it - is that right?
You can have a look at the 3.0 beta version, not to be used for production but you can use it as a converter.landsker wrote:When OOO V3 is out I see it will open M.S.Office 2007 .docx types of file without having to use an odf converter.
This will be a big plus as I have and receive, MS word in both .doc & docx formats.
It's part of their strategy plan I guess: make the users believe they can use an 'open' format (which is not) and lock them up with that file format. Note that MS has worked to make OOXML an ISO standard (but appeals in progress) and that they won't use it for MS Office 2007!!landsker wrote:I'm sure Microsoft introduced the new file formats just to make it difficult for OOO users!
Since your issue seems to be fixed, I tag it as solved, post again and remove that tag if there is still a problem.
LibreOffice 25.2 on Linux Mint Debian Edition (LMDE 7 Gigi) and 24.8 portable on Windows 11.
Re: [Solved] Language configuration and date format
Why don't you set your locale setting to Spanish?
Has your question been answered? Then please add [solved] to the title of your thread.
My pet peeve, No support for international ordinal numbering
please vote
Er is nu ook een Nederlandstalig forum!
OOo 3.0.X on Ms Windows XP + Opensuse 11.1
My pet peeve, No support for international ordinal numbering
please vote
Er is nu ook een Nederlandstalig forum!
OOo 3.0.X on Ms Windows XP + Opensuse 11.1