RE: [libreoffice-users] Calc importing csv

What fun!

OK, from an armchair observer (I have not seen the code that is involved), notice that the two 
deviant cases have a common characteristic:

216.409
205.755

which is where some programmer of a general VALUE( ) conversion might have concluded that this is 
the equivalent of a grouping separator and not a decimal point, when the decimal point is set to 
",".  So the bug may be in how the value converter of the extracted CSV entry decides what must be 
a decimal point and what is grouping.

Try changing your locale decimal point to "." in a test to see if that makes this problem go away.  

This is an over-constrained problem, so any "fix" that works for you will probably break it for 
someone else.

I love these ...

 - Dennis


-----Original Message-----
From: Luuk [mailto:luuk34@gmail.com] 
Sent: Saturday, July 09, 2011 05:42
To: users@global.libreoffice.org
Subject: [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


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