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
jesse1233
 
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.
FJCC
Moderator
 
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 5.1.3.2 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.
RusselB
Volunteer
 
Posts: 4045
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 5.1.4.2 Ubuntu 17.04 "Zesty Zapus"
jrkrideau
Volunteer
 
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
Villeroy
Volunteer
 
Posts: 24399
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 18 guests