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+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@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