Add rows to Calc sheet

Discuss the spreadsheet application

Add rows to Calc sheet

Postby jesse1233 » Fri Oct 06, 2017 4:50 pm

Is there an extension or a way that I can use Calc with many rows... I need about 600k rows and seems calc maxes out at about 200k
Open office 2.4 Linux Mint 18.2
Posts: 1
Joined: Fri Oct 06, 2017 4:45 pm

Re: add rows to calc sheet

Postby FJCC » Fri Oct 06, 2017 4:59 pm

Calc support 1048575 rows in the recent versions. What is causing you to think it only supports 200000? Are you really on that early version in you signature?
AOO 3.4 or 4.1 on MS Windows XP ( before 2013-08-03) or Windows 7
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Posts: 6033
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: add rows to calc sheet

Postby RusselB » Fri Oct 06, 2017 9:23 pm

Slightly off topic of the original question, however, I'm wondering if Calc is the right tool based on the number of rows required.
At 600,000 rows, it would not be unreasonable to presume that there's a minimum of 3 times that for number of cells required, thus 1,800,000 pieces of data.
While still a beginner with databases, I have to wonder if registering the spreadsheet as a database might not be a wise idea.
OpenOffice 4.1.3 and LibreOffice on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
Posts: 4044
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: add rows to calc sheet

Postby jrkrideau » Fri Oct 06, 2017 9:42 pm

I just loaded a .csv file (600001 X 3) with LibreOffice so any up-to-date version of AOO or LO should have no problem with the number of rows but I'd second RusselB's suggestion that a data base seems more appropriate with that much data.
LibreOffice Ubuntu 17.04 "Zesty Zapus"
Posts: 3343
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: add rows to calc sheet

Postby Villeroy » Sat Oct 07, 2017 5:41 pm

Why do you run a 12 year old version of OpenOffice on a recent Linux desktop? If you are running Linux Mint 18, you already have LibreOffice installed.
If not, run sudo apt-get install libreoffice on the command line.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Posts: 24398
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Return to Calc

Who is online

Users browsing this forum: Yahoo [Bot] and 25 guests