Re: [libreoffice-users] csv problem

Il 07/01/2014 22:53, Mark Bourne ha scritto:
> Cley Faye wrote:
> > 2014/1/7 piergio <pierpiggi@gmail.com>
> >
> > > Hi all
> > >
> > > I'm trying to open (or import in a calc file) a csv file (ubuntu 
> > > 13.10 -
> > > libre office).
> > > I have this error:
> > > "I dati non sono stati caricati interamente perché è stato superato il
> > > numero massimo di caratteri per cella."
> > > (Data have not been loaded completely because you exceeded the maximum
> > > number of characters per cell)
> > >
> > > With MS Office the file works.
> > > Do you have any suggestions to understrand and fix the problem/error?
> > For the "understanding" part, the message seem pretty clear: you have 
> > one
> > cell that is too long for Libreoffice to handle.​​
> >
> > I'm not sure about the limit itself, but trying today with LO 4.1.4.2,
> > between 4096 and 8192 it started showing blank cell (while retaining the
> > content when editing), but still can save and load as a CSV file.
> >
> > Either you're really trying to load a file with a cell containing 
> > more than
> > 16384 characters (it still works with such a large content), or there 
> > was
> > an error while loading your file that made LO think that one cell is 
> > larger
> > than it is. If your file doesn't contain sensitive informations you 
> > could
> > try uploading it somewhere and put the link here so peoples might try
> > opening it. Otherwise, you can try editing the CSV file by hand (with
> > notepad or something), remove half the file, try to load, etc. until you
> > can pinpoint which part leads to the error.
>
> It would be worth checking that the settings in the import dialog 
> match the formatting of the file (open it in a plain text editor to 
> see). CSV isn't really standardised. Maybe the cells are separated by 
> tabs or some other character rather than commas, so it's not detecting 
> any cell breaks. Or maybe the character for quoting text is wrong, and 
> it's interpreting a whole chunk of text as being the content of one 
> cell because it's read an opening quote but no closing quote. The 
> preview table at the bottom of the import dialog should help tell 
> whether you've got the settings correct.
Thank you very much for your suggestions.
There were some contents (only spaces! :)) at the end of the file that I 
had not noticed before. I deleted this part throughgedit and the file 
has been correctly loaded.
Problem solved.

Thank you very much again!

Piergio

--
To unsubscribe e-mail to: users+unsubscribe@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