Issue 30211 - messing datas while importing csv datas
Summary: messing datas while importing csv datas
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
URL: http://home.htp-tel.de/weihusen/Messu...
Keywords:
Depends on:
Blocks:
 
Reported: 2004-06-14 19:52 UTC by svenw
Modified: 2013-02-24 21:22 UTC (History)
2 users (show)

See Also:
Issue Type: TASK
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 svenw 2004-06-14 19:52:19 UTC 
I wanted to import in the csv Format into calc. The datas use english (point)
notation while I use German notation (comma. The datas are seperated by spaces.
Most of the datas have the format 0.xxxxxx and some 0.xxx. The import funktion
messes with datas with 3 digits after the point. It just ignores the 0 and the
point. I checked the the datas in the preview and there isn't an additional
space in the number.
the file mentioned in the url is the file Iwant to import.
Substituting the points with comma either in some editor or in the writer solves
the problem.
Comment 1 Regina Henschel 2004-06-14 21:29:21 UTC 
Hi, try this feature of the csv-import.dialog: In the preview click on to the
columnhead to activate the column. The list "Column type" will be enabled and
you can choose "US English" for that column.
Comment 2 kla 2004-06-22 09:05:06 UTC 
I think you got the solution from regina.
So i will close it.

kla->regina: Thx
Comment 3 kla 2004-06-22 09:05:25 UTC 
closed
Comment 4 floriar 2008-08-25 20:22:22 UTC 
Hello,

I experienced the same problems with OOo2.4.1 on a Vista SP1 box. Yes, I could
handle it using the mentioned way from regina. But I'd like to know, why this
happens, because the behaviour is confusing and for a normal user its just like
a bug.
Comment 5 floriar 2008-08-25 20:23:53 UTC 
Hello,

I experienced the same problems with OOo2.4.1 on a Vista SP1 box. Yes, I could
handle it using the mentioned way from regina. But I'd like to know, why this
happens, because the behaviour is confusing and for a normal user its just like
a bug.