To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113705 Issue #|113705 Summary|Can't open some csv file with all lines / quotes probl |em Component|Spreadsheet Version|OOo 3.2.1 Platform|Macintosh URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|raiten
------- Additional comments from rai...@openoffice.org Fri Aug 6 10:13:48 +0000 2010 ------- When opening a csv file (254 lines, separator ';' as utf8, with french accents), I get the following message in French: "Le nombre maximal de lignes a été dépassé. Les lignes excédentaires n'ont pas pu être importées !" (approximative translation: The maximum line number has been exceeded. The extra lines weren't imported !) and the file is opened with only 52 first lines which correspond to the ones show in preview ... In other case, it opens the file with only some lines and no warning. I can't share the original file but I try different command to anonymize it and see if I can reproduce the error sed 's@".*";@"yyyyyyyyyy";@g' => OK (no error, complete import) sed 's@".*";".*";".*";".*";".*";@"y1";"y2";"y3";"y4";"y5";@g' => OK after some more testing, it seems linked to quotes in a field like "xvcbvcbc"cvx";"ccvxv";"xbcvb"; or "bcbvc"vxcvc"xbvcb";"vbvc";"xbcvb" In some case, openoffice removes them, in other, it fails silently. Trying to escape them in an unix way (\") doesn't help. removing them makes opening ok. the following issues seems related: 113688, 60110 Maybe: 93488 Tested on OpenOffice Mac 3.1.1 and 3.2.1 --------------------------------------------------------------------- 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