Apache OpenOffice (AOO) Bugzilla – Issue 79609
Calc doesn't handle ISO dates correctly
Last modified: 2007-09-07 10:07:45 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
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
closed invalid
reopened to set as double
double to Issue 5556 *** This issue has been marked as a duplicate of 5556 ***
closed double