Issue 20286 - problems with csv import
Summary: problems with csv import
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC5
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-09-28 22:03 UTC by balazsa
Modified: 2003-09-29 10:29 UTC (History)
1 user (show)

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

Attachments
the referenced csv file (524 bytes, text/plain)
2003-09-28 22:04 UTC, balazsa 		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 balazsa 2003-09-28 22:03:42 UTC 
I found this problem with the file attached. In fact there are two problems:
A. The import process does not take into account the implied additional spaces
the BUX values should showed in the last three coloumns.
B. This is the serious one the 9079.08 and 9044.12 values are recognized as
dates! Aditionally I were unable to correct this misinterpretation.
Comment 1 balazsa 2003-09-28 22:04:44 UTC 
Created attachment 9772 [details]
the referenced csv file
Comment 2 frank 2003-09-29 10:29:07 UTC 
Hi Attila,

this is neither a Bug nor an enhancement request but a support
question. These are answered at the mailinglists especially users@...

So I have to close this one as Invalid

What is the delimiter for the fields ? If set to TAB, the one
automatically selected by Calc, I get no usefull document, setting to
space and merging delimiters produces a usefull document but will cut
off some spaces.

If you want the Values to be text, just set the column in the CSV
Import dialog to text. If you like them to be numbers with decimals,
just set the columns to US-English.
Comment 3 frank 2003-09-29 10:29:29 UTC 
closed invalid