DL->ER: I think it might be your task.

er->cs: do you mean to list the ISO formats on top of the list instead of further down?

Claus, could I get an answer regarding my question, please?

I would put the ISO formats at the top.

But the best way would be that the date and time standard listed
first is the language dependable. Then the ISO formats. And at the
bottom all the formats.

Consider using the msgid number format code field of locale data XML
files for UI sorting purposes:

<FormatElement msgid="...">

Using spreadsheet format to facilitate genealogical studies can only 
handle a 100 year period.  Not too troublesome except cells insist on 
converting to two digit year and prints them that way.  Need ability 
to share information with my European friends in a format that both 
of us can understand.  Today's date is 25 May 2002.  My dates like 25 
Jul 1885 get converted to 07/25/85.  I would like control over that.

I can adjust via the tool set which span of years are covered.  But 
printing the dates with two digit years is confusing.

er->JoeRooney: I don't see your problem. Just use a number format that
displays dates with centuries, for example, YYYY-MM-DD

retarget to OOo Later

Should this be retargeted again? 
 
It was retargeted over a year ago - and I would really like to see this feature in OOo 2.0. 
 
And as far as I can see it should be too complicated to add these date and time formats to the 
ones which is already implemented - even if it is only at the bottom of the formats in the list. 
Then we can change the order afterwards. 
 
The best way open source software can beat closed source software is by using open 
standards. So please reconsider this issue. 
 
Thanks in advance 

Claus,

This issue is not about adding ISO date/time formats, but a predefined order of
listing of formats, and to move the ISO formats more to the top of the list. To
have that handled in a more general way it's not just about reordering some
entries, but to provide a mechanism to be able to specify an ordering within the
locale data. So no, no retargeting.

Eike

Ok - but Impress still lacks the ISO date format. 
 
I'll create a new issue concerning this. 
 
I'm looking forward to the fixing of this issue. 
 
Thanks in advance. 

May I ask that you make one for writer while you are at it. We should be consistent.

You're right - Writer only have YYYY-MM-DD and lacks YYYY-MM-DD hh:mm and 
YYYY-MM-DD hh:mm:ss. It is the same with Calc. 
 
I create issues for Writer and Calc also. 

Both, Calc and Writer, use the same set of predefined format codes in the number
formats dialog. There is no need for separate issues.

Eike

The difference is if they are listed or not. 
 
The diffent applications have their specific way to select formats for date 
and time. 
 
In Writer date and time is set by fields and you can select the format 
YYYY-MM-DD but not the other two. But you can write your own format under 
"Additional formats...". 
 
In Calc you specify the format of the cell and you can select the format 
YYYY-MM-DD but not the other two. But you can write your own format under 
"Format code" in the "Format Cells" dialog box. 
 
In Impress and Draw date and time is set by fields and you can only use 
formats which is in the drop-down-list when you right click the field. 
 
Maybe Impress and Draw should implement fields the same way as Write which 
gives the user more opportunities. And not only when it comes to date and time 
fields. 

To add to this.

This issue was opened in 2002 and it is still not fixed or resolved.  Yes there
are ISO dates in some dropdown menues but there are areas that it has not occured.

In Calc, you cannot set the date format of headers and footers.  It uses the
format as set in the Options selection.  There is no selection for ISO dates in
the options settings for default selection.

Why cannot OOo support "One default setting" for the whole suit and then still
allow customization as required.

I tested this in 1.9.95 today.

Added to cc

To add my comment to this issue.

Our locale settings don't reflect the date code that we need to use.  We are
moving to ISO format and when the locale settings are taking over for what we
need as a default setting is a pain.  Especially when headers and footers become
involved.

Of course we run into this situation with Microsoft Office as well.

What is needed it a way to set OOo's default formats in the options selections.

To provide an example.  My locale is English Canada but our company date format
is YYYY-MM-DD, not MM/DD/YY.  It makes it hard when I want to insert a date field.

In Linux, there is no way to set the system wide date format (at least easily)
as there is in Windows so the option isn't to change the system default which I
would love to do.

Reset assigne to the default "issues@openoffice.apache.org".