Issue 37062

Summary:	Typing in 'SO8' makes always a date, very annoying
Product:	Calc	Reporter:	hans_werner67
Component:	formatting	Assignee:	AOO issues mailing list <issues>
Status:	ACCEPTED ---	QA Contact:
Severity:	Trivial
Priority:	P4	CC:	hans_werner67, issues, stp
Version:	680m60
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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.

Frank

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

Accepted.

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"

Mario

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

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

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.

Frank

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

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

Comment 7 Marcus 2017-05-20 11:13:22 UTC

Reset assigne to the default "issues@openoffice.apache.org".