Date formats

Discuss the spreadsheet application

Date formats

Postby desdichato » Wed Oct 04, 2017 12:42 pm

Am experiencing an annoying :alarm: thing on a spreadsheet I'm doing some work on, every time I put a date in a column it is coming out wrong as an example I did some work earlier today Wednesday October 3rd 2017 but I noticed that despite putting the correct date in the column it is coming up as Friday 10th March 2017, I have checked all my settings that I can find and they show October 3rd 2017, this is a new computer to me with win 10 :crazy:

Any thoughts?

OOo 4.1.3 on 8.1
Posts: 71
Joined: Wed Jul 22, 2009 10:44 am

Re: date formats

Postby RoryOF » Wed Oct 04, 2017 12:49 pm

To what Locale is your OpenOffice set? You probably should use en-GB or some other European locale that reads DD/MM/YY; Today's date being read as 10 Mar 2017 suggests it is set to US locale.
Apache OpenOffice 4.1.5 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
Posts: 26935
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: date formats

Postby robleyd » Wed Oct 04, 2017 12:57 pm

More specifically, check the various settings in Tools | Options | Language Settings | Languages.
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.1.5 - Slackware 14.2 - 64 bit
User avatar
Posts: 1848
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: date formats

Postby Villeroy » Wed Oct 04, 2017 1:06 pm

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Posts: 25570
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: date formats

Postby Lupp » Wed Oct 04, 2017 1:53 pm

(The issue isn't just about date formats, but also about date recognition, and basically about the relation between both these aspects.)

To regard the global 'Language Settings' for the spreadsheet document may not be sufficient.
See attached example.

And: Never use the globally deprecated "mid-endian" date formats of 'English (USA)' locale. They are really too bad and cause misunderstandings again and again. Use ISO 8601 compliant YYYY-MM-DD for display in spreadsheets and (in text form) for international exchange. To enter dates you may use whatever your software accepts. I needn't know, and I don't mind.

(This forum's software also should,)
(79.34 KiB) Downloaded 18 times
On Windows 10: LibreOffice 6.1 and older versions, PortableOpenOffice 4.1.5 and older, StarOffice 5.2
Lupp from München
User avatar
Posts: 1914
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Return to Calc

Who is online

Users browsing this forum: No registered users and 13 guests