Comment 23 for bug 391572

Revision history for this message
In , Marcsinclair (marcsinclair) wrote :

No, the issue is that date handling in Open Office is a dogs breakfast.

1 - Open a new Spreadsheet on a machine with ISO dates as the native date format

2 - Enter the date 2008-01-02 into a cell

3 - Press return

4 - cell shows 02/01/08 (whatever that means, is it January, February or August?)

5 - Select the cell

6 - The Input line now says 02/01/2008 (aha! so it is either January or February)

7 - Double click the cell and it changes to the second format 02/01/2008 trying
to edit in this unusual format is problematic and almost useless for practical use.

Marc