Issue 71162 - Base ignores Windows regional date format
Summary: Base ignores Windows regional date format
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.4
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: dbaneedsconfirm
QA Contact: issues@dba
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2006-11-03 19:26 UTC by tgildea
Modified: 2013-08-07 15:45 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 tgildea 2006-11-03 19:26:36 UTC 
I'm connected to a MySQL database over ODBC.  I have a date column in my
database that is of the form YYYY-mm-dd.  However, Base formats the date as
mm/dd/yy even though my Windows preferences are to format dates as YYYY-mm-dd. 
I realize that most people in America write dates as mm/dd/yy, but this is a
very foolish way to do it.  OpenOffice should follow my system preferences (not
to mention ISO standards).

Thanks,
Tim
Comment 1 tgildea 2006-11-03 19:34:55 UTC 
Another problem with this is that I can't tell the difference between 2000-01-01
and 2100-01-01 -- they're both displayed as 01/01/00.  I realized that I can
change the format by right clicking the column header, but it would be nice if
OO respected system settings by default.
Comment 2 christoph.lukasiak 2006-11-07 11:00:47 UTC 
clu->tgildea: you can change that under (tools/options/language settings) and
the settings depends of what 'nationality' your oo is - as i know it is defined
that way and i could imagine, if we make it like you describes it (also a valid
possibility) a lot of people will send issues that their 'english' office
running on a asian os do not match to english date standard ..

for the second addition, please write a seperate issue (rule: one bug - one
issue, see also: http://qa.openoffice.org/issue_handling/basic_rules.html) and
describe step by step what you do (date formats can be used in a lot of parts in
oo and if you do not describe it more precisely, we have to guess ..)

thx
Comment 3 christoph.lukasiak 2006-11-07 11:01:38 UTC 
=> close
Comment 4 Frank Schönheit 2006-11-13 10:05:31 UTC 
fs->tgilda: What's your setting in "Tools / Options / Language settings /
Languages / Locale setting"?

Reason why I'm asking:
There's a distinction between "user interface language" and "Locale setting".
The former only affects, well, the language of the user interface, while the
latter affects things such as number (and thus currency) formats.
Comment 5 christoph.lukasiak 2006-11-13 14:57:47 UTC 
reopen issue because of misunderstanding description
Comment 6 christoph.lukasiak 2006-11-21 10:40:25 UTC 
set keyword 'needmoreinfo'
Comment 7 christoph.lukasiak 2007-01-16 14:17:15 UTC 
no respond
Comment 8 christoph.lukasiak 2007-01-16 14:17:34 UTC 
close