Issue 25942 - standard date format not taken from the system properties
Summary: standard date format not taken from the system properties
Status: CLOSED DUPLICATE of issue 51662
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1.1
Hardware: All Windows 2000
: P3 Trivial with 5 votes (vote)
Target Milestone: ---
Assignee: bettina.haberer
QA Contact: issues@sc
Depends on:
Reported: 2004-02-27 12:07 UTC by Oliver Brinzing
Modified: 2008-08-20 22:31 UTC (History)
2 users (show)

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

demo file for date format (311.61 KB, application/octet-stream)
2004-03-06 12:52 UTC, Oliver Brinzing
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Oliver Brinzing 2004-02-27 12:07:18 UTC

I am using the "DD.MM.YYYY" as short date format 
on my w2k computer.

Entering a date e.g. "27.03." into a calc cell with 
SO 5.2 changes it to automatically to "23.03.2004"

With S0 7.0 the standard date format does not change ...
it's always "DD.MM.YY" ....

Same happens with writer if you insert the field 
command date ... 

Is it a bug or a new feature ?


Comment 1 frank 2004-03-01 10:37:19 UTC

this is not a bugreport but an support request. Such questions are answered on
the mailing lists, especially users@...

I've checked it both with SO5.2 and OOo1.1.1, in both cases the same result

Comment 2 frank 2004-03-01 10:37:37 UTC
closed wfm
Comment 3 Oliver Brinzing 2004-03-06 09:43:54 UTC

I will create an attachment ...

cause all other language settings are taken from the system ...


Comment 4 Oliver Brinzing 2004-03-06 12:52:18 UTC
Created attachment 13599 [details]
demo file for date format
Comment 5 frank 2004-03-08 14:38:30 UTC
Hi Oliver,

nothing is taken from the system. All comes out of the internationalization
framework. So this is a new feature introduced since SO6.

Comment 6 frank 2004-03-09 09:38:30 UTC
reopening because there is no possibility to set the date format according to
the system settings by default. Only way is to change it in the source code and
compile it by yourself.

Comment 7 frank 2004-03-09 09:42:11 UTC
Hi Bettina,

using SO5.2 we are able to use the system settings for the date format. Starting
with SO6 this was changed, starting with this version this setting was not taken
from the system anymore. So we lost a bit of usability. Thew decission was made
to do so, so I flag this one as enhancement.

Comment 8 ooo 2004-07-19 12:40:32 UTC
See also issue 31663.
Comment 9 jolatt 2005-07-24 09:01:36 UTC
If it isn't possible, that OOo uses the date-format of the system there must be 
the possibility to determine this in the optionmenu.
German: Extras-Optionen-Spracheinstellungen-Sprachen.
Comment 10 jolatt 2005-09-15 15:29:18 UTC
What's about my last comment.
It's irritating to change the dateformat every time you insert a date in a 
BTW, I know there is a macro to do this. But this is no final solution for me. 
Comment 11 jolatt 2006-01-17 10:18:52 UTC
Change issuetype from enhancement to defect.

Using the system date format or setting a default date format is a normal 
requirement to a office software.
Comment 12 jolatt 2006-09-03 15:58:13 UTC
Whats about this issue.

It concerns all modules of OOo not only the spreadsheet.
I would prefer the manual setting of the standard date format.
Comment 13 Oliver Brinzing 2007-07-21 17:25:20 UTC
>can you change the issue type from ENHANCEMENT to DEFECT.


Comment 14 Robert Pollak 2008-08-20 20:36:59 UTC
Isn't this a dupe of issue 51662?
Comment 15 ooo 2008-08-20 22:30:48 UTC
It is. Please transfer your votes.

*** This issue has been marked as a duplicate of 51662 ***
Comment 16 ooo 2008-08-20 22:31:15 UTC
Closing dup.