Description: When opening a csv file in Libre Office some separated fields get combined into a single cell, resulting in the error "The data could not be loaded completely because the maximum number of characters per cell was exceeded." This does not happen if the file is opened in Microsoft office for example. Steps to Reproduce: 1.Open csv file I uploaded 2.Row 113 column E shows affected cell 3. Actual Results: Many comma separated fields dumped into a single cell. Expected Results: Many fields searated into cells Reproducible: Always User Profile Reset: No Additional Info: File uploaded with error message User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.186 Safari/537.36
Was there going to be an attachment? Also, opening the .csv should open the Text Import dialog. There you have ability to adjust the Separator Options precisely. Does doing so help?
If you can not post the original .CSV file--please don't if proprietary or sensitive. You can use a text editor of some sort (i.e. sed/awk, gvim, notepadd++, etc.) to sanitize the text--keep the same data layout and types e.g. numbers remain numbers, text remains text, dates dates. Does not need to be the full file--just enough so that you still have the issue when filter import opening the file into LibreOffice Calc.
Without a sample file to reproduce there's nothing we could do. I assume the data in question does not close an enquoted (") field and thus all following data including all next lines ends up in one cell until that reaches end of capacity.