Issue 25434 - ISO standard time formats (YYYY-MM-DD HH:MM and YYYY-MM-DD HH:MM:SS) missing in cell format selection
Summary: ISO standard time formats (YYYY-MM-DD HH:MM and YYYY-MM-DD HH:MM:SS) missing ...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.1b
Hardware: All All
: P3 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
: 25435 (view as issue list)
Depends on:
Blocks:
 
Reported: 2004-02-12 22:36 UTC by ooo
Modified: 2013-02-07 22:33 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
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 ooo 2004-02-12 22:36:31 UTC 
When you want to set the time or date format for a cell the ISO standard 
formats YYYY-MM-DD hh:mm and YYYY-MM-YY hh:mm:ss are missing. 
 
OpenOffice.org as an Open Source project should follow open standards where  
ever there is one because open standards is one of the best weapens against  
close source compatitors when governments have to decide which products to  
use.
Comment 1 frank 2004-02-13 08:22:44 UTC 
Hi Bettina,

one for you, should be easy to implement.

Frank
Comment 2 lohmaier 2004-02-13 22:58:33 UTC 
*** Issue 25435 has been marked as a duplicate of this issue. ***
Comment 3 agerskov 2005-02-07 10:52:14 UTC 
Why does it take so long time to implement ISO time formats? 
 
Now the default document format for OpenOffice.org will be the open standard 
OpenDocument which is a major competitive advantance. 
 
Open standards is the best battlefield for open source products because they 
can be fully supported so why not support the open standard for time formats 
as part of the default formats in every locale. 
 
This way you can more easily exchange date and time information even though 
you don't use the same langugage. Every time I write down a date I use the ISO 
format - this is the only way the world can be united.
Comment 4 conficio 2008-07-31 19:40:19 UTC 
This is also an issue in Impress, for the slide format the date field.
Comment 5 Regina Henschel 2008-10-18 23:03:33 UTC 
ISO format is available in Spreadsheets cells in OOo3.0. Please check the issue
with the newest OOo version. I'm going to close this issue as resolved.

The missing ISO format in impress is already tracked in issue 25424.
Comment 6 ooo 2008-10-20 13:17:13 UTC 
ISO date formats are available since ages. I think what the request is about are
_predefined_ ISO formats for date _including_ time. A user can always define
them though.
Comment 7 bettina.haberer 2010-05-21 14:46:43 UTC 
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".