I have a file that has ten million rows. I want to open it using OpenOffice Calc but OpenOffice Calc 3.3.3 has a limit of around one million rows.
If you follow this link, the answer mentioned that the Base module of LibreOffice has NO ROW LIMIT.
I have a file that has ten million rows. I want to open it using OpenOffice Calc but OpenOffice Calc 3.3.3 has a limit of around one million rows.
If you follow this link, the answer mentioned that the Base module of LibreOffice has NO ROW LIMIT.
LibreOffice Base can use
Text
files as the data source. Documentation is here: https://help.libreoffice.org/Common/Text_File_Connection.To test this, the following python script produces a text file with ten million rows.
Open Base by going to File -> New -> Database in the LibreOffice menu. Then connect to an existing database.
Now, the "datasource" table can be viewed by opening it.