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 [email protected] -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] 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
