Re: [libreoffice-users] Calc importing csv

Hi Luuk,

Luuk schrieb:
> 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 ??

When you are in the import dialog, you see a preview of the imported 
data. Click on the column header there. Then the drop-down-list to 
choose the type is enabled and you can set the type of the source.
The first column is 'Date (DMY)'
second column is 'US English'

Kind regards
Regina

--
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