Re: [libreoffice-users] Calc importing csv

Luuk,

On Sat, 2011-07-09 at 14:41 +0200, Luuk wrote:

> 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

i imported the data and it appears to have imported correctly with LO
3.4.1 on Ubuntu/Pinguy 11.04 with US local settings ( decimal '.'). I
imported with the "," as the delimiter.

-- 
Jay Lozier
jslozier@gmail.com

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