prino
General User
Joined: 25 Oct 2005
Posts: 22
|
 Posted: Fri Feb 18, 2011 1:34 am Post subject: Import .CSV files in OO Calc 3.3.0 vs 3.2.1 |
 |
|
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? |
|
