Issue 37062 - Typing in 'SO8' makes always a date, very annoying
Summary: Typing in 'SO8' makes always a date, very annoying
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 680m60
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2004-11-12 09:13 UTC by hans_werner67
Modified: 2017-05-20 11:13 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description hans_werner67 2004-11-12 09:13:39 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.
Comment 1 frank 2004-11-12 12:14:12 UTC
Hi Eike,

as this happens in the exact same way on SO7 (german locales in both cases) this
is P4 later.

Comment 2 ooo 2004-11-12 16:55:35 UTC

In an English locale it "works" with sun8 ...
Comment 3 mfdas 2005-06-27 22:19:12 UTC
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"

Comment 4 ooo 2005-06-28 17:56:52 UTC

that's normal behavior because with Ctrl-X you remove also the applied number

With existing number formats, detecting the input changed for OOo2.0 to not
change the format in some cases. For details see

Comment 5 hans_werner67 2006-10-19 10:47:15 UTC
Hi Eike,
in my eyes we can close this issue, works as specified (OOo 2.0.4). If you
agree, reassign back to me.

Comment 6 ooo 2006-10-19 12:37:42 UTC

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.

Comment 7 Marcus 2017-05-20 11:13:22 UTC
Reset assigne to the default "".