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

Import .CSV files in OO Calc 3.3.0 vs 3.2.1

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


Joined: 25 Oct 2005
Posts: 22

PostPosted: Fri Feb 18, 2011 1:34 am    Post subject: Import .CSV files in OO Calc 3.3.0 vs 3.2.1 Reply with quote

I've got CSV files containing times, the first few lines of one file look like:
Code:
 1, 1,19800616,"07:47:00",+041051.0,19800616,"07:52:00",+041054.2,"00:05:00",+0038.4,"NL" ,"V"   ,"De Bilt"                        ,"afs Amersfoort"
 1, 2,19800616,"08:12:00",+033268.0,19800616,"09:25:00",+033403.0,"01:13:00",+0111.0,"NL" ,"-"   ,"afs Amersfoort"                 ,"Enschede"
 1, 3,19800616,"09:58:00",+078048.0,19800616,"10:28:00",+078060.0,"00:18:00",+0040.0,"NL" ,"-"   ,"Enschede"                       ,"Enschede"
 1, 4,19800616,"10:49:00",+001311.0,19800616,"11:33:00",+001342.0,"00:37:00",+0050.3,"D"  ,"-"   ,"Enschede"                       ,"Nordhorn"
 1, 5,19800616,"12:01:00",+074721.0,19800616,"12:17:00",+074740.0,"00:16:00",+0071.3,"D"  ,"-"   ,"Nordhorn"                       ,"Lingen"
 1, 6,19800616,"12:44:00",+069636.0,19800616,"14:58:00",+069869.0,"02:00:00",+0116.5,"D"  ,"-"   ,"Lingen"                         ,"Rastst„tte Hamburg Stillhorn"


and I only tell OO Calc 3.2.1 that
  • the 19800616 columns contain dates in YMD format,
  • the separator is a comma
  • the data is in ASCII codepage 437 format

It imports correctly, cols 1 & 2 show as numbers (despite the leading space), and the times (cols 4, 7 and 9) show as times.

Then, earlier this week I upgraded to OO 3.3.0, and did the same...

Problems?

Cols 1 & 2 import as text, and so do the time (4, 7 & 9) columns.

A change of ' ' to '' applied to cols 1 & 2 turns them into numbers, nice (but fundamentally wrong), but I've been unable to find any method of turning cols 4,7 & 9 into times.

As a result, I was forced to completely uninstall 3.3.0 followed by a reinstall of 3.2.1. My company uses lots of CSV files generated by other applications (some of them run on IBM's z/OS!), so, to express myself very politely we are not very happy about this...

Can anyone what I'm doing wrong reading these CSV files?
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Fri Feb 18, 2011 4:40 am    Post subject: Reply with quote

Answered in http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=38512
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc 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