NecroPhil
General User
Joined: 27 Nov 2004
Posts: 5
|
 Posted: Sat Nov 27, 2004 2:53 am Post subject: csv problems (once more...) |
 |
|
Hi guys!
I didnīt find a sollution to this problem by searching the forums, so I have to post it here:
When I want to import a text file as csv, containing data like this
| Quote: | 0.9400 -0.3
0.9600 -0.3
0.9800 -0.3
1.0000 -0.3
1.2800 -10.3
1.3000 -18.5
1.3200 -27.5
|
where the first value represents time in seconds and the second one is the position of a pendulum.
When I open the file, calc imports the data but formats it like this:
| Quote: | 0.9400 -0.3
0.9600 -0.3
0.9800 -0.3
01.01.2000 -0.3
01.01.2800 -10.3
01.01.3000 -18.5
01.01.3200 -27.5 |
(the first and second values are located in seperate columns)
so it interprets 0.9800 as number, but 1.0000 as date.
Also another strange effect occurs: When I now want to compute e.g. the difference between the second values of the first and the last row, the result is zero.
Iīm using OO 1.1.0 on Windows XP Pro.
Thanks in advance for every help
Phil |
|
