[prev in list] [next in list] [prev in thread] [next in thread] 

List:       koffice
Subject:    AW: Negative review of koffice..
From:       "Schmidt, Frank-Andreas" <Frank-Andreas.Schmidt () sig ! siemens ! de>
Date:       2000-04-19 6:06:10
[Download RAW message or body]

--snip
> Date,Open,High,Low,Close,Volume
> 7-Apr-00,56.8125,57,55.6875,56.6875,5242100
> 6-Apr-00,55.1875,56.8125,55.125,56.5625,8410000
> <snip>
> Both Star Office and M$ Excel suck up the file like a vacuum cleaner. The
> difference is that Excel is smart enough to parse the data in the 1st column
> and display it as a date (sortable) in whichever format the user chooses.
> OTOH, *this* user has yet to stumble upon the magic to cause SO to convert
> the non-native date format into something that is usable. (I tried search &
> replace '-' with '. ', then '. 0' with '. 200' then '. 9'     with '. 199'
> to manually change the data into the form '7. Apr. 2000', 13. Mar. 1999',
> etc and this works fine -- except for the month of May, which appears to
> convert but will not sort properly!)
> 
--snap

Itīs just for the record:
I did not encounter any problem in downloading the above file and convert it to an \
EXCEL sheet.

Just save the data as a .txt file. Start EXCEL, open file, name.txt, the wizard \
appears, choose comma separated and you can arrange the data. No problem ;)

Should be the same with StarOffice, KSpread if the filter works correctly (it will \
!).

Greetings,
-Frank


[prev in list] [next in list] [prev in thread] [next in thread]