Issue 75199 - "Maximum number of rows" message used when there are too many columns
Summary: "Maximum number of rows" message used when there are too many columns
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 78337 106424 113688 (view as issue list)
Depends on:
Blocks:
 
Reported: 2007-03-07 11:36 UTC by jameswilkinson
Modified: 2017-05-20 11:13 UTC (History)
6 users (show)

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

Attachments
File with lots of columns (3.80 KB, application/octet-stream)
2007-03-07 11:37 UTC, jameswilkinson 		no flags Details
1 line with values: 1,2,3,...until 1025 separated with comma (3.92 KB, text/plain)
2010-03-22 12:23 UTC, gibi 		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 jameswilkinson 2007-03-07 11:36:16 UTC 
If you open a CSV file with more than 255 records in one row (too many columns)
you get a message saying "The maximum number of rows has been exceeded. Excess
rows were not imported!"

It *should* say
"The maximum number of columns has been exceeded. Excess columns were not imported!"
(or, of course, just import the thing and support a reasonable number of columns!)
Comment 1 jameswilkinson 2007-03-07 11:37:21 UTC 
Created attachment 43573 [details]
File with lots of columns
Comment 2 frank 2007-03-07 16:12:03 UTC 
Hi Niklas,

we should extend the Messagebox to show Rows or Columns exceeding ...

Frank
Comment 3 frank 2007-06-27 16:24:19 UTC 
*** Issue 76874 has been marked as a duplicate of this issue. ***
Comment 4 frank 2007-07-10 14:25:46 UTC 
*** Issue 78337 has been marked as a duplicate of this issue. ***
Comment 5 frank 2007-07-10 15:47:10 UTC 
*** Issue 78337 has been marked as a duplicate of this issue. ***
Comment 6 Rainer Bielefeld 2009-11-26 08:00:30 UTC 
*** Issue 106424 has been marked as a duplicate of this issue. ***
Comment 7 jbf.faure 2010-03-13 21:03:17 UTC 
Add me to cc.
Comment 8 gibi 2010-03-22 12:17:17 UTC 
OK, now the limit is 1024 rather than 255 but this issue is still alive. So I'm
adding the same testfile but with 1025 columns.
Comment 9 gibi 2010-03-22 12:23:44 UTC 
Created attachment 68471 [details]
1 line with values: 1,2,3,...until 1025 separated with comma
Comment 10 Rainer Bielefeld 2010-08-07 19:11:37 UTC 
*** Issue 113688 has been marked as a duplicate of this issue. ***
Comment 11 rebresb 2011-04-08 00:54:30 UTC 
I still see this bug in version 3.3.0 [OOO330m20 (Build:9567) on WinXP].
Comment 12 arthurgoldberg 2012-07-06 17:39:39 UTC 
Still a bug in OpenOffice.org 3.4.0
on Mac OS X Lion

if "the limit is 1024" then, IMHO, error should say
"The maximum number of columns (1024) has been exceeded."
Comment 13 vulcain 2013-01-28 09:45:24 UTC 
Resolved in LibreOffice 3.6: 
https://bugs.freedesktop.org/show_bug.cgi?id=48516
Comment 14 Marcus 2017-05-20 11:13:30 UTC 
Reset assigne to the default "issues@openoffice.apache.org".