Add rows to Calc sheet
Add rows to Calc sheet
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
Re: add rows to calc sheet
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?
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: add rows to calc sheet
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.
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.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
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.
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.
Re: add rows to calc sheet
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 7.3.7. 2; Ubuntu 22.04
Re: add rows to calc sheet
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.
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 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice