Issue 22725 - On french Win2k, typing a decimal number with dot (.) give a date
Summary: On french Win2k, typing a decimal number with dot (.) give a date
Status: CLOSED DUPLICATE of issue 7467
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
: 71197 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-11-21 20:50 UTC by lcn
Modified: 2008-04-11 08:12 UTC (History)
1 user (show)

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

Attachments
Type 1.2 in English OOo Calc on French Win2k SP4. md5sum : b515d5c9d375c7b4d64cf55184303554 (133.56 KB, application/octet-stream)
2003-11-22 22:05 UTC, lcn 		no flags Details
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 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.