Issue 40836 - Date format input only accepts US dates
Summary: Date format input only accepts US dates
Status: CONFIRMED
Alias: None
Product: Writer
Classification: Application
Component: formatting (show other issues)
Version: OOo 1.1.3
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-01-17 21:06 UTC by simmondp
Modified: 2017-05-20 11:19 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description simmondp 2005-01-17 21:06:44 UTC 
Open Offices configured to UK English.

Table Created and cell formated for "Dates" "MMM YY" 

Entering "November 2004" correctly displays "Nov 04"

Entering "1-11-04" (UK format date) incorrectly displays "Jan 04"

Entering incorrectly a US format date "11-1-04" displays the required "Nov 04"
Comment 1 nagashree 2005-01-20 10:49:33 UTC 
Confirming the issue on windows and even on linux on OpenOffice 1.1.3,
OpenOffice1.1.4 and OpenOffice m69
Comment 2 michael.ruess 2005-05-27 11:14:34 UTC 
MRU->OS: Writer's number format in cells does not distinguish between British
and American number format. Calc does it the right way.
Comment 3 sswales 2010-02-22 18:26:20 UTC 
This is still outstanding in 3.2 OOo Writer.

Fails the same way on Windows XP, OOo 3.2 en-GB release.

Even entering a dd/mm/yyyy input treats the dd part as mm when dd <= 12.  With
dd > 12 date entry is correct for both dd-mm-yy{yy} and dd/mm/yy{yy} input.

Entering yyyy-mm-dd is ok.

This issue affects not just British English, though: using a German locale with
user-defined date format of "MMM JJ" also behaves incorrectly with "1-11-04" input.
Comment 4 Marcus 2017-05-20 11:19:31 UTC 
Reset assigne to the default "issues@openoffice.apache.org".