Re: [libreoffice-users] csv problem
Il 07/01/2014 22:53, Mark Bourne ha scritto: Cley Faye wrote: 2014/1/7 piergio pierpi...@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+unsubscr...@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
[libreoffice-users] csv problem
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? Thank you in advance Piergio -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] csv problem
2014/1/7 piergio pierpi...@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. -- To unsubscribe e-mail to: users+unsubscr...@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