Issue 20804 - CSV Import: Values >= 1 are not recognized as numbers but as date
Summary: CSV Import: Values >= 1 are not recognized as numbers but as date
Status: CLOSED IRREPRODUCIBLE
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: oc
QA Contact: issues@sc
URL: http://www.lebensmittelintoleranz.org...
Keywords:
: 20805 69097 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-10-06 22:28 UTC by wiki
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 wiki 2003-10-06 22:31:55 UTC 
If I import a CSV File with ',' as delimiter and with numbers that have '.' as
decimal separator numers all values <1 are imported as strings, 1 and other
numbers with no decimals are imported as numbers and everything >1 with some
decimals is imported as a date. In the preview of the import all values are
still displayed correctly. The country settings are set to German (with ',' as
decimal separator). If I import this CSV in Excel everything goes fine.
A sample CSV file you can find at URL displayed above
Comment 1 frank 2003-10-07 08:03:50 UTC 
Hi,

this is not a bug !

Excel just interpretes such document according to it's hard coded
settings. OOo will give you the freedom to select what you want. In
the csv preview dialog select the column with the decimals and set it
to US English. The values are loaded as numbers.

Frank
Comment 2 frank 2003-10-07 08:04:12 UTC 
closed worksforme
Comment 3 frank 2003-10-07 08:05:23 UTC 
*** Issue 20805 has been marked as a duplicate of this issue. ***
Comment 4 frank 2006-09-07 13:04:32 UTC 
*** Issue 69097 has been marked as a duplicate of this issue. ***
Comment 5 mfrasca 2008-04-11 08:12:17 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.