117497 – Default Date format for English (Canada) should be DD/MM/YYYY

Issue 117497 - Default Date format for English (Canada) should be DD/MM/YYYY

Summary: Default Date format for English (Canada) should be DD/MM/YYYY

Status:	CONFIRMED

Alias:	None

Product:	Internationalization
Classification:	Code
Component:	localedata (show other issues)
Version:	3.3.0 or older (OOo)
Hardware:	PC Windows, all

Importance:	P3 Normal (vote)
Target Milestone:	---
Assignee:	AOO issues mailing list
QA Contact:

URL:	http://en.wikipedia.org/wiki/Date_for...
Keywords:

Depends on:
Blocks:

Reported:	2011-03-22 01:42 UTC by relay1
Modified:	2015-10-29 21:39 UTC (History)
CC List:	4 users (show)

See Also:
Issue Type:	DEFECT
Latest Confirmation in:	4.1.0-dev
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 relay1 2011-03-22 01:42:57 UTC

After installing OpenOffice 3.3 dates are formatted as YY-MM-DD.  My 'Locale setting' is 'English (Canada)' and the default date format should be DD/MM/YY.

In OpenOffice 3.2 dates are formatted correctly according to the 'Locale setting' as DD/MM/YY.

In OpenOffice 3.3, not only are dates displayed using the wrong format, but the list of available date formats does not include DD/MM/YY, so a user defined date format must be created to display the date correctly.

I observed this problem in Writer and Calc.

Comment 1 Oliver-Rainer Wittmann 2012-06-13 12:18:49 UTC

getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.

Comment 2 Edwin Sharp 2014-02-06 12:04:27 UTC

=Today() gives 2014-02-06 with Tools - Options... - Language Settings - Languages - Language of Locale setting=English (Canada)

AOO410m1(Build:9750)  -  Rev. 1562493
Rev.1562493
Win 7

Comment 3 Rainer Bielefeld 2014-03-08 07:11:09 UTC

Currently we only have an observation, but no info whether the observation is a bug or intended behavoor.  The question is to what settings date format "really" is related, some more research will be required, I will do that, soon.

Back to UNCONFIRMED

Comment 4 Rainer Bielefeld 2014-03-12 11:46:43 UTC

Due to Wikipedia (see URL) there even are differences between anglophone and francophone Canada, Iso-Setting would be correct for French areas, but not for English. 

So (if we trust to Wikipedia) we indeed have a bug here, for English (Canada) default should be  DD/MM/YYYY (or  DD/MM/YY)

French (Canada) is ok.