To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107867 Issue #|107867 Summary|Plain CSV import erroneous too many rows Component|Spreadsheet Version|OOo 3.1.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|tim_c
------- Additional comments from ti...@openoffice.org Thu Dec 24 03:27:05 +0000 2009 ------- A commonly reported problem is strange CSV import troubles which elicit a too many rows to import error when the number of rows is far short of the actual limit. I created a large CSV file, very simple straight CSV, comma separated, any text field " delimited and with a " quoted header line. EOL is crlf, same if I use just lf. No strangeness, no character encoding, old fashioned upper case plain ascii. Tried various import character encodings, no effect. Exclude header row, no effect. I have discovered a major clue on what is going on. I did a CSV import, it read maybe 5,000 out of 7,500 rows. I then exported the CSV to try and discover what it thought CSV ought to look like. On looking with a binary capable editor I discover it thought there was a massive numnber of **columns**, exported data is fine but appended to each row are many ,,,,,,,,,,,,,,,,,,,,,,,,,,,, On looking I then see it had adjusted many column widths on CSV import. As a hint the import CSV was 675k, mostly imported. Exporting that to a new CSV produced a 6.92M file, mostly commas. Gnumeric imports the original CSV without bothering with import dialog. Various other software imports without problem. Even if it is bad CSV it ought to be handled gracefully. If a developer wants a test file, please email me. (don't want the file public) --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org