Issue 17224

Summary:	Date format
Product:	Calc	Reporter:	Unknown <non-migrated>
Component:	code	Assignee:	AOO issues mailing list <issues>
Status:	ACCEPTED ---	QA Contact:
Severity:	Trivial
Priority:	P4	CC:	issues, stp
Version:	OOo 1.1 RC
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description Unknown 2003-07-22 10:22:38 UTC

I set the date format of a cell to TT.MM.JJ HH:MM and the language to German
(Switzerland). I enter a date like '22.07.2003 8:00'. Everything seems to be
okay. Now I change the time to 8:25. Now the app doesn't recognise it as date
anymore. Same problem in 1.0.3 and older.

Comment 1 frank 2003-07-22 10:59:49 UTC

Hi Eike,

one for you.

Frank

Comment 2 ooo 2003-07-22 11:38:48 UTC

Ylangisc,

What is your system's locale?

Comment 3 ooo 2003-07-23 14:04:16 UTC

Received screenshots from Yves by mail that show a de_DE locale (KDE
country Germany) overridden with some de_CH values like money.
However, this doesn't seem to be the problem as the behavior can be
reproduced using a Swiss datetime formats in an en_US locale as well.
A workaround for the TT.MM.JJ HH:MM format is to delete the :00
seconds from the input string while editing a value. If a TT.MM.JJ
HH:MM:SS (note the :SS seconds part) format is used, the input for
minutes becomes the seconds part and the minutes are set to 00. Weird.
Note that all this doesn't happen with other German datetime formats,
like de_DE, which are similar to de_CH.

Comment 4 frank 2004-05-05 11:29:44 UTC

Due to time problems this is re-targeted to OOo later

Comment 5 Marcus 2017-05-20 11:13:49 UTC

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