Ask Your Question

More than one million rows in Calc? [closed]

asked 2013-04-24 03:08:50 +0100

Edmund Laugasson gravatar image

updated 2013-05-05 22:06:02 +0100

manj_k gravatar image

I would like to add data into Calc with more than one million rows! How would it be possible? E.g. importing data from database...

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by bencomp
close date 2014-06-29 15:17:33.896436


I would suggest to add unlimited rows and also columns feature into Calc. There might be a problem also with columns quantity.

Edmund Laugasson gravatar imageEdmund Laugasson ( 2013-04-24 03:10:11 +0100 )edit

If there is not enough columns in Calc then you have serious design problem. You will need to import data into database, but make a good data model first...

froz gravatar imagefroz ( 2013-04-24 08:34:38 +0100 )edit
bencomp gravatar imagebencomp ( 2014-06-29 15:17:51 +0100 )edit

4 Answers

Sort by » oldest newest most voted

answered 2013-04-24 03:56:45 +0100

oweng gravatar image

Refer this answer. In simple terms (i.e., within a single sheet) this is currently not possible as row limit is ~1m.

edit flag offensive delete link more

answered 2013-04-24 17:12:59 +0100

Pedro gravatar image

The short answer is: it's not currently possible in Calc.

If you really need a spreadsheet with more than 1 million (2^20) lines , I suggest that you use Gnumeric. You can set up to 16 million (2^24) lines and up to 16384 (=2^14) columns.

Hope this helps ;)

edit flag offensive delete link more

answered 2013-04-24 08:26:23 +0100

froz gravatar image

If you are importing million rows into Calc you got to be doing something wrong... You most probably need a database, so look at LibreOffice Base or some other database out there e.g. MySQL, Postgresql, ... there are also free databases from Microsoft, Oracle, IBM etc.

If you still insist to get so many data into spreadsheet, then try to break data down to multiple sheets.

edit flag offensive delete link more

answered 2013-04-24 16:19:20 +0100

m.a.riosv gravatar image

Maybe you can connect with Base to your database and run a view to organize, select and summarizing data for calc, also Pivot Table can use a table or a view from a register database to operate. What is the data source?

edit flag offensive delete link more

Question Tools


Asked: 2013-04-24 03:08:50 +0100

Seen: 8,769 times

Last updated: Apr 24 '13