[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 because of incorrect row termination
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 17:59:51 + 2009 --- Not line ends but looks like you have found a problem line, and this raises some CSV parser issues. Row 1347 shows a normal cr/lf pair. Previously tried single lf version of file, same effect. (is actually being created by Lua f:write(blah, '\n') What does exist is row 1347 is a quoted field containing text with periods. ,CMSVICE.DO.M, and a quote, so this spins off into the problem of define what exactly is CSV, include if and how escapes are done. The original fixed field width data being translated into CSV contain both ' and within text fields. I was unaware of the within text fields, sorry. The solution for OO is likely to be firming up the design of the CSV parser. - 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 because of incorrect row termination
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 18:22:15 + 2009 --- Confirmed the data causal by substituting for ' within quoted CSV fields. Import than works correctly. - 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
[sw-issues] [Issue 105026] XY Chart paste into Write r broken X axis
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105026 Issue #|105026 Summary|XY Chart paste into Writer broken X axis Component|Word processor 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|writerneedsconfirm Reported by|tim_c --- Additional comments from ti...@openoffice.org Sat Sep 12 18:26:38 + 2009 --- Paste of a not trivial XY chart into Writer corrupts X axis. (source of copy is unaffected) Paste of the same item into Calc, Impress, Draw all work as expected. Paste of a trivial chart into Writer works as expected. Method: calc open with data, new writer, copy chart from calc and paste into writer This breakage seems to have appeared between 3.1.1 dev (which I was using) and 3.1.1 release as security fix. (it previously worked and since the security patch seems to only involve Writer, go figure) - 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...@sw.openoffice.org For additional commands, e-mail: issues-h...@sw.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sw-issues] [Issue 105026] XY Chart paste into Write r broken X axis
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105026 --- Additional comments from ti...@openoffice.org Sat Sep 12 18:30:31 + 2009 --- Created an attachment (id=64729) Draw doc containing example chart for copy and paste into Writer - 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...@sw.openoffice.org For additional commands, e-mail: issues-h...@sw.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sw-issues] [Issue 105026] XY Chart paste into Write r broken X axis
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105026 --- Additional comments from ti...@openoffice.org Sat Sep 12 21:48:52 + 2009 --- Yes 3.2 is still ok (just reinstalled it). It was before the 3.1.1 production release. (was installed here but is not usable) Question: has 3.2 received the Writer security fix? If so can the differences be migrated to stable release 3.1.x? - 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...@sw.openoffice.org For additional commands, e-mail: issues-h...@sw.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org