Apache OpenOffice (AOO) Bugzilla – Issue 80683
maximum number of rows exceeded for CSV file
Last modified: 2007-08-15 08:24:06 UTC
I have a CSV file which has 8,406 rows, and 19 columns. When I attempt to open it, I get the message "The maximum number of rows has been exceeded. Excess rows were not imported!" It then opens the CSV document, but as it stated, not all rows were imported. It ends up importing 6,879 rows. I'm not sure what rows were dropped because they aren't the ones at the beginning, nor are they the rows at the end. Now, if I open this same CSV file in Excel, save it as an XLS file type, and then open the XLS file in Open Office the file imports all the rows and doesn't drop anything. There apparently is an issue with importing CSV files. I can not supply the file due to the propietary data it contains.
Sounds like a double to Issue 78926 and it's doubles. *** This issue has been marked as a duplicate of 78926 ***
closed double