Issue 106424 - Wrong message concerning too many rows instead of too many columns shown
Summary: Wrong message concerning too many rows instead of too many columns shown
Status: CLOSED DUPLICATE of issue 75199
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOO310m19
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2009-10-29 11:23 UTC by stevechiz
Modified: 2009-11-26 11:51 UTC (History)
3 users (show)

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

Attachments
This is the file which cased the import issue (144.23 KB, text/plain)
2009-10-29 11:28 UTC, stevechiz 		no flags Details
comparison of OOo and excel import. (127.00 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-10-29 19:48 UTC, raal 		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 stevechiz 2009-10-29 11:23:04 UTC 
When importing a CSV file, the warning message that "maximum number of lines 
exceeded" appears even though only 408 rows were actually imported. The limit 
on CSV files is reported as 64K rows. The CSV file in question contained 573 
rows of text and numeric CSV data. It was 145 Kbytes in size and does not 
contain any unusual characters or sequences. I would be happy to email a copy 
of the file used as this will aid diagnosis of the problem.
Comment 1 stevechiz 2009-10-29 11:28:38 UTC 
Created attachment 65748 [details]
This is the file which cased the import issue
Comment 2 stevechiz 2009-10-29 11:30:09 UTC 
The file in question has now been attached. Note: I encountered the same 
problem 2 days ago with another file
Comment 3 raal 2009-10-29 19:47:29 UTC 
Reproducible with version 3.1.1.
Reproducible with version OOO320m2.

In excel I can import all 573 rows.

Problem is on row 184, see attachment.
Comment 4 raal 2009-10-29 19:48:34 UTC 
Created attachment 65776 [details]
comparison of OOo and excel import.
Comment 5 Joe Smith 2009-10-29 20:54:27 UTC 
Your csv file is broken. There are unpaired quotes (and possibly missing data)
on lines 184, 315, 384 and 418.

If you edit the CSV file to at least provide the missing double quotes, Calc
will load the file.

I believe this already covered by Issue 78926
Comment 6 Rainer Bielefeld 2009-10-30 06:57:39 UTC 
Reproducible with "Ooo 3.1.1 WIN XP DE-multilingual version German UI activated
[OOO310m19 (Build 9420)]" 
and
"2.4.1  Multilingual version German UI WIN XP: [680m17(Build9310)]"

I believe this is simply the wrong message, it's the number of columns that
causes the problem. After import, please look into row 184 and check last
column, 'AMJ' contains "Quarterly", several further columns (,,"D","A","M") are
missing.
Comment 7 Rainer Bielefeld 2009-11-26 08:00:41 UTC 
DUP

*** This issue has been marked as a duplicate of 75199 ***
Comment 8 Rainer Bielefeld 2009-11-26 11:51:45 UTC 
no objections, so CLOSED