Date formats

Discuss the spreadsheet application

Date formats

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

Hi,
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?

TIA
OOo 4.1.3 on 8.1
desdichato
 
Posts: 70
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.4 on Xubuntu 16.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 25088
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.
Cheers
David
OpenOffice 4.1.3 - Windows 7
OpenOffice 4.2.0 - Slackware 14.2 - 64 bit
User avatar
robleyd
Volunteer
 
Posts: 950
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: date formats

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

Tools>Options>LanguageSettings>Languages>Locale
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
Villeroy
Volunteer
 
Posts: 24400
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,)
Attachments
aoo90628DateRecognition_1.ods
(79.34 KiB) Downloaded 9 times
On Windows 10: LibreOffice 5.4.2 and older versions, PortableOpenOffice 4.1.3 and older, StarOffice 5.2
---
Maybe we might! (Create a powerful UFO: United Free Office)
Lupp from München
User avatar
Lupp
Volunteer
 
Posts: 1444
Joined: Sat May 31, 2014 7:05 pm


Return to Calc

Who is online

Users browsing this forum: Google [Bot], Zizi64 and 50 guests