[sc-issues] [Issue 107867] Plain CSV import erroneou s too many rows
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107867 --- Additional comments from ti...@openoffice.org Thu Dec 24 13:20:09 + 2009 --- Created an attachment (id=66794) zip of csv file - 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
[sc-issues] [Issue 107867] Plain CSV import erroneou s too many rows
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107867 --- Additional comments from ti...@openoffice.org Thu Dec 24 13:31:34 + 2009 --- Test CSV file sent. 7281 rows including header row 13 columns, he says superstitiously If this does not induce the problem I expect I can produce variants because it was programatically created here. - 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
[sc-issues] [Issue 107867] Plain CSV import erroneou s too many rows
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 + 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
[sc-issues] [Issue 107867] Plain CSV import erroneou s too many rows
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107867 User atjensen changed the following: What|Old value |New value CC|''|'atjensen' - 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
[sc-issues] [Issue 107867] Plain CSV import erroneou s too many rows
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107867 User rainerbielefeld changed the following: What|Old value |New value CC|'atjensen'|'atjensen,rainerbielefeld' Keywords| |needmoreinfo, oooqa --- Additional comments from rainerbielef...@openoffice.org Thu Dec 24 07:47:00 + 2009 --- @tim_c: Please attach sample documents, you can also send to me a document by personal mail, if it's too big to be attached! - 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