OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

csv problems (once more...)

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> General Discussion
View previous topic :: View next topic  
Author Message
NecroPhil
General User
General User


Joined: 27 Nov 2004
Posts: 5

PostPosted: Sat Nov 27, 2004 2:53 am    Post subject: csv problems (once more...) Reply with quote

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
Back to top
View user's profile Send private message
NecroPhil
General User
General User


Joined: 27 Nov 2004
Posts: 5

PostPosted: Sat Nov 27, 2004 4:59 am    Post subject: Reply with quote

sorry, wrong forum... Embarassed

i will post it in the calc forum too... to mods: yould you please delete/close this thread? thx!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> General Discussion All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group