Issue 113688 - Failure to open .csv (file too large)
Summary: Failure to open .csv (file too large)
Status: CLOSED DUPLICATE of issue 75199
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOO330m1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2010-08-05 16:44 UTC by zechs77
Modified: 2010-08-07 19:12 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Problematic .csv file (3.92 MB, text/plain)
2010-08-05 16:47 UTC, zechs77 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description zechs77 2010-08-05 16:44:05 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!
Comment 1 zechs77 2010-08-05 16:47:22 UTC 
Created attachment 70975 [details]
Problematic .csv file
Comment 2 Joe Smith 2010-08-06 15:59:26 UTC 
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
Comment 3 Rainer Bielefeld 2010-08-07 19:11:39 UTC 
I agree with jes' results.

*** This issue has been marked as a duplicate of 75199 ***
Comment 4 Rainer Bielefeld 2010-08-07 19:12:32 UTC 
@zechs77:
Thank you for your attention!
Please feel free to reopen this issue if you find evidence that this one is an
independent issue.