0

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.

Community
  • 1
  • 1
shiny
  • 3,380
  • 9
  • 42
  • 79
  • 1
    Libreoffice [Base](http://www.libreoffice.org/discover/base/) is a [Database Management System](https://help.libreoffice.org/Common/Database_1) like Access is for Microsoft Office. – Axel Richter Dec 19 '16 at 06:10
  • 1
    What kind of file is it -- .ods, .xlsx, or .csv perhaps? LibreOffice Base uses .odb files and can read other types of database files such as dBASE. – Jim K Dec 19 '16 at 16:55

1 Answers1

3

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.

with open("datasource.txt", 'w') as f:
    f.write("id,name\n")
    TEN_MILLION = 10000000
    for id_number in range(TEN_MILLION):
        f.write("%d,abc\n" % id_number)

Open Base by going to File -> New -> Database in the LibreOffice menu. Then connect to an existing database.

connect to Text

Now, the "datasource" table can be viewed by opening it.

datasource table

Jim K
  • 12,824
  • 2
  • 22
  • 51