Apache OpenOffice (AOO) Bugzilla – Issue 113688
Failure to open .csv (file too large)
Last modified: 2010-08-07 19:12:32 UTC
We have a .csv file (attached) which does not open properly in OO Calc. Calc returns the error window "Maximum number of rows exceeded. Excess rows were not imported!" It only imports rows up to 13,686. It imports over to column AMJ. I believe this is all the columns in the document. This error occurs on both Windows (XP SP3) and Linux (Fedora 13). It does not occur, however, in Microsoft Excel, so we have determined that the file itself is not damaged or corrupt. Any help is greatly appreciated!
Created attachment 70975 [details] Problematic .csv file
Your csv file contains a line with a text delimiter embedded within the text field; this confuses Calc and you get the misleading error message. Line 12692: "xxxxxxxx"x",529738,,"","xxxxxxxx",xx, , , , , , ... Embedded delimiters must be doubled to prevent Calc from interpreting them as delimters: Line 12692: "xxxxxxxx""x",529738,,"","xxxxxxxx",xx, , , , , , ... This report is a duplicate of Issue 75199
I agree with jes' results. *** This issue has been marked as a duplicate of 75199 ***
@zechs77: Thank you for your attention! Please feel free to reopen this issue if you find evidence that this one is an independent issue.