in a linux system, i've experienced scalc (OpenOffice 2.4) open a csv file entirely, but the line count is "off" (indicates 15963 lines instead of >16000 in vim). I narrowed it down to records in the file that have a DOS(?) linefeed or end of line (looks like a ^M in vim) in the record. Vim causes the line(s) to look like this:
1 "blah1","blah2" 2 "blah3","blah4 blah^M 3 " 4 "more blah","blah" In scalc, it looks like: 1 "blah1","blah2" 2 "blah3","blah4 blah" 3 "more blah","blah" You get the picture. So, maybe in the end of scalc reading the file there is some linecount comparison that indicates a discrepancy, which causes the warning about not all rows being imported. anyway, this was m experience. [EMAIL PROTECTED] wrote: > > Hi all, > > I receive an error message when Calc opens a *.csv file. > > ################################################################### > The maximum number of rows has been exceeded. Excess rows were not > imported. > ################################################################### > > System Info: uname -a: Linux LS1 2.6.22.17-0.1-default #1 SMP 2008/02/10 > 20:01:04 UTC x86_64 x86_64 x86_64 GNU/Linux; > OpenOffice.org 2.4; > > File info: After the error it opens, and has the following size - Number > of rows = 3596 : Columns = IV > > Not imported: Number of rows = 3596 to 12726 > > Is there a maximum number of rows and columns Calc can handle? > > :-) > Al > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/Maximum-number-of-rows-and-columns-in-Calc--tp17106361p18876185.html Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
