Hi,
Am experiencing an annoying 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
Any thoughts?
TIA
Date formats
Re: date formats
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.15 on Xubuntu 22.04.4 LTS
Re: date formats
More specifically, check the various settings in Tools | Options | Language Settings | Languages.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
Re: date formats
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 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: date formats
(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,)
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 70 times
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
---
Lupp from München