Apache OpenOffice (AOO) Bugzilla – Issue 27717
Date of April 4, 2004 mis-formats
Last modified: 2004-04-13 09:39:09 UTC
Format a 1-column, about 6 rows as Date: YYYY-MM-DD. Enter "4/4/2004" in top row. Edit | Fill | Down | Series | Day. Observe each date follows YYYY-MM-DD format. Now pick any cell and re-enter the date for example,as "4/3/2004". That's good. Now re-enter "4/4/2004". It shifts to left-aligned as if it had become a string. No amount of fiddling with format will make the hand-entered 4/4/2004 cell follow YYYY-MM-DD. I think same applies to YYYY/MM/DD.
This is a double to Issue 24082 Frank *** This issue has been marked as a duplicate of 24082 ***
closed double