Issue 20286

Summary:

problems with csv import

Product:

Calc

Reporter:

balazsa <attila.balazs>

Component:

code

Assignee:

Status:

CLOSED NOT_AN_OOO_ISSUE

QA Contact:

issues@sc <issues>

Severity:

Trivial

Priority:

CC:

issues

Version:

OOo 1.1 RC5

Target Milestone:

---

Hardware:

OS:

Linux, all

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
the referenced csv file	none

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