Issue 79609

Summary: Calc doesn't handle ISO dates correctly
Product: Calc Reporter: marcsinclair <marcsinclair>
Component: formattingAssignee: spreadsheet <spreadsheet>
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.1   
Target Milestone: ---   
Hardware: All   
OS: Linux, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description marcsinclair 2007-07-13 22:59:44 UTC 
If I enter a date in ISO standard date formats (YYYY-MM-DD, YYYY-MM-DD HH:MM and
YYYY-MM-DD HH:MM:SS) Then it is converted into some foreign, non statndard format.

Although formatting the cells to 1999-12-31 then shows the date correctly in the
cells, editing the cell then reverts the date to some other foreign, non
standard format.  

The program should not disclose its internal working format, which should be the
ISO standard anyway!  double clicking on the cell should allow editing in the
preset format, or at least, the system format.

Marc Sinclair
Comment 1 frank 2007-09-04 13:18:21 UTC 
Not a defect.
The default formatting for dates is based on the used system locale and the
given settings for that which comes with OOo.

So the default format for editing uses the given one from the locale setting.

Frank
Comment 2 frank 2007-09-04 13:18:53 UTC 
closed invalid
Comment 3 frank 2007-09-07 10:06:37 UTC 
reopened to set as double
Comment 4 frank 2007-09-07 10:07:21 UTC 
double to Issue 5556

*** This issue has been marked as a duplicate of 5556 ***
Comment 5 frank 2007-09-07 10:07:45 UTC 
closed double