Comment 11 for bug 391572

Revision history for this message
In , Njglin (njglin) wrote :

When a cell date format is set to yyyy-mm-dd, the input line will show US format
mm/dd/yyyy. Also, when the cell is doubleclicked it also changes to US format
(from yyyy-mm-dd) until Enter is pressed.

To reproduce:
1. Open a new spreadsheet.
2. Format a cell A1 to Date in the format yyyy-mm-dd
   - Highlight cell A1
   - on the menu select "format->cells..."
   - select Category: Date
            Format : 1999-12-31
            Language: Default
     Note: The Format Code shows YYYY-MM-DD
3. In the cell enter date 2002-06-04; press "Enter"
4. Highlight the cell again
   THE INPUT LINE SHOWS DATE AS: 06/04/2002
5. Doubleclick the cell
   THE CELL SHOWS DATE AS: 06/04/2002

A. The cell should ALWAYS show the date in the format set for the cell.
B. The input line should ALWAYS show the date in the format set for the cell.

My OS is Windows 2000 US version.
The regional options are:
   -General
    - Your locale: English (United States)
   -Date
    - Short date format: yyyy-MM-dd
    - Long date format: dddd, dd MMMM, yyyy (since yyyy-mm-dd, dddd is not
                                           available)