On Sun, Feb 15, 2009 at 6:11 AM, Dotan Cohen <[email protected]> wrote:
> I have tried opening a CSV file in Calc with 140 rows, but only the > first 81 rows were imported. I got a message during the open that said > that the maximum number of rows has been exceeded. Can Calc really > only import 81 rows from csv files?!? > > I've been able to import portions of CSV files with more rows than Calc supports. It supports 65,536 rows I believe. On my too many row CSV files a message "max rows exceeded" is displayed and the import stops at Calc's row limit. As jonathan wrote I suspect something in the CSV file is being interpreted as "create a new row." I would look at the size of the import file. If it is larger than 64 KB and your rows aren't very wide that would indicate to me there is non display data at the end of some of the rows, most likely the last one imported. That could be verified with a hex editor. If there is non display data at the end of the row in the CSV forcing row imports then I'd look at how the CSV is created. It may be the routine or program producing the CSV is padding with characters that are forcing Calc to import "extra" rows. I have encountered failed row imports with other programs where fewer rows would be imported than I knew to be in the source data. Every time I've encountered such problems the source data, the import file, had unexpected values in it. Correcting the input file has always led to successful import.
