[libreoffice-users] Calc importing csv

Hi,

I tried to import some CSV-data

the source is here:
http://www.lloydsbankinggroup.com/investors/share_price_information/historical_share_price.asp

i selected (it was auto-suggested) from 28-dec-1995 to 09-jul-2011

The start of the downloaded data looks like:

,Date,Price,Volume

,28/12/1995,228.72766,7730000
,29/12/1995,220.73718,3557000
,02/01/1996,212.41376,10939000
,03/01/1996,216.409,15284000
,04/01/1996,219.0725,12418000
,05/01/1996,213.07964,5932000
,08/01/1996,214.41138,3694000
,09/01/1996,208.4185,7937000
,10/01/1996,209.08438,15280000
,11/01/1996,206.42088,13783000
,12/01/1996,205.755,8403000
,15/01/1996,211.08202,6972000
,16/01/1996,217.74074,7689000
,17/01/1996,217.07487,10208000


When i paste this data into a new worksheet (and follow the import text
wizard) the first line looks like:
28/12/1995      228.72766       7730000
which is expected

But two lines of this export do NOT look like expected:
03/01/1996      216409  15284000
12/01/1996      205755  8403000

The '.' in the second column is missing..... ;(

Any ideas ??

My locale setting are set to Dutch (decimal ',' )

-- 
Luuk


-- 
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted