[Solved] Language configuration and date format

Discuss setup / installation issues - Add a spell checker, Language pack?
Post Reply
User avatar
landsker
Posts: 4
Joined: Fri Jul 11, 2008 9:42 am
Location: Costa del Sol, Spain

[Solved] Language configuration and date format

Post by landsker »

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.
Last edited by Hagar Delest on Fri Jul 11, 2008 2:04 pm, edited 1 time in total.
Reason: tagged the thread as Solved.
OOo 2.3.X on Ms Windows XP
User avatar
Hagar Delest
Moderator
Posts: 33533
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Language configuration and date format

Post by Hagar Delest »

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?
LibreOffice 25.2 on Linux Mint Debian Edition (LMDE 7 Gigi) and 24.8 portable on Windows 11.
User avatar
landsker
Posts: 4
Joined: Fri Jul 11, 2008 9:42 am
Location: Costa del Sol, Spain

Re: Language configuration and date format

Post by landsker »

Sorry about the faux-pas!
On the basis that a picture tells a story, here is a screenshot.

Image
OOo 2.3.X on Ms Windows XP
User avatar
landsker
Posts: 4
Joined: Fri Jul 11, 2008 9:42 am
Location: Costa del Sol, Spain

Re: Language configuration and date format

Post by landsker »

:oops: :oops: :oops:

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
User avatar
Hagar Delest
Moderator
Posts: 33533
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Language configuration and date format

Post by Hagar Delest »

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.
LibreOffice 25.2 on Linux Mint Debian Edition (LMDE 7 Gigi) and 24.8 portable on Windows 11.
User avatar
landsker
Posts: 4
Joined: Fri Jul 11, 2008 9:42 am
Location: Costa del Sol, Spain

Re: Language configuration and date format

Post by landsker »

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!
OOo 2.3.X on Ms Windows XP
User avatar
Hagar Delest
Moderator
Posts: 33533
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Language configuration and date format

Post by Hagar Delest »

landsker wrote:tick the box for decimal separator key seems to do it - is that right?
Rather strange but why not.
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.
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:I'm sure Microsoft introduced the new file formats just to make it difficult for OOO users!
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!!

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.
Caracalla
Volunteer
Posts: 474
Joined: Thu Nov 22, 2007 2:35 pm
Location: Netherlands, EU

Re: [Solved] Language configuration and date format

Post by Caracalla »

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
Post Reply