Users need to be able to set their date format separately from their system locale or LibreOffice locale. There exist many reasons for this, from organizations requiring ISO8601 (YYYY-MM-DD) to personal preference to working around LO, system, and desktop environment bugs.
See these related OpenOffice.org bugs to understand just how important this issue is:
As a technical consultant, I have lost more OOo and LO users to this bug than to almost any other FOSS bug, with the possible exception of another OOo/LO date bug:
In fact, I think that this bug might be a suitable workaround for that bug as well!
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
This bug is still valid for the latest development version of LibreOffice. Moving to NEW status. Thank you.
Confirmed that this bug still exists in LibreOffice Calc Version: 126.96.36.199 Build ID: 410m0(Build:2). Probably for Y2K reasons, Excel 2010 auto-corrects 2-digit years to 4-digit. Especially now with dates like 10/11/12 and 12/11/10 being commonplace and international data sharing on the rise, this format is horribly ambiguous.
I notice that bugzilla where I'm reporting this bug uses the 1988 ISO 8601 international standard date format: YYYY-MM-DD. This is the only unambiguous international date format. My first choice is to make YYYY-MM-DD the default format for LibreOffice, regardless of system locale. Second choice is to default to (and/or auto-correct to) 4-digit years for all other formats.
I'm using LibreOffice Calc Version: 188.8.131.52 Build ID: 410m0(Build:2) on 64-bit Ubuntu 13.10. I have set my locale to English (USA).
Steps to Reproduce:
- Open LibreOffice Calc
- Click in a cell in a blank spreadsheet
- Type in 3/3/2013
- Press Enter
- Watch cell change to 03/03/13
The same thing happens if the locale is English (UK) - the month and day are reversed, but the year still shows up in 2 digits even if I type in 4. This is very ambiguous when people from the US and Europe (or really the rest of the world) share files.
I'm marking the following (closed) bug as a duplicate:
*** Bug 61338 has been marked as a duplicate of this bug. ***
I just verified this bug exists on Windows 7 Home Premium SP1 32-bit with a clean install of LibreOffice Version: 184.108.40.206 Build ID: 05dceb5d363845f2cf968344d7adab8dcfb2ba71
I followed the steps from my previous comment to reproduce the issue.
I'm setting the Version to 3.5.0 because that is the latest one that this bug could have been noticed in given the age of this ticket. But it references 5 bugs from OpenOffice, so I'm guessing that it's always behaved this way.
1. absent a template, is there a way to change the default date format
2. when a date is inserted into a Libre Office document, shading appears beneath it. Can that be changed to no shading?
Issue still in 220.127.116.11 on RHEL6 (internal build)
*** Bug 77337 has been marked as a duplicate of this bug. ***
Hi, under Tools > Options > Language settings > Language, you can add your own date patterns since 4.3 (I think). So closing - Sophie
(In reply to sophie from comment #12)
> Hi, under Tools > Options > Language settings > Language, you can add your
> own date patterns since 4.3 (I think). So closing - Sophie
can i just reopen this or how should i go about with it?
i'm using libre office 18.104.22.168. my locale date pattern is D/M/Y. when i key in 24/1/15 (24 jan 2015) calc display 01/24/15 (mm/dd/yy) which is the correct date but in unfavourable format.
but when i key in 2/1/15 (2 jan 2015) calc gives 02/01/15 (mm/dd/yy, thus 1 feb 2015) which not the date intended.
so i can say the solution mentioned is not valid.
also, the default cell format and the date format in the formula bar should be able to be adjusted. adjustability should not be limited to date input pattern. otherwise, users will keep getting confused.
Bug does not meet the criteria for Status 'REOPENED'
Status -> RESOLVED WORKSFORME
Marking as NEW (again).
As I understand it, this bug (as reported) is a request to implement a setting for a default *display* format for dates. Unless I'm mistaken, such a feature still does not exist.
Comment 12 refers to the date *input* pattern preference, which has nothing do with the bug at hand. Thus, the bug was incorrectly marked as resolved.
Let me clarify the issue:
Currently, when a date is entered into a cell that doesn't have explicit formatting applied, the date is formatted according to the current locale. There are a few problems with this:
(1) There are countless of situations where a locale-dependent customary format is simply not suitable and a standard format such as ISO 8601 is required. This is a spreadsheet program after all.
(2) The locale-specific formats always seem to have two-digit years, which is not what most people want, even if they are happy with the customary format per se.
(3) Changing the locale affects a host of other things, too, such as the parameter separators in formulas. For this reason, some users may prefer to stick with the default locale even if it doesn't reflect their country or working language.
The obvious way to fix this would be to provide a preference for a default format string alongside the input acceptance patterns.
The two-digit year issue should be addressed separately. The current default behavior is not good, regardless of whether there's a setting to override the default format or not.
*** This bug has been marked as a duplicate of bug 46448 ***