Apache OpenOffice (AOO) Bugzilla – Issue 37062
Typing in 'SO8' makes always a date, very annoying
Last modified: 2017-05-20 11:13:22 UTC
Typing in 'SO8' in a cell automatically reformats to 08.11.04. May this should be a feature to ease input for a date, but there is no Sunday the 8th. in 2004; it's a monday. Makes no sense anyway.
Hi Eike, as this happens in the exact same way on SO7 (german locales in both cases) this is P4 later. Frank
Accepted. In an English locale it "works" with sun8 ...
Any input that seems to be date-related will change the format of the field to "Date". e.g. CMD-X the contents of a cell that's format is text (the whole column is formatted as text!) and re- type "12/1" Mario
Mario, that's normal behavior because with Ctrl-X you remove also the applied number format. With existing number formats, detecting the input changed for OOo2.0 to not change the format in some cases. For details see http://specs.openoffice.org/calc/ease-of-use/enhance_number_recognition.sxw Eike
Hi Eike, in my eyes we can close this issue, works as specified (OOo 2.0.4). If you agree, reassign back to me. Frank
Frank, What do you mean by "works as specified"? Don't get confused by the comment of 'mfdas' and my answer about the change of number format, which is not related to the original problem. If you enter SO8 in a German locale or SUN8 in an English locale, the input is interpreted as a date. This is not a desired behavior. Eike
Reset assigne to the default "issues@openoffice.apache.org".