[libreoffice-users] Re: *.csv formats and MS DOS CSV formats

Le 24/04/2013 14:36, sun shine a écrit :

Looking at this :

http://customs.hmrc.gov.uk/channelsPortalWebApp/channelsPortalWebApp.portal?_nfpb=true&_pageLabel=pageImport_ShowContent&id=HMCE_PROD_010685&propertyType=document


gives a list on how to structure the file and hints on what to do if 
your CSV submission fails, e.g. if leading zeroes get dropped or if 
NULL/0 values get replaced with nothing (as is the case with 
LibreOffice). The solution to those particular problems is to enter the 
data as a text string (by putting a leading apostrophe, for example).

That same page also recommends not working on your CSV file directly, 
and in particular not to re-open it in your spreadsheet program (Excel 
cited in that particular case) !!


Alex


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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