Issue 79609 - Calc doesn't handle ISO dates correctly
Summary: Calc doesn't handle ISO dates correctly
Status: CLOSED DUPLICATE of issue 5556
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.1
Hardware: All Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2007-07-13 22:59 UTC by marcsinclair
Modified: 2007-09-07 10:07 UTC (History)
1 user (show)

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


Note You need to log in before you can comment on or make changes to this issue.
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.

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