Issue 17224 - Date format
Summary: Date format
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-07-22 10:22 UTC by Unknown
Modified: 2017-05-20 11:13 UTC (History)
2 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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".