Cell is formatted for dates dd/mm/yy. When I try to enter today's date (1st February) as 1/2/13, as soon as the fourth character (the second /) is typed, the first three are interpreted as 1/2, so the contents become ½/2013
Steps to reproduce:
1. Set English style date format
2. Format a cell for 31/12/99 type date
3. type 1/2/2013
Operating System: Linux (Other)
Version: 188.8.131.52 release
I can confirm this behavior when I set Cell language as 'English (VS)' using LibreOffice 184.108.40.206rc2 Linux Mint 14 x64. But I'm not sure this is a bug, or correct behavior. Because you choose to set a data field with formatting MM/DD/YY...
@Markus: can you confirm this is a bug or this is correct behavior?
Number format code and date pattern detection is Eike's area.
Well, yes, but this is not a number formatter/scanner problem ;-)
It is auto-correction that hits first and then the "corrected" string is fed to the scanner that of course shakes head ...
The workaround is to disable under Tools->AutoCorrectOptions the entries for 1/2, 1/4 and 3/4
The proper cure would be that these specific entries are not to be triggered if another '/' slash followed. AFAIK that's somewhere in the EditEngine.
*** This bug has been marked as a duplicate of bug 33899 ***