Issue 23024 - CSV import into spreadsheet application: date values instead of numbers
Summary: CSV import into spreadsheet application: date values instead of numbers
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-11-29 17:39 UTC by pietervsta
Modified: 2008-04-11 08:12 UTC (History)
1 user (show)

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

Attachments
CSV text document with numbers that convert to dates (ZIP) (986 bytes, application/octet-stream)
2003-11-29 17:40 UTC, pietervsta 		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 pietervsta 2003-11-29 17:39:01 UTC 
Most of the numbers in the CSV text document are converted to dates (e.g.
01/01/00).  The numbers are still numbers in the CSV import dialog box, but they
appear as date values in the Spreadsheet application.
Comment 1 pietervsta 2003-11-29 17:40:48 UTC 
Created attachment 11633 [details]
CSV text document with numbers that convert to dates (ZIP)
Comment 2 frank 2003-12-01 08:54:54 UTC 
Hi,

I assume that the decimal sparator in your country is a comma and not
a dot. Just set the column which contains the values to type
US/English and the numbers will be imported correctly.

As this is not a bug I close it as worksforme.

Frank
Comment 3 frank 2003-12-01 08:55:54 UTC 
closed worksforme
Comment 4 mfrasca 2008-04-11 08:12:24 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.