Issue 13929 - unable to get back to number after some kind of autoconvert to date
Summary: unable to get back to number after some kind of autoconvert to date
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 644m11
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-04-29 10:02 UTC by gemal
Modified: 2008-04-11 08:12 UTC (History)
1 user (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 gemal 2003-04-29 10:02:29 UTC 
if you paste this into a sheet:
1.3	40.970

that's:
1.3<tab>40.970

the 1.3 is automaticlly converted into "01-03-2003" and I cant change it back.

I tried to format the field as number but then it just writes "37681"

HELP

ooo644_m11
Comment 1 frank 2003-04-30 09:43:52 UTC 
Hi Henrik,

indeed this is a problem. I've tried it using paste special and before
formating the cell as english language while my system locales are
german. Doing it this way the numbers get's in as such and not
converted into a date.

As this works as intended, the autorecognition of dates is a feature,
I've to close it as worksforme.

Frank
Comment 2 frank 2003-04-30 09:44:05 UTC 
closed
Comment 3 mfrasca 2008-04-11 08:12:03 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.