Issue 22725

Summary: On french Win2k, typing a decimal number with dot (.) give a date
Product: Calc Reporter: lcn <lcn>
Component: codeAssignee: spreadsheet <spreadsheet>
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1   
Target Milestone: ---   
Hardware: PC   
OS: Windows 2000   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Type 1.2 in English OOo Calc on French Win2k SP4. md5sum : b515d5c9d375c7b4d64cf55184303554 none

Description lcn 2003-11-21 20:50:27 UTC 
On French Win2k, enter a decimal number with dot (.) give a date.
When I type 1.2 in a cell, the result is 01/02/03.
Normally (depending of language) on Excel 97, it gives a TEXT TYPE or a DECIMAL 
TYPE, NOT A DATE TYPE.

I tested on French Win2k with English OOo 1.1 and French OOo 1.1.
whatever decimal dot "." is numpad dot or principal keyboard dot.

Note : Decimal dot in French is a comma ",". See issue 1820.
Comment 1 grsingleton 2003-11-21 21:13:24 UTC 
I tested with OOo1.1.0 en under XP and under linux and can not
duplicate your findings. Default format for cells is numberGeneral and
NOT date. Date may be set in your template. Try looking to the
template and report back.
Comment 2 lcn 2003-11-22 22:01:34 UTC 
I retested English OOo 1.1.0 on French Win98SE and French Win2K SP4.
I have the same problem, it gives a date format. I'll post PNG files 
in a zip file.

I examine the cell format window. In number tab, there is a combox 
box for language.
In French, In excel 97/2000 (I don't know for other programs), type 
1.2 doesn't give a date 01/02/2003.
It's need to be discussed.

It's maybe a language problem, because in german language, type 1.2 
give 01.02.03.
Comment 3 lcn 2003-11-22 22:05:30 UTC 
Created attachment 11466 [details]
Type 1.2 in English OOo Calc on French Win2k SP4. md5sum : b515d5c9d375c7b4d64cf55184303554
Comment 4 frank 2003-11-24 10:00:38 UTC 
Hi,

this is a double to Issue 7467.

So I close this one as double.

Frank

*** This issue has been marked as a duplicate of 7467 ***
Comment 5 frank 2003-11-24 10:00:53 UTC 
closed double
Comment 6 frank 2006-11-06 11:21:14 UTC 
*** Issue 71197 has been marked as a duplicate of this issue. ***
Comment 7 mfrasca 2008-04-11 08:12:21 UTC 
if you stumble on this issue, you might want to check
http://www.openoffice.org/issues/show_bug.cgi?id=87999
(which is still open) and vote for it.