Comment 36 for bug 391572

Revision history for this message
In , Apache-org-201110 (apache-org-201110) wrote :

There seems to be a lot of confusion here. Let's summarize:

When editing a date in Calc, the date format used to edit the date does not
match the date format configured for the cell, nor does it match the date format
configured in the user's locale. This bug complains about the edit date format
not matching the format configured for the cell.

Another bug may or may not exist (if there is, then please link to it) which
complains about the edit date format not matching the date format configured in
the user's locale. A related bug (bug 72229) requests that the edit date format
be configured separately from either the date format configured for the specific
cell or from the user's locale date format.

Steps to reproduce this bug:
1) Right-Click on a cell -> Format Cells -> Numbers -> Category -> Date ->
Choose format 31/12/1999
2) Enter into that cell my wedding day: September 2, 2005: 2/9/2005

What is displayed?
February 9, 2005: the day of a car bombing.

What is expected to be displayed?
September 2, 2005: my wedding day.

Note that on this system the configured locale date format is yyyy-mm-dd.